[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,
668: -- Bug 16298972 End
669: ELSE -- foreign currency remittance batch
670: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
669: ELSE -- foreign currency remittance batch
670: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
670: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
671: IF l_DEBUG in ('Y', 'C') THEN
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
672: cep_standard.debug('receipt_id = '|| receipt_id);
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
673: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
674: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
675: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
676: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
678:
679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
686:
680: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
686:
687: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
688: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
681: cep_standard.debug('module = '|| module );
682: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
686:
687: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
688: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
689: END IF;
683:
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
686:
687: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
688: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
689: END IF;
690:
691: IF ((trx_currency_type = 'FOREIGN') and
684: cep_standard.debug('trx_amount = '|| trx_amount);
685: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
686:
687: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
688: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
689: END IF;
690:
691: IF ((trx_currency_type = 'FOREIGN') and
692: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
698: ext_precision,
699: min_acct_unit);
700:
701: IF l_DEBUG in ('Y', 'C') THEN
702: cep_standard.debug('precision = '|| precision);
703: END IF;
704:
705: amount_to_clear := round(adjusted_xrate_amount, precision) ;
706:
706:
707: END IF;
708: IF l_DEBUG in ('Y', 'C') THEN
709:
710: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
711: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
712: END IF;
713:
714: ARP_CASHBOOK.clear(
707: END IF;
708: IF l_DEBUG in ('Y', 'C') THEN
709:
710: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
711: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
712: END IF;
713:
714: ARP_CASHBOOK.clear(
715: p_cr_id => receipt_id,
732: -- Bug 16298972 End
733: END IF;
734: END IF;
735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
733: END IF;
734: END IF;
735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
734: END IF;
735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
735: IF l_DEBUG in ('Y', 'C') THEN
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
736: cep_standard.debug('after call');
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
737: cep_standard.debug('receipt_id = '|| receipt_id);
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
738: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
739: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
740: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
741: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
743:
744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
745: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
746: cep_standard.debug('module = '|| module );
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
754: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
747: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
754: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
755: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
748:
749: cep_standard.debug('trx_amount = '|| trx_amount);
750: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
751: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
754: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
755: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
756: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
823: -- Bug 16298972 End
824: ELSE -- foreign currency remittance batch
825: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
824: ELSE -- foreign currency remittance batch
825: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
825: -- bug 3911424 used the new xrate, xrate date, xrate type and xrate amount cleared
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
826: IF l_DEBUG in ('Y', 'C') THEN
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
827: cep_standard.debug('receipt_id = '|| receipt_id);
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
828: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
829: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
830: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
831: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
833:
834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
841:
835: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
841:
842: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
843: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
836: cep_standard.debug('module = '|| module );
837: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
841:
842: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
843: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
844: END IF;
838:
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
841:
842: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
843: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
844: END IF;
845:
846: IF ((trx_currency_type = 'FOREIGN') and
839: cep_standard.debug('trx_amount = '|| trx_amount);
840: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
841:
842: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
843: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
844: END IF;
845:
846: IF ((trx_currency_type = 'FOREIGN') and
847: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
853: ext_precision,
854: min_acct_unit);
855:
856: IF l_DEBUG in ('Y', 'C') THEN
857: cep_standard.debug('precision = '|| precision);
858: END IF;
859:
860: amount_to_clear := round(adjusted_xrate_amount, precision) ;
861:
861:
862: END IF;
863: IF l_DEBUG in ('Y', 'C') THEN
864:
865: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
866: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
867: END IF;
868:
869: ARP_CASHBOOK.clear(
862: END IF;
863: IF l_DEBUG in ('Y', 'C') THEN
864:
865: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
866: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
867: END IF;
868:
869: ARP_CASHBOOK.clear(
870: p_cr_id => receipt_id,
887: -- Bug 16298972 End
888: END IF;
889: END IF;
890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
888: END IF;
889: END IF;
890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
889: END IF;
890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
890: IF l_DEBUG in ('Y', 'C') THEN
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
891: cep_standard.debug('after call');
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
892: cep_standard.debug('receipt_id = '|| receipt_id);
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
893: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
894: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
895: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
896: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
898:
899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
900: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
907: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
908: END IF;
901: cep_standard.debug('module = '|| module );
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
907: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
908: END IF;
909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
902: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
907: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
908: END IF;
909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
910: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
903:
904: cep_standard.debug('trx_amount = '|| trx_amount);
905: cep_standard.debug('trx_exchange_rate_date = '|| trx_exchange_rate_date );
906: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
907: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
908: END IF;
909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
910: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
911: -- 5637589
984: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
985: END IF;
986: END IF;
987: IF l_DEBUG in ('Y', 'C') THEN
988: cep_standard.debug('<
990: EXCEPTION
991: WHEN OTHERS THEN
992: -- bug 2875549
989: END IF;
990: EXCEPTION
991: WHEN OTHERS THEN
992: -- bug 2875549
993: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_rbatch');
994: if (passin_mode = 'AUTO') then
995: IF rbatch_cursor%ISOPEN THEN
996: CLOSE rbatch_cursor;
997: END IF;
1056:
1057:
1058: BEGIN
1059: IF l_DEBUG in ('Y', 'C') THEN
1060: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1061: END IF;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;
1069: CE_AUTO_BANK_MATCH.csl_payroll_payment_format := X_payroll_payment_format;
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1070: CE_AUTO_BANK_MATCH.csl_reconcile_flag := cleared_trx_type;
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1071:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1072: IF l_DEBUG in ('Y', 'C') THEN
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1073: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_bank_trx_number = '|| CE_AUTO_BANK_MATCH.csl_bank_trx_number);
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1081:
1074: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csh_bank_account_id = '|| CE_AUTO_BANK_MATCH.csh_bank_account_id);
1075: cep_standard.debug('>>CE_AUTO_BANK_MATCH.trx_group = '|| CE_AUTO_BANK_MATCH.trx_group);
1076: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_payroll_payment_format = '|| CE_AUTO_BANK_MATCH.csl_payroll_payment_format);
1077: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_reconcile_flag = '|| CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1081:
1082: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1089: IF( passin_mode IN ( 'AUTO') AND (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'PAY_EFT')) THEN
1090: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1091:
1092: IF l_DEBUG in ('Y', 'C') THEN
1093: cep_standard.debug('reconcile_pay_eft ' );
1094: cep_standard.debug('>>open pay_eft_cursor ');
1095: END IF;
1096:
1097: OPEN pay_eft_cursor;
1090: --IF (substr(CE_AUTO_BANK_MATCH.csl_payroll_payment_format,1,4) = 'BACS') THEN
1091:
1092: IF l_DEBUG in ('Y', 'C') THEN
1093: cep_standard.debug('reconcile_pay_eft ' );
1094: cep_standard.debug('>>open pay_eft_cursor ');
1095: END IF;
1096:
1097: OPEN pay_eft_cursor;
1098: LOOP
1096:
1097: OPEN pay_eft_cursor;
1098: LOOP
1099: IF l_DEBUG in ('Y', 'C') THEN
1100: cep_standard.debug('>>fetch pay_eft_cursor ');
1101: END IF;
1102:
1103: FETCH pay_eft_cursor INTO cleared_trx_id,
1104: amount_to_clear,
1104: amount_to_clear,
1105: l_gt_seq_id;
1106:
1107: IF l_DEBUG in ('Y', 'C') THEN
1108: cep_standard.debug('>>pay_eft_cursor cleared_trx_id = '|| cleared_trx_id);
1109: cep_standard.debug('>>pay_eft_cursor amount_to_clear = '|| amount_to_clear);
1110: END IF;
1111:
1112: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1105: l_gt_seq_id;
1106:
1107: IF l_DEBUG in ('Y', 'C') THEN
1108: cep_standard.debug('>>pay_eft_cursor cleared_trx_id = '|| cleared_trx_id);
1109: cep_standard.debug('>>pay_eft_cursor amount_to_clear = '|| amount_to_clear);
1110: END IF;
1111:
1112: EXIT WHEN pay_eft_cursor%NOTFOUND OR pay_eft_cursor%NOTFOUND IS NULL;
1113:
1121: */
1122:
1123:
1124: IF l_DEBUG in ('Y', 'C') THEN
1125: cep_standard.debug('reconcile_pay_eft: ' || '>>> Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'|| '-----' ||
1126: ' reconcile_pay_eft: ' || '>>> p_payment_id = '|| cleared_trx_id||
1127: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1128: ' p_trx_amount = '|| NVL(amount_to_clear,0)||
1129: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
1138: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
1139: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
1140:
1141: IF l_DEBUG in ('Y', 'C') THEN
1142: cep_standard.debug('reconcile_pay_eft: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
1143: END IF;
1144:
1145:
1146: IF l_DEBUG in ('Y', 'C') THEN
1143: END IF;
1144:
1145:
1146: IF l_DEBUG in ('Y', 'C') THEN
1147: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1148: ',cleared_trx_id='||to_char(cleared_trx_id));
1149: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1150: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1151: END IF;
1145:
1146: IF l_DEBUG in ('Y', 'C') THEN
1147: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1148: ',cleared_trx_id='||to_char(cleared_trx_id));
1149: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1150: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1151: END IF;
1152:
1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1146: IF l_DEBUG in ('Y', 'C') THEN
1147: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1148: ',cleared_trx_id='||to_char(cleared_trx_id));
1149: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1150: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1151: END IF;
1152:
1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1154: Y_cleared_trx_type => cleared_trx_type,
1165: END IF;
1166:
1167:
1168: IF l_DEBUG in ('Y', 'C') THEN
1169: cep_standard.debug('reconcile_pay_eft: ' || '<<< End CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1170: END IF;
1171:
1172: END LOOP; -- pay_eft_cursor
1173: CLOSE pay_eft_cursor;
1174:
1175: END IF;
1176:
1177: IF l_DEBUG in ('Y', 'C') THEN
1178: cep_standard.debug('<
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1178: cep_standard.debug('<
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1183: IF pay_eft_cursor%ISOPEN THEN
1184: CLOSE pay_eft_cursor;
1185: END IF;
1186: RAISE;
1235: current_org_id number;
1236: X_REMIT_BANK_ACCT_USE_ID number;
1237: BEGIN
1238: IF l_DEBUG in ('Y', 'C') THEN
1239: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.misc_receipt');
1240: END IF;
1241: IF (X_statement_line_id IS NULL) THEN
1242: OPEN C_STATEMENT_LINE_SEQ;
1243: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;
1319: into current_org_id
1320: from dual;
1321:
1322: IF l_DEBUG in ('Y', 'C') THEN
1323: cep_standard.debug('current_org_id =' ||current_org_id );
1324:
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1321:
1322: IF l_DEBUG in ('Y', 'C') THEN
1323: cep_standard.debug('current_org_id =' ||current_org_id );
1324:
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1322: IF l_DEBUG in ('Y', 'C') THEN
1323: cep_standard.debug('current_org_id =' ||current_org_id );
1324:
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1323: cep_standard.debug('current_org_id =' ||current_org_id );
1324:
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1324:
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1325: cep_standard.debug('X_trx_number =' ||X_trx_number );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1326: cep_standard.debug('l_doc_seq_value =' ||l_doc_seq_value );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1327: cep_standard.debug('l_doc_seq_id =' ||l_doc_seq_id );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1328: cep_standard.debug('X_gl_date =' ||X_gl_date );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1329: cep_standard.debug('X_trx_date =' ||X_trx_date );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1330: cep_standard.debug('X_deposit_date =' ||X_deposit_date );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1331: cep_standard.debug('X_amount =' ||X_amount );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1332: cep_standard.debug('X_misc_currency_code =' ||X_misc_currency_code );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1333: cep_standard.debug('X_exchange_rate_date =' ||X_exchange_rate_date );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1334: cep_standard.debug('X_exchange_rate_type =' ||X_exchange_rate_type );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1335: cep_standard.debug('X_exchange_rate =' ||X_exchange_rate );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1336: cep_standard.debug('X_receipt_method_id =' ||X_receipt_method_id );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1337: cep_standard.debug('X_bank_account_id =' ||X_bank_account_id );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1338: cep_standard.debug('X_activity_type_id =' ||X_activity_type_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1339: cep_standard.debug('X_comments =' ||X_comments );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1347: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1340: cep_standard.debug('X_tax_id =' ||X_tax_id );
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1347: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1348:
1341: cep_standard.debug('X_reference_type =' ||X_reference_type );
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1347: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1348:
1349: END IF;
1342: cep_standard.debug('X_reference_id =' ||X_reference_id );
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1347: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1348:
1349: END IF;
1350:
1343: cep_standard.debug('X_paid_from =' ||X_paid_from );
1344: cep_standard.debug('X_effective_date =' ||X_effective_date );
1345: cep_standard.debug('X_module_name =' ||X_module_name );
1346: --cep_standard.debug('X_cr_id =' ||X_cr_id );
1347: cep_standard.debug('X_tax_rate =' ||X_tax_rate );
1348:
1349: END IF;
1350:
1351: -- bug 5185358/5221366 p_remit_bank_account_id is the
1367:
1368: EXCEPTION
1369: WHEN NO_DATA_FOUND THEN
1370: IF l_DEBUG in ('Y', 'C') THEN
1371: cep_standard.debug('X_receipt_method_id does not exists ' || 'No data found');
1372: END IF;
1373: CE_RECONCILIATION_ERRORS_PKG.insert_row(
1374: CE_AUTO_BANK_MATCH.csh_statement_header_id,
1375: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
1375: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'CE_TEMP_AR_METHOD_ORG_INVALID');
1376: END;
1377:
1378: IF l_DEBUG in ('Y', 'C') THEN
1379: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1380: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1381: END IF;
1382:
1383: ARP_CASHBOOK.ins_misc_txn(
1376: END;
1377:
1378: IF l_DEBUG in ('Y', 'C') THEN
1379: cep_standard.debug('X_REMIT_BANK_ACCT_USE_ID = '||X_REMIT_BANK_ACCT_USE_ID);
1380: cep_standard.debug('call ARP_CASHBOOK.ins_misc_txn ');
1381: END IF;
1382:
1383: ARP_CASHBOOK.ins_misc_txn(
1384: p_receipt_number => X_trx_number,
1406: p_cr_id => X_cr_id,
1407: p_tax_rate => abs(X_tax_rate));
1408:
1409: IF l_DEBUG in ('Y', 'C') THEN
1410: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1411: cep_standard.debug('X_cr_id = '|| X_cr_id);
1412:
1413: END IF;
1414:
1407: p_tax_rate => abs(X_tax_rate));
1408:
1409: IF l_DEBUG in ('Y', 'C') THEN
1410: cep_standard.debug('end call ARP_CASHBOOK.ins_misc_txn ');
1411: cep_standard.debug('X_cr_id = '|| X_cr_id);
1412:
1413: END IF;
1414:
1415: -- set this in the form mo_global.set_policy_context('M',null);
1465: Y_status_flag => 'M',
1466: Y_amount => X_bank_account_amount);
1467: END IF;
1468: IF l_DEBUG in ('Y', 'C') THEN
1469: cep_standard.debug('<
1471: END misc_receipt;
1472:
1473: /* ---------------------------------------------------------------------
1512: x_legal_entity_id number;
1513: clearing_flag VARCHAR2(1) := 'N'; -- Bug 13803033
1514: BEGIN
1515: IF l_DEBUG in ('Y', 'C') THEN
1516: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1517: cep_standard.debug('passin_mode='||passin_mode );
1518: END IF;
1519: auto_reconciled_flag := 'Y';
1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1513: clearing_flag VARCHAR2(1) := 'N'; -- Bug 13803033
1514: BEGIN
1515: IF l_DEBUG in ('Y', 'C') THEN
1516: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1517: cep_standard.debug('passin_mode='||passin_mode );
1518: END IF;
1519: auto_reconciled_flag := 'Y';
1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1521: X_effective_date,
1569: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1570: -- bug 5350073 ce_available_transactions_tmp is not populated when
1571: -- manually reconcile IBY batches
1572: IF (passin_mode = 'AUTO' ) THEN
1573: cep_standard.debug('open pbatch_cursor');
1574:
1575: OPEN pbatch_cursor(pbatch_id, pgroup_id );-- FOR SEPA ER 6700007
1576: LOOP
1577: FETCH pbatch_cursor INTO check_id, check_status, batch_trx_type, batch_app_id, l_gt_seq_id;
1585: where seq_id = l_gt_seq_id;
1586: 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||', l_gt_seq_id='||l_gt_seq_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||', l_gt_seq_id='||l_gt_seq_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1595: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
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||', l_gt_seq_id='||l_gt_seq_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1595: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1596: Y_cleared_trx_id => check_id,
1606:
1607: END LOOP; -- pbatch_cursor
1608: CLOSE pbatch_cursor;
1609: ELSE -- manual reconciliation
1610: cep_standard.debug('open manual_pbatch_cursor ');
1611:
1612: OPEN manual_pbatch_cursor(pbatch_id, pgroup_id );-- FOR SEPA ER 6700007
1613: LOOP
1614: FETCH manual_pbatch_cursor
1616: x_org_id, x_legal_entity_id;
1617: EXIT WHEN manual_pbatch_cursor%NOTFOUND OR manual_pbatch_cursor%NOTFOUND IS NULL;
1618:
1619: IF l_DEBUG in ('Y', 'C') THEN
1620: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1621: ', check_id='||check_id||',check_status='||check_status );
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1618:
1619: IF l_DEBUG in ('Y', 'C') THEN
1620: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1621: ', check_id='||check_id||',check_status='||check_status );
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1619: IF l_DEBUG in ('Y', 'C') THEN
1620: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1621: ', check_id='||check_id||',check_status='||check_status );
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1640: ------------------------------------------------------------------------
1641:
1642: /*
1643: IF l_DEBUG in ('Y', 'C') THEN
1644: cep_standard.debug('reconcile_pbatch: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'|| chr(10) ||
1645: 'X_CHECKRUN_ID: '||to_char(pbatch_id)|| chr(10) ||
1646: 'pgroup_id: '||to_char(pgroup_id)|| chr(10) ||
1647: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date|| chr(10) ||
1648: 'X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date|| chr(10) ||
1658: END IF;
1659: */
1660: ------------------------------------------------------------------------------
1661: IF l_DEBUG in ('Y', 'C') THEN
1662: cep_standard.debug('pbatch_id='||pbatch_id||', CE_AUTO_BANK_REC.G_gl_date='||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1663: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1664:
1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1661: IF l_DEBUG in ('Y', 'C') THEN
1662: cep_standard.debug('pbatch_id='||pbatch_id||', CE_AUTO_BANK_REC.G_gl_date='||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1663: ', CE_AUTO_BANK_MATCH.csl_trx_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1664:
1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1667:
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1664:
1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1667:
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1671:
1672: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1671:
1672: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1673: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);
1674:
1675: END IF;
1676:
1675: END IF;
1676:
1677: --check if pbatch_id is a AP batch or IBY batch
1678: if (batch_app_id = 200) THEN
1679: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1680:
1681: AP_RECONCILIATION_PKG.recon_payment_history(
1682: X_CHECKRUN_ID => pbatch_id,
1683: X_CHECK_ID => to_number(NULL),
1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );
1708: IF l_DEBUG in ('Y', 'C') THEN
1709: cep_standard.debug('reconcile_pbatch: ' || '<<
1711:
1712: else --IBY batches
1713:
1710: END IF;
1711:
1712: else --IBY batches
1713:
1714: cep_standard.debug('call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1715: IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing(
1716: P_PAYMENT_INSTRUCTION_ID => pbatch_id,
1717: P_ACCOUNTING_DATE => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1718: P_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1741: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1742:
1743: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1744:
1745: end if;
1746: ------------------------------------
1747: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1745: end if;
1746: ------------------------------------
1747: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436677
1748: IF l_DEBUG in ('Y', 'C') THEN
1749: cep_standard.debug('update ce_statement_reconcils_all');
1750: END IF;
1751: --update ce_statement_reconciliations r
1752: update ce_statement_reconcils_all r
1753: set amount =
1762: and current_record_flag = 'Y'
1763: and amount is null;
1764: END IF;
1765: IF l_DEBUG in ('Y', 'C') THEN
1766: cep_standard.debug('<
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1766: cep_standard.debug('<
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1771: if (passin_mode = 'AUTO') then
1772: IF pbatch_cursor%ISOPEN THEN
1773: CLOSE pbatch_cursor;
1774: END IF;
1822: x_trx_amount2 NUMBER;
1823: x_trx_amount3 NUMBER;
1824: BEGIN
1825: IF l_DEBUG in ('Y', 'C') THEN
1826: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1827: END IF;
1828: IF (passin_mode <> 'MANUAL_C') THEN
1829: clearing_flag := 'Y';
1830: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1862: CE_AUTO_BANK_MATCH.csl_trx_date := sysdate;
1863: END IF;
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1864: END IF;
1865: IF l_DEBUG in ('Y', 'C') THEN
1866: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_trx_type ='|| CE_AUTO_BANK_MATCH.csl_trx_type ||
1867: ', CE_AUTO_BANK_MATCH.reversed_receipt_flag = ' ||CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1868: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_match_correction_type =' || CE_AUTO_BANK_MATCH.csl_match_correction_type ||
1869: ', CE_AUTO_BANK_MATCH.reconciled_this_run = '|| CE_AUTO_BANK_MATCH.reconciled_this_run);
1870: END IF;
1871:
1872:
1896: -- bug 922650
1897: -- update actual_value_date in AR_CASH_RECEIPS table.
1898: --
1899: IF l_DEBUG in ('Y', 'C') THEN
1900: cep_standard.debug('call ARP_CASHBOOK.update_actual_value_date');
1901: END IF;
1902:
1903: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1904: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1903: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
1904: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
1905: ELSE
1906: IF l_DEBUG in ('Y', 'C') THEN
1907: cep_standard.debug('reconcile_stmt: ' || 'RECEIPT: amount_cleared = '|| to_char(amount_cleared)||
1908: 'RECEIPT: charges_amount = '|| to_char(charges_amount));
1909: END IF;
1910: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_DEBIT') then
1911: clearing_sign := -1;
1913: clearing_sign := 1;
1914: end if;
1915: cleared_trx_type := 'RECEIPT';
1916: IF l_DEBUG in ('Y', 'C') THEN
1917: cep_standard.debug('call ARP_CASHBOOK.clear');
1918: END IF;
1919: ARP_CASHBOOK.clear(
1920: p_cr_id => to_number(ar_cash_receipt_id),
1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1939: END IF;
1940: elsif (CE_AUTO_BANK_MATCH.trx_match_type = 'PAYMENT') then
1941: IF( trx_status NOT IN ( 'STOP INITIATED', 'VOIDED' )) THEN
1942: IF l_DEBUG in ('Y', 'C') THEN
1943: cep_standard.debug('reconcile_stmt: ' || 'PAYMENT: amount_cleared = '|| to_char(amount_cleared)||
1944: 'PAYMENT: charges_amount = '|| to_char(charges_amount));
1945: END IF;
1946: if (CE_AUTO_BANK_MATCH.csl_trx_type = 'MISC_CREDIT') then
1947: clearing_sign := -1;
1958: end if;
1959: end if;
1960:
1961: IF l_DEBUG in ('Y', 'C') THEN
1962: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1963: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1964: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1965: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1966: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1961: IF l_DEBUG in ('Y', 'C') THEN
1962: cep_standard.debug('reconcile_stmt: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history'||
1963: 'X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
1964: 'X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
1965: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1966: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1967: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1968: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1969: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1965: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
1966: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1967: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1968: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1969: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1970: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1971: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1972: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1973: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1968: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1969: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1970: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1971: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1972: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1973: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1974: END IF;
1975:
1976: IF l_DEBUG in ('Y', 'C') THEN
1973: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1974: END IF;
1975:
1976: IF l_DEBUG in ('Y', 'C') THEN
1977: cep_standard.debug('call AP_RECONCILIATION_PKG.recon_payment_history');
1978: END IF;
1979:
1980: AP_RECONCILIATION_PKG.recon_payment_history(
1981: X_CHECKRUN_ID => to_number(NULL),
2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN
2008: cep_standard.debug('reconcile_stmt: ' || '<<
2010: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2011: cleared_trx_type := 'PAYMENT';
2012: END IF;
2016: else
2017: clearing_sign := 1;
2018: end if;
2019: IF l_DEBUG in ('Y', 'C') THEN
2020: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2021: END IF;
2022:
2023:
2024: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2055: x_trx_amount2 := x_trx_amount;
2056: end if;
2057: end if;
2058: IF l_DEBUG in ('Y', 'C') THEN
2059: cep_standard.debug('reconcile_stmt: ' || 'DEBUG: trx_type2 = '|| CE_AUTO_BANK_MATCH.trx_type2||
2060: ' x_trx_amount = '|| x_trx_amount||' x_trx_amount2 = '|| x_trx_amount2);
2061: END IF;
2062: end if;
2063: -- Need to calculate cleared amount, x_amount_cleared, here.
2061: END IF;
2062: end if;
2063: -- Need to calculate cleared amount, x_amount_cleared, here.
2064: IF l_DEBUG in ('Y', 'C') THEN
2065: cep_standard.debug('update ce_statement_reconcils_all');
2066: END IF;
2067: --update ce_statement_reconciliations
2068: update ce_statement_reconcils_all
2069: set current_record_flag = 'N'
2113: end if;*/
2114: end if;
2115:
2116: IF l_DEBUG in ('Y', 'C') THEN
2117: cep_standard.debug('reconcile_stmt: DEBUG: x_trx_amount3 = '|| x_trx_amount3
2118: ||', CE_AUTO_BANK_MATCH.csl_trx_type: ' ||CE_AUTO_BANK_MATCH.csl_trx_type
2119: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2120: END IF;
2121:
2131: Y_amount => x_trx_amount3);
2132: --Y_amount => CE_AUTO_BANK_MATCH.corr_csl_amount);
2133: else /* CE_AUTO_BANK_MATCH.reconciled_this_run = 'Y' */
2134: IF l_DEBUG in ('Y', 'C') THEN
2135: cep_standard.debug('update ce_statement_reconcils_all');
2136: END IF;
2137: --update ce_statement_reconciliations
2138: update ce_statement_reconcils_all
2139: set statement_line_Id = CE_AUTO_BANK_MATCH.csl_statement_line_id,
2189: CE_AUTO_BANK_CLEAR.update_line_status(
2190: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2191: end if;
2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('<
2195: END reconcile_stmt;
2196:
2197: /* ---------------------------------------------------------------------
2239: X_RESULT VARCHAR2(100);
2240: X_RECONCILED_METHOD VARCHAR2(1);
2241: current_org_id NUMBER;
2242: BEGIN
2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2245:
2246: -- Bug 16298972 Start
2247: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for manual recon.
2240: X_RECONCILED_METHOD VARCHAR2(1);
2241: current_org_id NUMBER;
2242: BEGIN
2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2245:
2246: -- Bug 16298972 Start
2247: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for manual recon.
2248: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2372: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2373:
2374: ELSIF (CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'CASHFLOW')
2375: THEN
2376: cep_standard.debug('reconcile_trx: calling CE_CASHFLOW_PKG.CLEAR_CASHFLOW');
2377: CE_CASHFLOW_PKG.CLEAR_CASHFLOW(
2378: X_CASHFLOW_ID => CE_AUTO_BANK_MATCH.trx_id,
2379: X_TRX_STATUS => CE_AUTO_BANK_MATCH.trx_status,
2380: x_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2407: THEN
2408: FND_MESSAGE.set_name( 'CE', 'CE_STOP_VOID');
2409: RAISE APP_EXCEPTION.application_exception;
2410: ELSE
2411: cep_standard.debug('...Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2412: 'p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2413: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2414: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2415: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2410: ELSE
2411: cep_standard.debug('...Calling PAY_CE_RECONCILIATION_PKG.reconcile_payment'||
2412: 'p_payment_id = '|| to_char(CE_AUTO_BANK_MATCH.trx_id)||
2413: ' p_cleared_date = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2414: cep_standard.debug(' p_trx_amount = '|| to_char(amount_cleared)||
2415: ' p_trx_type = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2416:
2417: PAY_CE_RECONCILIATION_PKG.reconcile_payment (
2418: p_payment_id => CE_AUTO_BANK_MATCH.trx_id,
2422: p_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
2423: p_last_update_login => NVL(FND_GLOBAL.user_id,-1),
2424: p_created_by => NVL(FND_GLOBAL.user_id,-1) );
2425:
2426: cep_standard.debug('reconcile_trx: ' || '<<< End PAY_CE_RECONCILIATION_PKG.reconcile_payment');
2427: END IF;
2428: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2429: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_reconcile_flag;
2430: ELSE
2462: CE_AUTO_BANK_MATCH.csl_trx_date := CE_AUTO_BANK_MATCH.trx_cleared_date;
2463: end if;
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2464: end if;
2465:
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2466: cep_standard.debug('X_CHECK_ID: '||to_char(CE_AUTO_BANK_MATCH.trx_id)||
2467: ' X_ACCOUNTING_DATE: '||CE_AUTO_BANK_REC.G_gl_date);
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2468: cep_standard.debug('X_CLEARED_DATE: '||CE_AUTO_BANK_MATCH.csl_trx_date||
2469: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2470: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2471: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2478:
2472: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2478:
2479: AP_RECONCILIATION_PKG.recon_payment_history(
2480: X_CHECKRUN_ID => to_number(NULL),
2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2476: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2478:
2479: AP_RECONCILIATION_PKG.recon_payment_history(
2480: X_CHECKRUN_ID => to_number(NULL),
2481: X_CHECK_ID => to_number(CE_AUTO_BANK_MATCH.trx_id),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<<
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;
2508: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2509: ELSE -- Receipt
2596: end if;
2597: end if;
2598: exception
2599: when no_data_found then
2600: cep_standard.debug('reconcile_trx: calls debit_memo_reversal NO DATA FOUND');
2601: raise;
2602: when others then
2603: cep_standard.debug('reconcile_trx: calls debit_memo_reversal EXCEPTION');
2604: raise;
2599: when no_data_found then
2600: cep_standard.debug('reconcile_trx: calls debit_memo_reversal NO DATA FOUND');
2601: raise;
2602: when others then
2603: cep_standard.debug('reconcile_trx: calls debit_memo_reversal EXCEPTION');
2604: raise;
2605: end;
2606: END IF;
2607:
2611: THEN
2612: FND_MESSAGE.set_name('CE','CE_MATCHED_AR_ENTRY');
2613: RAISE APP_EXCEPTION.application_exception;
2614: ELSE
2615: cep_standard.debug('reconcile_trx: ' || ' amount_cleared = '|| amount_cleared||
2616: ' charges_amount = '|| charges_amount|| ' trx_status = '|| trx_status);
2617:
2618: cleared_trx_type := CE_AUTO_BANK_MATCH.csl_match_type;
2619: --
2629: --
2630: -- bug 922650
2631: -- update actual_value_date in AR_CASH_RECEIPS table.
2632: --
2633: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2634: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2635: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2633: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.update_actual_value_date');
2634: ARP_CASHBOOK.update_actual_value_date(to_number(ar_cash_receipt_id),
2635: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2638: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2636: ELSE
2637: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2638: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2644: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2639: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2640: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2644: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2645: ' amount_cleared = '|| amount_cleared);
2646: cep_standard.debug('charges_amount = '|| charges_amount ||
2647: ' cleared_trx_id = '|| cleared_trx_id);
2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2644: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2645: ' amount_cleared = '|| amount_cleared);
2646: cep_standard.debug('charges_amount = '|| charges_amount ||
2647: ' cleared_trx_id = '|| cleared_trx_id);
2648:
2649: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2650:
2645: ' amount_cleared = '|| amount_cleared);
2646: cep_standard.debug('charges_amount = '|| charges_amount ||
2647: ' cleared_trx_id = '|| cleared_trx_id);
2648:
2649: cep_standard.debug('reconcile_trx: call ARP_CASHBOOK.clear ');
2650:
2651: ARP_CASHBOOK.clear(
2652: p_cr_id => to_number(ar_cash_receipt_id),
2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2667: IF cleared_trx_id IS NOT NULL THEN
2668: G_RECEIPT_PROCESSED_FLAG := TRUE;
2669: END IF;
2670: -- Bug 16298972 E
2671: cep_standard.debug('end call ARP_CASHBOOK.clear ');
2672: END IF;
2673: END IF;
2674: END IF;
2675: END IF;
2677: END IF;
2678:
2679: IF (passin_mode <> 'MANUAL_C' )
2680: THEN
2681: cep_standard.debug('reconcile_trx: ' ||
2682: 'cleared_trx_type='||cleared_trx_type||
2683: ',cleared_trx_id='||to_char(cleared_trx_id)||
2684: ',ar_cash_receipt_id='||to_char(ar_cash_receipt_id));
2685: cep_standard.debug('reconcile_trx: ' ||
2681: cep_standard.debug('reconcile_trx: ' ||
2682: 'cleared_trx_type='||cleared_trx_type||
2683: ',cleared_trx_id='||to_char(cleared_trx_id)||
2684: ',ar_cash_receipt_id='||to_char(ar_cash_receipt_id));
2685: cep_standard.debug('reconcile_trx: ' ||
2686: ',reference_status='||reference_status||
2687: ',auto_reconciled_flag='||auto_reconciled_flag||
2688: ',amount_cleared='|| to_char(amount_cleared));
2689:
2686: ',reference_status='||reference_status||
2687: ',auto_reconciled_flag='||auto_reconciled_flag||
2688: ',amount_cleared='|| to_char(amount_cleared));
2689:
2690: cep_standard.debug('reconcile_trx: calling CE_AUTO_BANK_CLEAR1.insert_reconciliation');
2691:
2692: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2693: Y_cleared_trx_type => cleared_trx_type,
2694: Y_cleared_trx_id => cleared_trx_id,
2700: END IF;
2701:
2702: /* Bug 16491164 Commented the following code
2703: -- Bug 16298972 Start
2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2701:
2702: /* Bug 16491164 Commented the following code
2703: -- Bug 16298972 Start
2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2703: -- Bug 16298972 Start
2704: cep_standard.debug('FND_GLOBAL.conc_request_id = ' || FND_GLOBAL.conc_request_id);
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2705: cep_standard.debug('passin_mode = ' || passin_mode);
2706: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN
2707: cep_standard.debug('Calling AR API ARP_CASHBOOK.refresh_risk_value for manual clearing.');
2708: ARP_CASHBOOK.refresh_risk_value;
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2712: */
2713: cep_standard.debug('<
2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2712: */
2713: cep_standard.debug('<
2715: -- 14840476 : Added exception block
2716: EXCEPTION
2717: WHEN OTHERS THEN
2714:
2715: -- 14840476 : Added exception block
2716: EXCEPTION
2717: WHEN OTHERS THEN
2718: cep_standard.debug('reconcile_trx: EXCEPTION ::'||sqlerrm);
2719: RAISE;
2720: END reconcile_trx;
2721:
2722: /* ---------------------------------------------------------------------
2758:
2759: BEGIN
2760:
2761: IF l_DEBUG in ('Y', 'C') THEN
2762: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2763:
2764: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2765: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2766: ', legal_entity_id = ' ||legal_entity_id);
2760:
2761: IF l_DEBUG in ('Y', 'C') THEN
2762: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2763:
2764: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2765: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2766: ', legal_entity_id = ' ||legal_entity_id);
2767: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2768: ', currency_code = '||currency_code );
2763:
2764: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2765: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2766: ', legal_entity_id = ' ||legal_entity_id);
2767: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2768: ', currency_code = '||currency_code );
2769: cep_standard.debug('X_CHECKRUN_ID: '||to_char(batch_id)||', X_CHECK_ID: '||to_char(trx_id) ||
2770: ', cash_receipt_id ' ||cash_receipt_id ||
2771: ', trx_date ' ||trx_date ||
2765: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2766: ', legal_entity_id = ' ||legal_entity_id);
2767: cep_standard.debug('stmt_line_id = ' ||stmt_line_id || ', status = ' || status||
2768: ', currency_code = '||currency_code );
2769: cep_standard.debug('X_CHECKRUN_ID: '||to_char(batch_id)||', X_CHECK_ID: '||to_char(trx_id) ||
2770: ', cash_receipt_id ' ||cash_receipt_id ||
2771: ', trx_date ' ||trx_date ||
2772: ', cash_receipt_history_id '|| cash_receipt_history_id );
2773:
2770: ', cash_receipt_id ' ||cash_receipt_id ||
2771: ', trx_date ' ||trx_date ||
2772: ', cash_receipt_history_id '|| cash_receipt_history_id );
2773:
2774: cep_standard.debug('X_ACCOUNTING_DATE: '||fnd_date.date_to_charDT(gl_date)||
2775: ', X_CLEARED_DATE: '||fnd_date.date_to_charDT(cleared_date)||
2776: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2777: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2778: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2773:
2774: cep_standard.debug('X_ACCOUNTING_DATE: '||fnd_date.date_to_charDT(gl_date)||
2775: ', X_CLEARED_DATE: '||fnd_date.date_to_charDT(cleared_date)||
2776: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2777: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2778: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2779: ', X_CURRENCY_CODE: '||currency_code);
2780: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2781: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2776: ', X_TRANSACTION_AMOUNT: '||to_char(transaction_amount));
2777: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(error_amount)||
2778: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2779: ', X_CURRENCY_CODE: '||currency_code);
2780: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2781: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2782: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(xrate)||
2783: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2784: END IF;
2778: ', X_CHARGE_AMOUNT: '||to_char(charge_amount)||
2779: ', X_CURRENCY_CODE: '||currency_code);
2780: cep_standard.debug('X_EXCHANGE_RATE_TYPE: '||xtype||
2781: ', X_EXCHANGE_RATE_DATE: '||fnd_date.date_to_charDT(xdate));
2782: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(xrate)||
2783: ', X_ACTUAL_VALUE_DATE: '||fnd_date.date_to_charDT(value_date));
2784: END IF;
2785: -- Bug 13803033 Start
2786: IF (passin_mode <> 'MANUAL_UC') THEN
2797: into current_org_id
2798: from dual;
2799:
2800: IF l_DEBUG in ('Y', 'C') THEN
2801: cep_standard.debug('current_org_id =' ||current_org_id );
2802: END IF;
2803:
2804: -- bug 3782741 set single org, since AR will not allow org_id to be passed
2805: IF (((current_org_id is null) or (org_id <> current_org_id )) AND
2804: -- bug 3782741 set single org, since AR will not allow org_id to be passed
2805: IF (((current_org_id is null) or (org_id <> current_org_id )) AND
2806: (clearing_trx_type in ('CASH','MISC', 'PAYMENT'))) THEN
2807: mo_global.set_policy_context('S',org_id);
2808: cep_standard.debug('set current_org_id to ' ||org_id );
2809: END IF;
2810: END IF;
2811:
2812: select mo_global.GET_CURRENT_ORG_ID
2813: into current_org_id
2814: from dual;
2815:
2816: IF l_DEBUG in ('Y', 'C') THEN
2817: cep_standard.debug('current_org_id =' ||current_org_id );
2818: END IF;
2819:
2820: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
2821: IF (clearing_trx_type = 'PAYMENT') THEN
2820: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
2821: IF (clearing_trx_type = 'PAYMENT') THEN
2822:
2823: IF l_DEBUG in ('Y', 'C') THEN
2824: cep_standard.debug('>>>AP_RECONCILIATION_PKG.recon_payment_history');
2825: END IF;
2826:
2827: /*Bug 3427050 added the following IF */
2828: IF (status NOT IN ('STOP INITIATED','VOIDED')) THEN
2852: X_REQUEST_ID => to_number(NULL),
2853: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2854: );
2855: IF l_DEBUG in ('Y', 'C') THEN
2856: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2857: END IF;
2858:
2859: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2860: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(200, trx_id, 'N');
2869: IF (status not in ('REVERSED', 'RISK_ELIMINATED')
2870: AND p_current_record_flag <> 'N'
2871: AND arp_cashbook.receipt_debit_memo_reversed(cash_receipt_id) = 'N') THEN
2872: IF l_DEBUG in ('Y', 'C') THEN
2873: cep_standard.debug('call ARP_CASHBOOK.unclear');
2874: END IF;
2875:
2876: ARP_CASHBOOK.unclear( p_cr_id => cash_receipt_id,
2877: p_trx_date => trx_date,
2880: p_module_name => 'CEXCABMR',
2881: p_module_version => '1.0',
2882: p_crh_id => cash_receipt_history_id);
2883: IF l_DEBUG in ('Y', 'C') THEN
2884: cep_standard.debug('end call ARP_CASHBOOK.unclear');
2885: END IF;
2886:
2887: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2888: update ce_available_transactions_tmp
2901: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(999, trx_id, 'N');
2902:
2903: ELSIF (clearing_trx_type = 'XTR_LINE' ) THEN
2904: IF l_DEBUG in ('Y', 'C') THEN
2905: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line start');
2906: END IF;
2907: XTR_WRAPPER_API_P.reconciliation(
2908: P_SETTLEMENT_SUMMARY_ID => trx_id,
2909: P_TASK => 'UNR',
2915: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(185, trx_id, 'N');
2916:
2917:
2918: IF l_DEBUG in ('Y', 'C') THEN
2919: cep_standard.debug('unclear_process: ' || 'X_RESULT = ' ||X_RESULT);
2920: END IF;
2921: if (X_RESULT <> 'XTR2_SUCCESS') then
2922: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2923: RAISE APP_EXCEPTION.application_exception;
2922: FND_MESSAGE.set_name( 'CE','CE_XTR_UPDATE_FAILED');
2923: RAISE APP_EXCEPTION.application_exception;
2924: end if;
2925: IF l_DEBUG in ('Y', 'C') THEN
2926: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line END');
2927: END IF;
2928: ELSIF (clearing_trx_type = 'CASHFLOW' ) THEN
2929: IF l_DEBUG in ('Y', 'C') THEN
2930: cep_standard.debug('clearing_trx_type = CASHFLOW start');
2926: cep_standard.debug('unclear_process: ' || 'clearing_trx_type = xtr_line END');
2927: END IF;
2928: ELSIF (clearing_trx_type = 'CASHFLOW' ) THEN
2929: IF l_DEBUG in ('Y', 'C') THEN
2930: cep_standard.debug('clearing_trx_type = CASHFLOW start');
2931: END IF;
2932: -- passin_mode MANUAL, MANUAL_UC
2933:
2934:
2969: X_PASSIN_MODE => passin_mode
2970: ) ;
2971: */
2972: IF l_DEBUG in ('Y', 'C') THEN
2973: cep_standard.debug('clearing_trx_type = CASHFLOW END');
2974: END IF;
2975:
2976: ELSIF (clearing_trx_type = 'STATEMENT') THEN
2977: IF (passin_mode = 'MANUAL') THEN
2996: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2997:
2998: ELSIF (clearing_trx_type IN ('PAY','PAY_EFT')) THEN
2999: IF l_DEBUG in ('Y', 'C') THEN
3000: cep_standard.debug('call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
3001: END IF;
3002:
3003: PAY_CE_RECONCILIATION_PKG.reverse_reconcile(
3004: p_payment_id => trx_id);
3011: END IF;
3012:
3013:
3014: IF l_DEBUG in ('Y', 'C') THEN
3015: cep_standard.debug('end call PAY_CE_RECONCILIATION_PKG.reverse_reconcile');
3016: END IF;
3017: END IF;
3018: IF (passin_mode <> 'MANUAL_UC') THEN
3019: CE_AUTO_BANK_MATCH.csl_statement_line_id := stmt_line_id;
3032: Y_auto_reconciled_flag => 'N',
3033: Y_status_flag => 'U');
3034:
3035: IF l_DEBUG in ('Y', 'C') THEN
3036: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3037: END IF;
3038:
3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3040:
3038:
3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3040:
3041: IF l_DEBUG in ('Y', 'C') THEN
3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3043: END IF;
3044: END IF;
3045: IF (X_header_or_line = 'HEADERS') THEN
3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3045: IF (X_header_or_line = 'HEADERS') THEN
3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3047: END IF;
3048: IF l_DEBUG in ('Y', 'C') THEN
3049: cep_standard.debug('<
3051:
3052: EXCEPTION
3053: when others then
3051:
3052: EXCEPTION
3053: when others then
3054: IF l_DEBUG in ('Y', 'C') THEN
3055: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.unclear_process');
3056: END IF;
3057: RAISE;
3058: END unclear_process;
3059: