eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_CLEAR1 dependencies on CE_AUTO_BANK_CLEAR

Line 1: PACKAGE BODY CE_AUTO_BANK_CLEAR1 AS

1: PACKAGE BODY CE_AUTO_BANK_CLEAR1 AS
2: /* $Header: ceabrc1b.pls 120.49.12020000.7 2013/03/21 05:23:01 ckansara ship $ */
3: -- l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
4: l_DEBUG varchar2(1) := 'Y';
5:

Line 146: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.validate_effective_date');

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

Line 155: cep_standard.debug('<

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('< 156: END IF;
157: END validate_effective_date;
158:
159: /* ---------------------------------------------------------------------

Line 185: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.check_matching_status');

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,

Line 208: cep_standard.debug('<

204: ELSE
205: return(TRUE);
206: END IF;
207: IF l_DEBUG in ('Y', 'C') THEN
208: cep_standard.debug('< 209: END IF;
210: EXCEPTION
211: WHEN NO_DATA_FOUND THEN
212: IF l_DEBUG in ('Y', 'C') THEN

Line 218: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.check_matching_status');

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:

Line 234: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.update_line_unreconciled');

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

Line 245: CE_AUTO_BANK_CLEAR.update_line_status(X_statement_line_id,'UNRECONCILED');

241: AND current_record_flag = 'Y'
242: AND status_flag = 'M';
243:
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('< 249: END IF;

Line 248: cep_standard.debug('<

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('< 249: END IF;
250: EXCEPTION
251: WHEN OTHERS THEN
252: IF l_DEBUG in ('Y', 'C') THEN

Line 253: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.update_line_unreconciled');

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:

Line 267: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.create_statement_line');

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,

Line 336: cep_standard.debug('<

332: X_global_attribute19 => NULL,
333: X_global_attribute20 => NULL
334: );
335: IF l_DEBUG in ('Y', 'C') THEN
336: cep_standard.debug('< 337: END IF;
338: END create_statement_line;
339:
340: /* ---------------------------------------------------------------------

Line 360: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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);

Line 367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;

363: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_REC.G_legal_entity_id);
364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN

Line 368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),

364: --Y_org_id := nvl(CE_AUTO_BANK_REC.G_org_id,CE_AUTO_BANK_MATCH.bau_org_id);
365: --Y_legal_entity_id := nvl(CE_AUTO_BANK_REC.G_legal_entity_id,CE_AUTO_BANK_MATCH.bau_legal_entity_id);
366:
367: Y_org_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_org_id,CE_AUTO_BANK_MATCH.trx_org_id),CE_AUTO_BANK_REC.G_org_id) ;
368: Y_legal_entity_id := nvl(nvl(CE_AUTO_BANK_CLEAR.G_legal_entity_id,CE_AUTO_BANK_MATCH.trx_legal_entity_id),
369: CE_AUTO_BANK_REC.G_legal_entity_id);
370:
371: IF l_DEBUG in ('Y', 'C') THEN
372: cep_standard.debug('Y_org_id = ' ||Y_org_id || ', Y_legal_entity_id = ' ||Y_legal_entity_id||

Line 473: cep_standard.debug('<

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('< 474: END IF;
475: EXCEPTION
476: WHEN OTHERS THEN
477: IF l_DEBUG in ('Y', 'C') THEN

Line 478: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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:

Line 553: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_rbatch');

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,

Line 556: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

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,
558: X_float_handling_flag);
559: IF (NVL(X_amount,0) <> 0 AND (X_receipt_method_id IS NULL OR X_activity_type_id IS NULL)) THEN
560: FND_MESSAGE.set_name('CE','CE_BATCHES_MISC_MISSING');

Line 591: CE_AUTO_BANK_CLEAR1.create_statement_line;

587: CE_AUTO_BANK_MATCH.csl_charges_amount := NULL;
588: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
589: CE_AUTO_BANK_MATCH.trx_status := NULL;
590: IF (passin_mode = 'MANUAL_H') THEN
591: CE_AUTO_BANK_CLEAR1.create_statement_line;
592: IF(X_statement_header_id IS NULL)THEN
593: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
594: END IF;
595: END IF;

Line 598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

594: END IF;
595: END IF;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

Line 599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

595: END IF;
596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

Line 600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;

596: END IF;
597: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

598: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
605: END IF;
606: --

Line 603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

599: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
605: END IF;
606: --
607: -- The batch cannot be cleared and reconciled as one transaction so each

Line 604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

600: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
601: ELSE
602: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
603: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
604: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
605: END IF;
606: --
607: -- The batch cannot be cleared and reconciled as one transaction so each
608: -- receipt within the batch must be processed separately.

Line 654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

650: p_cr_id => receipt_id,
651: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
657: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
658: p_amount_cleared => amount_to_clear,

Line 655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

651: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
657: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
658: p_amount_cleared => amount_to_clear,
659: p_amount_factored => 0,

Line 656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),

652: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
653: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
654: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
655: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
656: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
657: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
658: p_amount_cleared => amount_to_clear,
659: p_amount_factored => 0,
660: p_module_name => module,

Line 676: cep_standard.debug('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 );

Line 677: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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 );

Line 679: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );

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:

Line 692: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN

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
693:
694: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
695:
696: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,

Line 694: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));

690:
691: IF ((trx_currency_type = 'FOREIGN') and
692: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
693:
694: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
695:
696: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
697: precision,
698: ext_precision,

Line 710: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');

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(

Line 719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,

715: p_cr_id => receipt_id,
716: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
722: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
723: p_amount_cleared => amount_to_clear,

Line 720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,

716: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
722: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
723: p_amount_cleared => amount_to_clear,
724: p_amount_factored => 0,

Line 721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

717: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
718: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
719: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
720: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
721: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
722: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
723: p_amount_cleared => amount_to_clear,
724: p_amount_factored => 0,
725: p_module_name => module,

Line 741: cep_standard.debug('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 );

Line 742: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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 );

Line 744: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );

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:

Line 756: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

752: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
753: END IF;
754: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
755: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
756: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
757: Y_cleared_trx_type =>receipt_type,
758: Y_cleared_trx_id =>receipt_history_id,
759: Y_ar_cash_receipt_id =>receipt_id,
760: Y_reference_status =>receipt_status,

Line 810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

806: p_cr_id => receipt_id,
807: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
813: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
814: p_amount_cleared => amount_to_clear,

Line 811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

807: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
813: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
814: p_amount_cleared => amount_to_clear,
815: p_amount_factored => 0,

Line 812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),

808: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
809: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
810: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
811: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
812: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
813: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
814: p_amount_cleared => amount_to_clear,
815: p_amount_factored => 0,
816: p_module_name => module,

Line 831: cep_standard.debug('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 );

Line 832: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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 );

Line 834: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );

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:

Line 847: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN

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
848:
849: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
850:
851: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,

Line 849: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));

845:
846: IF ((trx_currency_type = 'FOREIGN') and
847: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
848:
849: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
850:
851: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
852: precision,
853: ext_precision,

Line 865: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');

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(

Line 874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,

870: p_cr_id => receipt_id,
871: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
877: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
878: p_amount_cleared => amount_to_clear,

Line 875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,

871: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
877: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
878: p_amount_cleared => amount_to_clear,
879: p_amount_factored => 0,

Line 876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,

872: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
873: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
874: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
875: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
876: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
877: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
878: p_amount_cleared => amount_to_clear,
879: p_amount_factored => 0,
880: p_module_name => module,

Line 896: cep_standard.debug('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 );

Line 897: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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 );

Line 899: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );

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:

Line 913: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

909: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
910: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
911: -- 5637589
912: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
913: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
914: Y_cleared_trx_type =>receipt_type,
915: Y_cleared_trx_id =>receipt_history_id,
916: Y_ar_cash_receipt_id =>receipt_id,
917: Y_reference_status =>receipt_status,

Line 950: CE_AUTO_BANK_CLEAR.misc_receipt(

946: l_vat_tax_id := X_tax_id;
947: l_tax_rate := X_tax_rate;
948: end if;
949:
950: CE_AUTO_BANK_CLEAR.misc_receipt(
951: X_PASSIN_MODE => passin_mode,
952: X_TRX_NUMBER => X_trx_number,
953: X_DOC_SEQUENCE_VALUE => NULL,
954: X_DOC_SEQUENCE_ID => NULL,

Line 988: cep_standard.debug('<

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('< 989: END IF;
990: EXCEPTION
991: WHEN OTHERS THEN
992: -- bug 2875549

Line 993: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_rbatch');

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;

Line 1060: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');

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;

Line 1082: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

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,
1083: X_effective_date,
1084: X_float_handling_flag);
1085: --
1086: -- The batch cannot be cleared and reconciled as one transaction so each

Line 1150: cep_standard.debug('reconcile_pay_eft: call 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,

Line 1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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,
1155: Y_cleared_trx_id => cleared_trx_id,
1156: Y_ar_cash_receipt_id => null,
1157: Y_reference_status => null,

Line 1169: cep_standard.debug('reconcile_pay_eft: ' || '<<< End CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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;

Line 1178: cep_standard.debug('<

1174:
1175: END IF;
1176:
1177: IF l_DEBUG in ('Y', 'C') THEN
1178: cep_standard.debug('< 1179: END IF;
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');

Line 1182: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');

1178: cep_standard.debug('< 1179: END IF;
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;

Line 1239: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.misc_receipt');

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;

Line 1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

1259: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1260: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1261: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

Line 1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

1262: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

Line 1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

1263: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

Line 1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;

1264: END IF;
1265: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1273: END IF;
1274: --

Line 1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1267: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1273: END IF;
1274: --
1275: -- Call the AOL sequence numbering routine to get Seq. number

Line 1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1268: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1269: ELSE
1270: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1271: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1272: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1273: END IF;
1274: --
1275: -- Call the AOL sequence numbering routine to get Seq. number
1276: --

Line 1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1439: ARP_CASHBOOK.clear(X_cr_id,
1440: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1442: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1446: CE_AUTO_BANK_MATCH.aba_bank_currency,
1447: X_bank_account_amount,

Line 1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1440: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1442: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1446: CE_AUTO_BANK_MATCH.aba_bank_currency,
1447: X_bank_account_amount,
1448: 0,

Line 1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,

1441: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1442: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1443: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1444: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1445: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1446: CE_AUTO_BANK_MATCH.aba_bank_currency,
1447: X_bank_account_amount,
1448: 0,
1449: X_module_name,

Line 1459: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1455: END IF;
1456: -- Bug 16298972 End
1457: END IF;
1458: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'MISC';
1459: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1460: Y_cleared_trx_type => 'MISC',
1461: Y_cleared_trx_id => cash_receipt_history_id,
1462: Y_ar_cash_receipt_id => X_cr_id,
1463: Y_reference_status => NULL,

Line 1469: cep_standard.debug('<

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('< 1470: END IF;
1471: END misc_receipt;
1472:
1473: /* ---------------------------------------------------------------------

Line 1516: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');

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,

Line 1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

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,
1522: X_float_handling_flag);
1523: -- Bug 13803033 Start
1524: IF (passin_mode <> 'MANUAL_C') THEN

Line 1553: CE_AUTO_BANK_CLEAR1.create_statement_line;

1549: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1550: CE_AUTO_BANK_MATCH.trx_status := NULL;
1551: auto_reconciled_flag := 'N';
1552: IF( passin_mode = 'MANUAL_H') THEN
1553: CE_AUTO_BANK_CLEAR1.create_statement_line;
1554: IF(X_statement_header_id IS NULL)THEN
1555: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
1556: END IF;
1557: END IF;

Line 1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

1556: END IF;
1557: END IF;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

Line 1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

1557: END IF;
1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

Line 1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;

1558: END IF;
1559: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1560: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1567: END IF;
1568: ------------------------------------------------------------------------

Line 1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1561: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1567: END IF;
1568: ------------------------------------------------------------------------
1569: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722

Line 1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1562: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1563: ELSE
1564: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1565: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1566: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1567: END IF;
1568: ------------------------------------------------------------------------
1569: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1570: -- bug 5350073 ce_available_transactions_tmp is not populated when

Line 1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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,

Line 1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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,
1597: Y_ar_cash_receipt_id => NULL,
1598: Y_reference_status => check_status,

Line 1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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 (

Line 1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1628: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1629: Y_cleared_trx_id => check_id,
1630: Y_ar_cash_receipt_id => NULL,
1631: Y_reference_status => check_status,

Line 1654: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||

1650: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1651: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1652: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1653: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1654: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1655: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1656: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1657: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1658: END IF;

Line 1655: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||

1651: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1652: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1653: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1654: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1655: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1656: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1657: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1658: END IF;
1659: */

Line 1656: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||

1652: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1653: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1654: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1655: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1656: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1657: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1658: END IF;
1659: */
1660: ------------------------------------------------------------------------------

Line 1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||

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')||

Line 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') ||

1665: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1667:
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1671:
1672: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1673: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);

Line 1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);

1666: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1667:
1668: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1669: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1670: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1671:
1672: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1673: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);
1674:

Line 1691: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1687: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1688: X_ERROR_AMOUNT => NVL(errors_amount,0),
1689: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1690: X_CURRENCY_CODE => X_bank_currency_code,
1691: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1692: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1693: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1694: X_MATCHED_FLAG => 'Y',
1695: X_ACTUAL_VALUE_DATE =>

Line 1692: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1688: X_ERROR_AMOUNT => NVL(errors_amount,0),
1689: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1690: X_CURRENCY_CODE => X_bank_currency_code,
1691: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1692: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1693: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1694: X_MATCHED_FLAG => 'Y',
1695: X_ACTUAL_VALUE_DATE =>
1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1693: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1689: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1690: X_CURRENCY_CODE => X_bank_currency_code,
1691: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1692: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1693: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1694: X_MATCHED_FLAG => 'Y',
1695: X_ACTUAL_VALUE_DATE =>
1696: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: X_LAST_UPDATE_DATE => sysdate,

Line 1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '

1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
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: ' || '<< 1710: END IF;

Line 1723: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional

1719: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1720: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1721: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1722: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1723: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1724: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1725: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1726: P_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
1727: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1724: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional

1720: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1721: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1722: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1723: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1724: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1725: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1726: P_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
1727: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1728: P_PASSIN_MODE => passin_mode ,

Line 1725: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional

1721: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1722: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1723: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1724: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1725: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1726: P_MATCHED_FLAG => clearing_flag, -- Bug 13803033 Changed hardcoded 'Y' to clearing_flag
1727: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1728: P_PASSIN_MODE => passin_mode ,
1729: P_STATEMENT_LINE_ID => statement_line_id ,

Line 1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',

1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
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:

Line 1756: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))

1752: update ce_statement_reconcils_all r
1753: set amount =
1754: (select DECODE(c.currency_code,
1755: X_bank_currency_code, c.cleared_amount,
1756: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1757: from ap_checks_all c
1758: where c.check_id = r.reference_id)
1759: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1760: and reference_type = 'PAYMENT'

Line 1766: cep_standard.debug('<

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('< 1767: END IF;
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');

Line 1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');

1766: cep_standard.debug('< 1767: END IF;
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;

Line 1826: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );

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,

Line 1830: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

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,
1831: X_effective_date,
1832: X_float_handling_flag);
1833: END IF;
1834: IF (passin_mode IN ('MANUAL_L','MANUAL_C')) THEN

Line 1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

1870: END IF;
1871:
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

Line 1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

1871:
1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

Line 1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;

1872:
1873: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1874: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1881: END IF;
1882: if (passin_mode = 'AUTO') then

Line 1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1875: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1881: END IF;
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND

Line 1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1876: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1877: ELSE
1878: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1879: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1880: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1881: END IF;
1882: if (passin_mode = 'AUTO') then
1883: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1884: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then

Line 1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1920: p_cr_id => to_number(ar_cash_receipt_id),
1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1928: p_amount_cleared => amount_cleared * clearing_sign,

Line 1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1921: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1928: p_amount_cleared => amount_cleared * clearing_sign,
1929: p_amount_factored => charges_amount,

Line 1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1922: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1923: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1924: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1925: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1926: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1927: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1928: p_amount_cleared => amount_cleared * clearing_sign,
1929: p_amount_factored => charges_amount,
1930: p_module_name => 'CE_AUTO_BANK_REC',

Line 1970: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||

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);
1974: END IF;

Line 1971: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);

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);
1974: END IF;
1975:

Line 1972: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||

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

Line 1990: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1986: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1987: X_ERROR_AMOUNT => NVL(errors_amount,0),
1988: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1989: X_CURRENCY_CODE => X_bank_currency,
1990: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1991: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1992: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1993: X_MATCHED_FLAG => clearing_flag,
1994: X_ACTUAL_VALUE_DATE =>

Line 1991: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

1987: X_ERROR_AMOUNT => NVL(errors_amount,0),
1988: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1989: X_CURRENCY_CODE => X_bank_currency,
1990: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1991: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1992: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1993: X_MATCHED_FLAG => clearing_flag,
1994: X_ACTUAL_VALUE_DATE =>
1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1992: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1988: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1989: X_CURRENCY_CODE => X_bank_currency,
1990: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1991: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1992: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1993: X_MATCHED_FLAG => clearing_flag,
1994: X_ACTUAL_VALUE_DATE =>
1995: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1996: X_LAST_UPDATE_DATE => sysdate,

Line 2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '

2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
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: ' || '<< 2009: END IF;

Line 2076: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2072: and reference_type = tx_type
2073: and nvl(current_record_flag, 'N') = 'Y'
2074: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2075:
2076: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2077: Y_statement_line_id => x_trx_id,
2078: Y_cleared_trx_type => 'STATEMENT',
2079: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2080: Y_ar_cash_receipt_id => to_number(NULL),

Line 2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2082: Y_auto_reconciled_flag => auto_reconciled_flag,
2083: Y_status_flag => 'M',
2084: Y_amount => x_trx_amount );
2085:
2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2087: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2088: Y_cleared_trx_type => 'STATEMENT',
2089: Y_cleared_trx_id => x_trx_id,
2090: Y_ar_cash_receipt_id => to_number(NULL),

Line 2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2119: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2120: END IF;
2121:
2122: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2124: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2125: Y_cleared_trx_type => cleared_trx_type,
2126: Y_cleared_trx_id => cleared_trx_id,
2127: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2162: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2163: end if;
2164: end if;
2165:
2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2167: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2168: Y_cleared_trx_type => 'STATEMENT',
2169: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2170: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2176: CE_AUTO_BANK_CLEAR.update_line_status(

2172: Y_auto_reconciled_flag => auto_reconciled_flag,
2173: Y_status_flag => 'M',
2174: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2175:
2176: CE_AUTO_BANK_CLEAR.update_line_status(
2177: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2178:
2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2180: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2175:
2176: CE_AUTO_BANK_CLEAR.update_line_status(
2177: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2178:
2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2180: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2181: Y_cleared_trx_type => 'STATEMENT',
2182: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2183: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2189: CE_AUTO_BANK_CLEAR.update_line_status(

2185: Y_auto_reconciled_flag => auto_reconciled_flag,
2186: Y_status_flag => 'M',
2187: Y_amount => x_trx_amount2);
2188:
2189: CE_AUTO_BANK_CLEAR.update_line_status(
2190: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2191: end if;
2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('<

Line 2193: cep_standard.debug('<

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('< 2194: END IF;
2195: END reconcile_stmt;
2196:
2197: /* ---------------------------------------------------------------------

Line 2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');

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.

Line 2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

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

Line 2255: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

2251: -- Bug 16298972 End
2252:
2253: IF (X_org_id is not null or X_legal_entity_id is not null)
2254: THEN
2255: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2256: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2257: END IF;
2258:
2259: IF (passin_mode <> 'MANUAL_C')

Line 2256: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;

2252:
2253: IF (X_org_id is not null or X_legal_entity_id is not null)
2254: THEN
2255: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2256: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2257: END IF;
2258:
2259: IF (passin_mode <> 'MANUAL_C')
2260: THEN

Line 2262: CE_AUTO_BANK_CLEAR1.validate_effective_date(

2258:
2259: IF (passin_mode <> 'MANUAL_C')
2260: THEN
2261: clearing_flag := 'Y';
2262: CE_AUTO_BANK_CLEAR1.validate_effective_date(
2263: passin_mode,
2264: X_effective_date,
2265: X_float_handling_flag);
2266: END IF;

Line 2301: CE_AUTO_BANK_CLEAR1.create_statement_line;

2297: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2298:
2299: IF (passin_mode = 'MANUAL_H' )
2300: THEN
2301: CE_AUTO_BANK_CLEAR1.create_statement_line;
2302: IF(X_statement_header_id IS NULL)
2303: THEN
2304: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2305: END IF;

Line 2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;

2312: END IF;
2313:
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

Line 2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

2313:
2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

Line 2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;

2314: IF (trx_currency_type IN ('FOREIGN','BANK'))
2315: THEN
2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

2316: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2323: END IF;
2324:

Line 2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

2317: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2323: END IF;
2324:
2325: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE')

Line 2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

2318: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2319: ELSE
2320: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2321: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2322: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2323: END IF;
2324:
2325: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE')
2326: THEN

Line 2387: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2383: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2384: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2385: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2386: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2387: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2388: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2389: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2390: X_PASSIN_MODE => passin_mode,
2391: x_statement_line_id => x_statement_line_id,

Line 2388: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2384: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2385: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2386: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2387: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2388: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2389: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2390: X_PASSIN_MODE => passin_mode,
2391: x_statement_line_id => x_statement_line_id,
2392: x_statement_line_type => x_statement_line_type) ;

Line 2389: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2385: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2386: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2387: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2388: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2389: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2390: X_PASSIN_MODE => passin_mode,
2391: x_statement_line_id => x_statement_line_id,
2392: x_statement_line_type => x_statement_line_type) ;
2393:

Line 2473: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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);
2477: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');

Line 2474: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_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:

Line 2475: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));

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:
2479: AP_RECONCILIATION_PKG.recon_payment_history(

Line 2489: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2485: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2486: X_ERROR_AMOUNT => NVL(errors_amount,0),
2487: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2488: X_CURRENCY_CODE => X_bank_currency,
2489: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2490: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,

Line 2490: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,

2486: X_ERROR_AMOUNT => NVL(errors_amount,0),
2487: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2488: X_CURRENCY_CODE => X_bank_currency,
2489: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2490: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,

Line 2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2487: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2488: X_CURRENCY_CODE => X_bank_currency,
2489: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2490: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2491: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2492: X_MATCHED_FLAG => clearing_flag,
2493: X_ACTUAL_VALUE_DATE => CE_AUTO_BANK_MATCH.csl_effective_date,
2494: X_LAST_UPDATE_DATE => sysdate,
2495: X_LAST_UPDATED_BY => NVL(FND_GLOBAL.user_id,-1),

Line 2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');

2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
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: ' || '<< 2506: END IF;
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;

Line 2610: NOT CE_AUTO_BANK_CLEAR1.check_matching_status(ar_cash_receipt_id,reference_status))

2606: END IF;
2607:
2608: ELSE -- not reversed nor dm_reverse
2609: IF (reference_status <> 'REVERSED' AND
2610: NOT CE_AUTO_BANK_CLEAR1.check_matching_status(ar_cash_receipt_id,reference_status))
2611: THEN
2612: FND_MESSAGE.set_name('CE','CE_MATCHED_AR_ENTRY');
2613: RAISE APP_EXCEPTION.application_exception;
2614: ELSE

Line 2641: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||

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 ||
2645: ' amount_cleared = '|| amount_cleared);

Line 2642: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);

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 ||
2645: ' amount_cleared = '|| amount_cleared);
2646: cep_standard.debug('charges_amount = '|| charges_amount ||

Line 2643: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||

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);

Line 2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2652: p_cr_id => to_number(ar_cash_receipt_id),
2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2660: p_amount_cleared => amount_cleared,

Line 2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2653: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2660: p_amount_cleared => amount_cleared,
2661: p_amount_factored => charges_amount,

Line 2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2654: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2655: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2656: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2657: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2658: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2659: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2660: p_amount_cleared => amount_cleared,
2661: p_amount_factored => charges_amount,
2662: p_module_name => 'CE_AUTO_BANK_REC',

Line 2690: cep_standard.debug('reconcile_trx: calling CE_AUTO_BANK_CLEAR1.insert_reconciliation');

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,

Line 2692: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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,
2695: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2696: Y_reference_status => reference_status,

Line 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('< 2714:
2715: -- 14840476 : Added exception block
2716: EXCEPTION
2717: WHEN OTHERS THEN

Line 2762: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');

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);

Line 2792: CE_AUTO_BANK_CLEAR.G_org_id := org_id;

2788: END IF;
2789: -- Bug 13803033 End
2790: --CE_AUTO_BANK_REC.G_org_id := org_id;
2791: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2792: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2793: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2794:
2795: IF (org_id is not null) THEN
2796: select mo_global.GET_CURRENT_ORG_ID

Line 2793: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;

2789: -- Bug 13803033 End
2790: --CE_AUTO_BANK_REC.G_org_id := org_id;
2791: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2792: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2793: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2794:
2795: IF (org_id is not null) THEN
2796: select mo_global.GET_CURRENT_ORG_ID
2797: into current_org_id

Line 2853: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '

2849: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2850: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
2851: X_PROGRAM_ID => to_number(NULL),
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;

Line 2944: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2940: X_CLEARED_DATE => trx_date,
2941: X_CLEARED_AMOUNT => transaction_amount,
2942: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2943: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2944: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2945: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2946: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2947: X_PASSIN_MODE => passin_mode,
2948: x_statement_line_id => stmt_line_id,

Line 2945: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2941: X_CLEARED_AMOUNT => transaction_amount,
2942: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2943: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2944: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2945: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2946: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2947: X_PASSIN_MODE => passin_mode,
2948: x_statement_line_id => stmt_line_id,
2949: x_statement_line_type => null

Line 2946: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2942: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2943: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2944: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2945: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2946: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2947: X_PASSIN_MODE => passin_mode,
2948: x_statement_line_id => stmt_line_id,
2949: x_statement_line_type => null
2950: ) ;

Line 2966: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2962: X_CLEARED_DATE => trx_date,
2963: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2964: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2965: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2966: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2967: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2968: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2969: X_PASSIN_MODE => passin_mode
2970: ) ;

Line 2967: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

2963: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2964: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2965: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2966: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2967: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2968: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2969: X_PASSIN_MODE => passin_mode
2970: ) ;
2971: */

Line 2968: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2964: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2965: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2966: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2967: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2968: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2969: X_PASSIN_MODE => passin_mode
2970: ) ;
2971: */
2972: IF l_DEBUG in ('Y', 'C') THEN

Line 2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2980: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2981: -- in case a journal is processed before the stmt transaction
2982: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2983:
2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2985: Y_statement_line_id => trx_id,
2986: Y_cleared_trx_type => clearing_trx_type,
2987: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2988: Y_ar_cash_receipt_id => cash_receipt_id,

Line 2993: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);

2989: Y_reference_status => status,
2990: Y_auto_reconciled_flag => 'N',
2991: Y_status_flag => 'U');
2992:
2993: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);
2994:
2995: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2996: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2997:

Line 3026: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

3022: ELSE
3023: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
3024: END IF;
3025:
3026: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
3027: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
3028: Y_cleared_trx_type => clearing_trx_type,
3029: Y_cleared_trx_id => trx_id,
3030: Y_ar_cash_receipt_id => cash_receipt_id,

Line 3036: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');

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:

Line 3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

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:
3041: IF l_DEBUG in ('Y', 'C') THEN
3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3043: END IF;

Line 3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');

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);

Line 3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

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);
3047: END IF;
3048: IF l_DEBUG in ('Y', 'C') THEN
3049: cep_standard.debug('< 3050: END IF;

Line 3049: cep_standard.debug('<

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('< 3050: END IF;
3051:
3052: EXCEPTION
3053: when others then

Line 3055: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.unclear_process');

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:

Line 3280: END CE_AUTO_BANK_CLEAR1;

3276: when others then
3277: null;
3278: END populate_avail_trx;
3279:
3280: END CE_AUTO_BANK_CLEAR1;