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.44.12010000.3 2008/11/02 18:27:02 csutaria 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 670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));

666: cep_standard.debug('receipt_id = '|| receipt_id);
667: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
668: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
669: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:
673: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );

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

667: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
668: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
669: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:
673: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
675: cep_standard.debug('module = '|| module );

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

669: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
670: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
671: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
672:
673: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
674: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
675: cep_standard.debug('module = '|| module );
676: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
677:

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

682: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
683: END IF;
684:
685: IF ((trx_currency_type = 'FOREIGN') and
686: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
687:
688: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
689:
690: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,

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

684:
685: IF ((trx_currency_type = 'FOREIGN') and
686: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
687:
688: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
689:
690: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
691: precision,
692: ext_precision,

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

700:
701: END IF;
702: IF l_DEBUG in ('Y', 'C') THEN
703:
704: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
705: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
706: END IF;
707:
708: ARP_CASHBOOK.clear(

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

709: p_cr_id => receipt_id,
710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
716: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
717: p_amount_cleared => amount_to_clear,

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

710: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
716: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
717: p_amount_cleared => amount_to_clear,
718: p_amount_factored => 0,

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

711: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
712: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
713: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
714: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
715: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
716: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
717: p_amount_cleared => amount_to_clear,
718: p_amount_factored => 0,
719: p_module_name => module,

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

726: cep_standard.debug('receipt_id = '|| receipt_id);
727: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
728: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
729: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:
733: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );

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

727: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
728: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
729: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:
733: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
735: cep_standard.debug('module = '|| module );

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

729: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
730: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
731: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
732:
733: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
734: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
735: cep_standard.debug('module = '|| module );
736: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
737:

Line 745: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

741: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
742: END IF;
743: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
744: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
745: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
746: Y_cleared_trx_type =>receipt_type,
747: Y_cleared_trx_id =>receipt_history_id,
748: Y_ar_cash_receipt_id =>receipt_id,
749: Y_reference_status =>receipt_status,

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

795: p_cr_id => receipt_id,
796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
802: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
803: p_amount_cleared => amount_to_clear,

Line 800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

796: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
802: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
803: p_amount_cleared => amount_to_clear,
804: p_amount_factored => 0,

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

797: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
798: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
799: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
800: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
801: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate),
802: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
803: p_amount_cleared => amount_to_clear,
804: p_amount_factored => 0,
805: p_module_name => module,

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

811: cep_standard.debug('receipt_id = '|| receipt_id);
812: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
813: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
814: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:
818: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );

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

812: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD') );
813: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
814: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:
818: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
820: cep_standard.debug('module = '|| module );

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

814: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
815: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
816: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
817:
818: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
819: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
820: cep_standard.debug('module = '|| module );
821: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
822:

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

827: cep_standard.debug(' trx_exchange_rate_type = '|| trx_exchange_rate_type );
828: END IF;
829:
830: IF ((trx_currency_type = 'FOREIGN') and
831: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
832:
833: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
834:
835: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,

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

829:
830: IF ((trx_currency_type = 'FOREIGN') and
831: (CE_AUTO_BANK_CLEAR.G_exchange_rate is not null)) THEN
832:
833: adjusted_xrate_amount := (trx_amount * to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
834:
835: FND_CURRENCY.get_info(CE_AUTO_BANK_MATCH.csl_currency_code,
836: precision,
837: ext_precision,

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

845:
846: END IF;
847: IF l_DEBUG in ('Y', 'C') THEN
848:
849: cep_standard.debug('set adjusted xrate_amount to amount_to_clear, trx_amount * CE_AUTO_BANK_CLEAR.G_exchange_rate ');
850: cep_standard.debug('amount_to_clear = '|| amount_to_clear);
851: END IF;
852:
853: ARP_CASHBOOK.clear(

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

854: p_cr_id => receipt_id,
855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
861: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
862: p_amount_cleared => amount_to_clear,

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

855: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
861: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
862: p_amount_cleared => amount_to_clear,
863: p_amount_factored => 0,

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

856: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
857: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
858: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), --trx_exchange_rate_date,
859: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, --trx_exchange_rate_type,
860: p_exchange_rate => to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate), --amount_to_clear/trx_amount,
861: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
862: p_amount_cleared => amount_to_clear,
863: p_amount_factored => 0,
864: p_module_name => module,

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

871: cep_standard.debug('receipt_id = '|| receipt_id);
872: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
873: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
874: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:
878: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );

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

872: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_trx_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
873: cep_standard.debug('(CE_AUTO_BANK_REC.G_gl_date) = '||to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
874: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:
878: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
880: cep_standard.debug('module = '|| module );

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

874: cep_standard.debug('(CE_AUTO_BANK_MATCH.csl_effective_date) = '|| to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'));
875: cep_standard.debug('exchange_rate = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate));
876: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type = '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
877:
878: cep_standard.debug('to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) = '|| to_number(CE_AUTO_BANK_CLEAR.G_exchange_rate) );
879: cep_standard.debug('CE_AUTO_BANK_MATCH.aba_bank_currency = '|| CE_AUTO_BANK_MATCH.aba_bank_currency );
880: cep_standard.debug('module = '|| module );
881: cep_standard.debug('receipt_history_id = '|| receipt_history_id );
882:

Line 892: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

888: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'CASH';
889: IF (passin_mode <> 'MANUAL_C' ) THEN -- bug 3436722
890: -- 5637589
891: CE_AUTO_BANK_MATCH.trx_org_id := X_org_id;
892: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
893: Y_cleared_trx_type =>receipt_type,
894: Y_cleared_trx_id =>receipt_history_id,
895: Y_ar_cash_receipt_id =>receipt_id,
896: Y_reference_status =>receipt_status,

Line 929: CE_AUTO_BANK_CLEAR.misc_receipt(

925: l_vat_tax_id := X_tax_id;
926: l_tax_rate := X_tax_rate;
927: end if;
928:
929: CE_AUTO_BANK_CLEAR.misc_receipt(
930: X_PASSIN_MODE => passin_mode,
931: X_TRX_NUMBER => X_trx_number,
932: X_DOC_SEQUENCE_VALUE => NULL,
933: X_DOC_SEQUENCE_ID => NULL,

Line 967: cep_standard.debug('<

963: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
964: END IF;
965: END IF;
966: IF l_DEBUG in ('Y', 'C') THEN
967: cep_standard.debug('< 968: END IF;
969: EXCEPTION
970: WHEN OTHERS THEN
971: -- bug 2875549

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

968: END IF;
969: EXCEPTION
970: WHEN OTHERS THEN
971: -- bug 2875549
972: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_rbatch');
973: if (passin_mode = 'AUTO') then
974: IF rbatch_cursor%ISOPEN THEN
975: CLOSE rbatch_cursor;
976: END IF;

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

1035:
1036:
1037: BEGIN
1038: IF l_DEBUG in ('Y', 'C') THEN
1039: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1040: END IF;
1041: auto_reconcile_flag := 'Y';
1042: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1043: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;

Line 1061: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1057: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1058:
1059: END IF;
1060:
1061: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1062: X_effective_date,
1063: X_float_handling_flag);
1064: --
1065: -- The batch cannot be cleared and reconciled as one transaction so each

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

1125: IF l_DEBUG in ('Y', 'C') THEN
1126: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1127: ',cleared_trx_id='||to_char(cleared_trx_id));
1128: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1129: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1130: END IF;
1131:
1132: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1133: Y_cleared_trx_type => cleared_trx_type,

Line 1132: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1128: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1129: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1130: END IF;
1131:
1132: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1133: Y_cleared_trx_type => cleared_trx_type,
1134: Y_cleared_trx_id => cleared_trx_id,
1135: Y_ar_cash_receipt_id => null,
1136: Y_reference_status => null,

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

1144: END IF;
1145:
1146:
1147: IF l_DEBUG in ('Y', 'C') THEN
1148: cep_standard.debug('reconcile_pay_eft: ' || '<<< End CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1149: END IF;
1150:
1151: END LOOP; -- pay_eft_cursor
1152: CLOSE pay_eft_cursor;

Line 1157: cep_standard.debug('<

1153:
1154: END IF;
1155:
1156: IF l_DEBUG in ('Y', 'C') THEN
1157: cep_standard.debug('< 1158: END IF;
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');

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

1157: cep_standard.debug('< 1158: END IF;
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1162: IF pay_eft_cursor%ISOPEN THEN
1163: CLOSE pay_eft_cursor;
1164: END IF;
1165: RAISE;

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

1214: current_org_id number;
1215: X_REMIT_BANK_ACCT_USE_ID number;
1216: BEGIN
1217: IF l_DEBUG in ('Y', 'C') THEN
1218: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.misc_receipt');
1219: END IF;
1220: IF (X_statement_line_id IS NULL) THEN
1221: OPEN C_STATEMENT_LINE_SEQ;
1222: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;

Line 1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

1238: CE_AUTO_BANK_REC.G_cr_vat_tax_code := X_cr_vat_tax_id;
1239: CE_AUTO_BANK_REC.G_dr_vat_tax_code := X_dr_vat_tax_id;
1240: temp := CE_AUTO_BANK_MATCH.validate_payment_method;
1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;

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

1241: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

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

1242: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

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

1243: END IF;
1244: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1245: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1252: END IF;
1253: --

Line 1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1246: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1252: END IF;
1253: --
1254: -- Call the AOL sequence numbering routine to get Seq. number

Line 1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1247: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1248: ELSE
1249: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1250: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1251: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1252: END IF;
1253: --
1254: -- Call the AOL sequence numbering routine to get Seq. number
1255: --

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

1418: ARP_CASHBOOK.clear(X_cr_id,
1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1425: CE_AUTO_BANK_MATCH.aba_bank_currency,
1426: X_bank_account_amount,

Line 1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1419: to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1425: CE_AUTO_BANK_MATCH.aba_bank_currency,
1426: X_bank_account_amount,
1427: 0,

Line 1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,

1420: to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1421: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1422: to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1423: CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1424: CE_AUTO_BANK_CLEAR.G_exchange_rate,
1425: CE_AUTO_BANK_MATCH.aba_bank_currency,
1426: X_bank_account_amount,
1427: 0,
1428: X_module_name,

Line 1433: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1429: '1.0',
1430: cash_receipt_history_id);
1431: END IF;
1432: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'MISC';
1433: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1434: Y_cleared_trx_type => 'MISC',
1435: Y_cleared_trx_id => cash_receipt_history_id,
1436: Y_ar_cash_receipt_id => X_cr_id,
1437: Y_reference_status => NULL,

Line 1443: cep_standard.debug('<

1439: Y_status_flag => 'M',
1440: Y_amount => X_bank_account_amount);
1441: END IF;
1442: IF l_DEBUG in ('Y', 'C') THEN
1443: cep_standard.debug('< 1444: END IF;
1445: END misc_receipt;
1446:
1447: /* ---------------------------------------------------------------------

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

1486: x_legal_entity_id number;
1487:
1488: BEGIN
1489: IF l_DEBUG in ('Y', 'C') THEN
1490: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1491: cep_standard.debug('passin_mode='||passin_mode );
1492: END IF;
1493: auto_reconciled_flag := 'Y';
1494: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

Line 1494: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1490: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1491: cep_standard.debug('passin_mode='||passin_mode );
1492: END IF;
1493: auto_reconciled_flag := 'Y';
1494: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1495: X_effective_date,
1496: X_float_handling_flag);
1497: IF (passin_mode IN ( 'MANUAL', 'MANUAL_H', 'MANUAL_C')) THEN
1498: --IF (statement_line_id IS NULL) THEN

Line 1522: CE_AUTO_BANK_CLEAR1.create_statement_line;

1518: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1519: CE_AUTO_BANK_MATCH.trx_status := NULL;
1520: auto_reconciled_flag := 'N';
1521: IF( passin_mode = 'MANUAL_H') THEN
1522: CE_AUTO_BANK_CLEAR1.create_statement_line;
1523: IF(X_statement_header_id IS NULL)THEN
1524: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
1525: END IF;
1526: END IF;

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

1525: END IF;
1526: END IF;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

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

1526: END IF;
1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

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

1527: END IF;
1528: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1529: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1536: END IF;
1537: ------------------------------------------------------------------------

Line 1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1530: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1536: END IF;
1537: ------------------------------------------------------------------------
1538: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722

Line 1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1531: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1532: ELSE
1533: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1534: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1535: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1536: END IF;
1537: ------------------------------------------------------------------------
1538: IF (passin_mode <> 'MANUAL_C' ) THEN --bug 3436722
1539: -- bug 5350073 ce_available_transactions_tmp is not populated when

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

1557: IF l_DEBUG in ('Y', 'C') THEN
1558: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1559: ', check_id='||check_id||',check_status='||check_status );
1560: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1561: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1562: END IF;
1563: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1564: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1565: Y_cleared_trx_id => check_id,

Line 1563: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1559: ', check_id='||check_id||',check_status='||check_status );
1560: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1561: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1562: END IF;
1563: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1564: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1565: Y_cleared_trx_id => check_id,
1566: Y_ar_cash_receipt_id => NULL,
1567: Y_reference_status => check_status,

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);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1595: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1596: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

Line 1596: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1595: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1596: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1597: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1598: Y_cleared_trx_id => check_id,
1599: Y_ar_cash_receipt_id => NULL,
1600: Y_reference_status => check_status,

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

1619: 'X_ERROR_AMOUNT: '||to_char(errors_amount)|| chr(10) ||
1620: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1621: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1622: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1623: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1624: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1625: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1626: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1627: END IF;

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

1620: 'X_CHARGE_AMOUNT: '||to_char(charges_amount)|| chr(10) ||
1621: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1622: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1623: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1624: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1625: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1626: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1627: END IF;
1628: */

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

1621: 'X_CURRENCY_CODE: '||X_currency_code|| chr(10) ||
1622: 'X_BANK_CURRENCY_CODE: '||X_bank_currency_code|| chr(10) ||
1623: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type|| chr(10) ||
1624: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date|| chr(10) ||
1625: 'X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)|| chr(10) ||
1626: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1627: END IF;
1628: */
1629: ------------------------------------------------------------------------------

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

1633:
1634: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1635: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1636:
1637: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1638: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1639: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1640:
1641: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||

Line 1638: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||

1634: cep_standard.debug('amount_to_clear='||NVL(amount_to_clear,0)||', errors_amount='||NVL(errors_amount,0)||
1635: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1636:
1637: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1638: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1639: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1640:
1641: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1642: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);

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

1635: ', charges_amount='||NVL(charges_amount,0)||', X_bank_currency_code='||X_bank_currency_code);
1636:
1637: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate_type='||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1638: ', CE_AUTO_BANK_CLEAR.G_exchange_date='||to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD') ||
1639: ', CE_AUTO_BANK_CLEAR.G_exchange_rate='||CE_AUTO_BANK_CLEAR.G_exchange_rate);
1640:
1641: cep_standard.debug('CE_AUTO_BANK_MATCH.csl_effective_date='||to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD')||
1642: ', passin_mode='||passin_mode ||', statement_line_id='||statement_line_id);
1643:

Line 1660: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1656: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1657: X_ERROR_AMOUNT => NVL(errors_amount,0),
1658: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1659: X_CURRENCY_CODE => X_bank_currency_code,
1660: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1661: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1662: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1663: X_MATCHED_FLAG => 'Y',
1664: X_ACTUAL_VALUE_DATE =>

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

1657: X_ERROR_AMOUNT => NVL(errors_amount,0),
1658: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1659: X_CURRENCY_CODE => X_bank_currency_code,
1660: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1661: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1662: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1663: X_MATCHED_FLAG => 'Y',
1664: X_ACTUAL_VALUE_DATE =>
1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1662: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1658: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1659: X_CURRENCY_CODE => X_bank_currency_code,
1660: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1661: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1662: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1663: X_MATCHED_FLAG => 'Y',
1664: X_ACTUAL_VALUE_DATE =>
1665: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1666: X_LAST_UPDATE_DATE => sysdate,

Line 1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '

1671: X_PROGRAM_UPDATE_DATE => sysdate,
1672: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1673: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1674: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1675: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1676: );
1677: IF l_DEBUG in ('Y', 'C') THEN
1678: cep_standard.debug('reconcile_pbatch: ' || '<< 1679: END IF;

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

1688: P_TRANSACTION_AMOUNT => NVL(amount_to_clear,0), -- in bank curr.
1689: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1690: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1691: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1692: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1693: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1694: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1695: P_MATCHED_FLAG => 'Y',
1696: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

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

1689: P_ERROR_AMOUNT => NVL(errors_amount,0), -- in bank curr.
1690: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1691: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1692: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1693: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1694: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1695: P_MATCHED_FLAG => 'Y',
1696: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: P_PASSIN_MODE => passin_mode ,

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

1690: P_CHARGE_AMOUNT => NVL(charges_amount,0), -- in bank curr.
1691: P_CURRENCY_CODE => X_bank_currency_code, -- bank curr. code
1692: P_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type, -- between payment and functional
1693: P_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'), -- between payment and functional
1694: P_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate, -- between payment and functional
1695: P_MATCHED_FLAG => 'Y',
1696: P_ACTUAL_VALUE_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1697: P_PASSIN_MODE => passin_mode ,
1698: P_STATEMENT_LINE_ID => statement_line_id ,

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

1705: P_PROGRAM_UPDATE_DATE => sysdate,
1706: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1707: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1708: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1709: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1710: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1711:
1712: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1713:

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

1721: update ce_statement_reconcils_all r
1722: set amount =
1723: (select DECODE(c.currency_code,
1724: X_bank_currency_code, c.cleared_amount,
1725: nvl(c.cleared_base_amount, c.cleared_amount*CE_AUTO_BANK_CLEAR.G_exchange_rate))
1726: from ap_checks_all c
1727: where c.check_id = r.reference_id)
1728: where statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id
1729: and reference_type = 'PAYMENT'

Line 1735: cep_standard.debug('<

1731: and current_record_flag = 'Y'
1732: and amount is null;
1733: END IF;
1734: IF l_DEBUG in ('Y', 'C') THEN
1735: cep_standard.debug('< 1736: END IF;
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');

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

1735: cep_standard.debug('< 1736: END IF;
1737: EXCEPTION
1738: WHEN OTHERS THEN
1739: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1740: if (passin_mode = 'AUTO') then
1741: IF pbatch_cursor%ISOPEN THEN
1742: CLOSE pbatch_cursor;
1743: END IF;

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

1791: x_trx_amount2 NUMBER;
1792: x_trx_amount3 NUMBER;
1793: BEGIN
1794: IF l_DEBUG in ('Y', 'C') THEN
1795: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1796: END IF;
1797: IF (passin_mode <> 'MANUAL_C') THEN
1798: clearing_flag := 'Y';
1799: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

Line 1799: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1795: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1796: END IF;
1797: IF (passin_mode <> 'MANUAL_C') THEN
1798: clearing_flag := 'Y';
1799: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1800: X_effective_date,
1801: X_float_handling_flag);
1802: END IF;
1803: IF (passin_mode IN ('MANUAL_L','MANUAL_C')) THEN

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

1839: END IF;
1840:
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

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

1840:
1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

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

1841:
1842: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

1843: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1850: END IF;
1851: if (passin_mode = 'AUTO') then

Line 1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

1844: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1850: END IF;
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND

Line 1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

1845: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
1846: ELSE
1847: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
1848: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
1849: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
1850: END IF;
1851: if (passin_mode = 'AUTO') then
1852: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'ADJUSTMENT' AND
1853: CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then

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

1889: p_cr_id => to_number(ar_cash_receipt_id),
1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1897: p_amount_cleared => amount_cleared * clearing_sign,

Line 1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1890: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1897: p_amount_cleared => amount_cleared * clearing_sign,
1898: p_amount_factored => charges_amount,

Line 1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1891: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1892: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1893: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1894: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1895: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1896: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
1897: p_amount_cleared => amount_cleared * clearing_sign,
1898: p_amount_factored => charges_amount,
1899: p_module_name => 'CE_AUTO_BANK_REC',

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

1929: 'X_TRANSACTION_AMOUNT: '||to_char(amount_cleared*clearing_sign)||
1930: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1932: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1933: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1934: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1935: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1936: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1937: END IF;

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

1930: 'X_ERROR_AMOUNT: '||to_char(errors_amount)||
1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1932: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1933: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1934: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1935: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1936: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1937: END IF;
1938:

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

1931: 'X_CHARGE_AMOUNT: '||to_char(charges_amount));
1932: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
1933: 'X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type||
1934: 'X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date);
1935: cep_standard.debug('X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate)||
1936: 'X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
1937: END IF;
1938:
1939: IF l_DEBUG in ('Y', 'C') THEN

Line 1953: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

1949: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
1950: X_ERROR_AMOUNT => NVL(errors_amount,0),
1951: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1952: X_CURRENCY_CODE => X_bank_currency,
1953: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1954: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1955: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1956: X_MATCHED_FLAG => clearing_flag,
1957: X_ACTUAL_VALUE_DATE =>

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

1950: X_ERROR_AMOUNT => NVL(errors_amount,0),
1951: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1952: X_CURRENCY_CODE => X_bank_currency,
1953: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1954: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1955: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1956: X_MATCHED_FLAG => clearing_flag,
1957: X_ACTUAL_VALUE_DATE =>
1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),

Line 1955: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

1951: X_CHARGE_AMOUNT => NVL(charges_amount,0),
1952: X_CURRENCY_CODE => X_bank_currency,
1953: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
1954: X_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1955: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
1956: X_MATCHED_FLAG => clearing_flag,
1957: X_ACTUAL_VALUE_DATE =>
1958: to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1959: X_LAST_UPDATE_DATE => sysdate,

Line 1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '

1964: X_PROGRAM_UPDATE_DATE => sysdate,
1965: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1966: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1967: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1968: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
1969: );
1970: IF l_DEBUG in ('Y', 'C') THEN
1971: cep_standard.debug('reconcile_stmt: ' || '<< 1972: END IF;

Line 2039: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2035: and reference_type = tx_type
2036: and nvl(current_record_flag, 'N') = 'Y'
2037: and nvl(request_id, -999) <> nvl(FND_GLOBAL.conc_request_id,-1);
2038:
2039: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2040: Y_statement_line_id => x_trx_id,
2041: Y_cleared_trx_type => 'STATEMENT',
2042: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2043: Y_ar_cash_receipt_id => to_number(NULL),

Line 2049: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2045: Y_auto_reconciled_flag => auto_reconciled_flag,
2046: Y_status_flag => 'M',
2047: Y_amount => x_trx_amount );
2048:
2049: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2050: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2051: Y_cleared_trx_type => 'STATEMENT',
2052: Y_cleared_trx_id => x_trx_id,
2053: Y_ar_cash_receipt_id => to_number(NULL),

Line 2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2082: ||', CE_AUTO_BANK_MATCH.trx_match_type: ' ||CE_AUTO_BANK_MATCH.trx_match_type);
2083: END IF;
2084:
2085: if (CE_AUTO_BANK_MATCH.reconciled_this_run is NULL) then
2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2087: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2088: Y_cleared_trx_type => cleared_trx_type,
2089: Y_cleared_trx_id => cleared_trx_id,
2090: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2129: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2125: -1 * CE_AUTO_BANK_MATCH.csl_amount;
2126: end if;
2127: end if;
2128:
2129: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2130: Y_statement_line_id => CE_AUTO_BANK_MATCH.trx_id,
2131: Y_cleared_trx_type => 'STATEMENT',
2132: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2133: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2139: CE_AUTO_BANK_CLEAR.update_line_status(

2135: Y_auto_reconciled_flag => auto_reconciled_flag,
2136: Y_status_flag => 'M',
2137: Y_amount => CE_AUTO_BANK_MATCH.csl_amount);
2138:
2139: CE_AUTO_BANK_CLEAR.update_line_status(
2140: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2141:
2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2143: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,

Line 2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2138:
2139: CE_AUTO_BANK_CLEAR.update_line_status(
2140: CE_AUTO_BANK_MATCH.trx_id,'RECONCILED');
2141:
2142: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2143: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2144: Y_cleared_trx_type => 'STATEMENT',
2145: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.trx_id,
2146: Y_ar_cash_receipt_id => ar_cash_receipt_id,

Line 2152: CE_AUTO_BANK_CLEAR.update_line_status(

2148: Y_auto_reconciled_flag => auto_reconciled_flag,
2149: Y_status_flag => 'M',
2150: Y_amount => x_trx_amount2);
2151:
2152: CE_AUTO_BANK_CLEAR.update_line_status(
2153: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2154: end if;
2155: IF l_DEBUG in ('Y', 'C') THEN
2156: cep_standard.debug('<

Line 2156: cep_standard.debug('<

2152: CE_AUTO_BANK_CLEAR.update_line_status(
2153: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2154: end if;
2155: IF l_DEBUG in ('Y', 'C') THEN
2156: cep_standard.debug('< 2157: END IF;
2158: END reconcile_stmt;
2159:
2160: /* ---------------------------------------------------------------------

Line 2205: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx '||

2201: X_RECONCILED_METHOD VARCHAR2(1);
2202: current_org_id NUMBER;
2203: BEGIN
2204: IF l_DEBUG in ('Y', 'C') THEN
2205: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx '||
2206: ', CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2207: END IF;
2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN

Line 2206: ', CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);

2202: current_org_id NUMBER;
2203: BEGIN
2204: IF l_DEBUG in ('Y', 'C') THEN
2205: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx '||
2206: ', CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2207: END IF;
2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;

Line 2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;

2208:
2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
2211: --CE_AUTO_BANK_REC.G_legal_entity_id := X_legal_entity_id;
2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2214: END IF;
2215:
2216: --fnd_message.debug('CE_AUTO_BANK_REC.G_org_id = '||CE_AUTO_BANK_REC.G_org_id);

Line 2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;

2209: IF (X_org_id is not null or X_legal_entity_id is not null) THEN
2210: --CE_AUTO_BANK_REC.G_org_id := X_org_id;
2211: --CE_AUTO_BANK_REC.G_legal_entity_id := X_legal_entity_id;
2212: CE_AUTO_BANK_CLEAR.G_org_id := X_org_id;
2213: CE_AUTO_BANK_CLEAR.G_legal_entity_id := X_legal_entity_id;
2214: END IF;
2215:
2216: --fnd_message.debug('CE_AUTO_BANK_REC.G_org_id = '||CE_AUTO_BANK_REC.G_org_id);
2217:

Line 2220: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

2216: --fnd_message.debug('CE_AUTO_BANK_REC.G_org_id = '||CE_AUTO_BANK_REC.G_org_id);
2217:
2218: IF (passin_mode <> 'MANUAL_C') THEN
2219: clearing_flag := 'Y';
2220: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
2221: X_effective_date,
2222: X_float_handling_flag);
2223: END IF;
2224: IF (passin_mode IN ('MANUAL_H','MANUAL_L','MANUAL_C')) THEN

Line 2252: CE_AUTO_BANK_CLEAR1.create_statement_line;

2248: CE_AUTO_BANK_MATCH.csl_charges_amount := charges_amount;
2249: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
2250: CE_AUTO_BANK_MATCH.reversed_receipt_flag := X_reversed_receipt_flag;
2251: IF (passin_mode = 'MANUAL_H' ) THEN
2252: CE_AUTO_BANK_CLEAR1.create_statement_line;
2253: IF(X_statement_header_id IS NULL)THEN
2254: X_statement_header_id := CE_AUTO_BANK_MATCH.csh_statement_header_id;
2255: END IF;
2256: END IF;

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

2258: CE_AUTO_BANK_MATCH.csl_trx_date := cleared_date;
2259: END IF;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

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

2259: END IF;
2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

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

2260: END IF;
2261: IF (trx_currency_type IN ('FOREIGN','BANK')) THEN
2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

Line 2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;

2262: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := CE_AUTO_BANK_MATCH.csl_exchange_rate_type;
2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and

Line 2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;

2263: CE_AUTO_BANK_CLEAR.G_exchange_date := CE_AUTO_BANK_MATCH.csl_exchange_rate_date;
2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN

Line 2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;

2264: CE_AUTO_BANK_CLEAR.G_exchange_rate := CE_AUTO_BANK_MATCH.csl_exchange_rate;
2265: ELSE
2266: CE_AUTO_BANK_CLEAR.G_exchange_rate_type := NULL;
2267: CE_AUTO_BANK_CLEAR.G_exchange_date := NULL;
2268: CE_AUTO_BANK_CLEAR.G_exchange_rate := NULL;
2269: END IF;
2270: IF(CE_AUTO_BANK_MATCH.csl_reconcile_flag = 'OI' and
2271: CE_AUTO_BANK_MATCH.csl_clearing_trx_type = 'XTR_LINE') THEN
2272: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'XTR_LINE';

Line 2321: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2317: X_CLEARED_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2320: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2321: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2322: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2323: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2324: X_PASSIN_MODE => passin_mode,
2325: x_statement_line_id => x_statement_line_id,

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

2318: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2320: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2321: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2322: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2323: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2324: X_PASSIN_MODE => passin_mode,
2325: x_statement_line_id => x_statement_line_id,
2326: x_statement_line_type => x_statement_line_type

Line 2323: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2319: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2320: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2321: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2322: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2323: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2324: X_PASSIN_MODE => passin_mode,
2325: x_statement_line_id => x_statement_line_id,
2326: x_statement_line_type => x_statement_line_type
2327: ) ;

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

2403: ' X_TRANSACTION_AMOUNT: '||to_char(amount_cleared));
2404: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2405: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2406: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2407: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2409: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');

Line 2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||

2404: cep_standard.debug('X_ERROR_AMOUNT: '||to_char(errors_amount)||
2405: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2406: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2407: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2409: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2412: END IF;

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

2405: ' X_CHARGE_AMOUNT: '||to_char(charges_amount));
2406: cep_standard.debug('X_CURRENCY_CODE: '||X_currency_code||
2407: ' X_EXCHANGE_RATE_TYPE: '||CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2408: cep_standard.debug('X_EXCHANGE_RATE_DATE: '||CE_AUTO_BANK_CLEAR.G_exchange_date||
2409: ' X_EXCHANGE_RATE: '||to_char(CE_AUTO_BANK_CLEAR.G_exchange_rate));
2410: cep_standard.debug('X_ACTUAL_VALUE_DATE: '||CE_AUTO_BANK_MATCH.csl_effective_date);
2411: cep_standard.debug('reconcile_trx >>>AP_RECONCILIATION_PKG.recon_payment_history');
2412: END IF;
2413:

Line 2424: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2420: X_TRANSACTION_TYPE => 'PAYMENT CLEARING',
2421: X_ERROR_AMOUNT => NVL(errors_amount,0),
2422: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2423: X_CURRENCY_CODE => X_bank_currency,
2424: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2425: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2426: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2427: X_MATCHED_FLAG => clearing_flag,
2428: X_ACTUAL_VALUE_DATE =>

Line 2425: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,

2421: X_ERROR_AMOUNT => NVL(errors_amount,0),
2422: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2423: X_CURRENCY_CODE => X_bank_currency,
2424: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2425: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2426: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2427: X_MATCHED_FLAG => clearing_flag,
2428: X_ACTUAL_VALUE_DATE =>
2429: CE_AUTO_BANK_MATCH.csl_effective_date,

Line 2426: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2422: X_CHARGE_AMOUNT => NVL(charges_amount,0),
2423: X_CURRENCY_CODE => X_bank_currency,
2424: X_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2425: X_EXCHANGE_RATE_DATE => CE_AUTO_BANK_CLEAR.G_exchange_date,
2426: X_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2427: X_MATCHED_FLAG => clearing_flag,
2428: X_ACTUAL_VALUE_DATE =>
2429: CE_AUTO_BANK_MATCH.csl_effective_date,
2430: X_LAST_UPDATE_DATE => sysdate,

Line 2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '

2435: X_PROGRAM_UPDATE_DATE => sysdate,
2436: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2437: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2438: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2439: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx '
2440: );
2441:
2442: IF l_DEBUG in ('Y', 'C') THEN
2443: cep_standard.debug('reconcile_trx: ' || '<<

Line 2536: cep_standard.debug('reconcile_trx: ' || '<

2532: end if;
2533: exception
2534: when no_data_found then
2535: IF l_DEBUG in ('Y', 'C') THEN
2536: cep_standard.debug('reconcile_trx: ' || '< 2537: 'NO DATA FOUND');
2538: END IF;
2539: raise;
2540: when others then

Line 2543: '<

2539: raise;
2540: when others then
2541: IF l_DEBUG in ('Y', 'C') THEN
2542: cep_standard.debug('reconcile_trx: ' ||
2543: '< 2544: END IF;
2545: raise;
2546: end;
2547: END IF;

Line 2551: CE_AUTO_BANK_CLEAR1.check_matching_status(ar_cash_receipt_id,

2547: END IF;
2548:
2549: ELSE
2550: IF (reference_status <> 'REVERSED' AND NOT
2551: CE_AUTO_BANK_CLEAR1.check_matching_status(ar_cash_receipt_id,
2552: reference_status)) THEN
2553: FND_MESSAGE.set_name('CE','CE_MATCHED_AR_ENTRY');
2554: RAISE APP_EXCEPTION.application_exception;
2555: ELSE

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

2579: cep_standard.debug('reconcile_trx: ' || ' ar_cash_receipt_id= '|| ar_cash_receipt_id ||
2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2586: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2587: ' amount_cleared = '|| amount_cleared);

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

2580: ' CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date ||
2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2586: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2587: ' amount_cleared = '|| amount_cleared);
2588: cep_standard.debug('charges_amount = '|| charges_amount ||

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

2581: ' CE_AUTO_BANK_REC.G_gl_date= '|| CE_AUTO_BANK_REC.G_gl_date);
2582: cep_standard.debug(' CE_AUTO_BANK_MATCH.csl_effective_date= '|| CE_AUTO_BANK_MATCH.csl_effective_date ||
2583: ' CE_AUTO_BANK_CLEAR.G_exchange_date= '|| CE_AUTO_BANK_CLEAR.G_exchange_date ||
2584: ' CE_AUTO_BANK_CLEAR.G_exchange_rate_type= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate_type);
2585: cep_standard.debug('CE_AUTO_BANK_CLEAR.G_exchange_rate= '|| CE_AUTO_BANK_CLEAR.G_exchange_rate ||
2586: 'CE_AUTO_BANK_MATCH.aba_bank_currency= '|| CE_AUTO_BANK_MATCH.aba_bank_currency ||
2587: ' amount_cleared = '|| amount_cleared);
2588: cep_standard.debug('charges_amount = '|| charges_amount ||
2589: ' cleared_trx_id = '|| cleared_trx_id);

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

2594: p_cr_id => to_number(ar_cash_receipt_id),
2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2602: p_amount_cleared => amount_cleared,

Line 2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2595: p_trx_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2602: p_amount_cleared => amount_cleared,
2603: p_amount_factored => charges_amount,

Line 2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2596: p_gl_date => to_date(to_char(CE_AUTO_BANK_REC.G_gl_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2597: p_actual_value_date => to_date(to_char(CE_AUTO_BANK_MATCH.csl_effective_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2598: p_exchange_date => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2599: p_exchange_rate_type => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2600: p_exchange_rate => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2601: p_bank_currency => CE_AUTO_BANK_MATCH.aba_bank_currency,
2602: p_amount_cleared => amount_cleared,
2603: p_amount_factored => charges_amount,
2604: p_module_name => 'CE_AUTO_BANK_REC',

Line 2624: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2620: cep_standard.debug('reconcile_trx: ' ||',reference_status='||reference_status||
2621: ',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='|| to_char(amount_cleared));
2622: END IF;
2623:
2624: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2625: Y_cleared_trx_type => cleared_trx_type,
2626: Y_cleared_trx_id => cleared_trx_id,
2627: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2628: Y_reference_status => reference_status,

Line 2635: cep_standard.debug('<

2631: Y_amount => amount_cleared);
2632: END IF;
2633:
2634: IF l_DEBUG in ('Y', 'C') THEN
2635: cep_standard.debug('< 2636: END IF;
2637:
2638: END reconcile_trx;
2639:

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

2675:
2676: BEGIN
2677:
2678: IF l_DEBUG in ('Y', 'C') THEN
2679: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2680:
2681: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2682: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2683: ', legal_entity_id = ' ||legal_entity_id);

Line 2705: CE_AUTO_BANK_CLEAR.G_org_id := org_id;

2701: END IF;
2702:
2703: --CE_AUTO_BANK_REC.G_org_id := org_id;
2704: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2705: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2706: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2707:
2708: IF (org_id is not null) THEN
2709: select mo_global.GET_CURRENT_ORG_ID

Line 2706: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;

2702:
2703: --CE_AUTO_BANK_REC.G_org_id := org_id;
2704: --CE_AUTO_BANK_REC.G_legal_entity_id := legal_entity_id;
2705: CE_AUTO_BANK_CLEAR.G_org_id := org_id;
2706: CE_AUTO_BANK_CLEAR.G_legal_entity_id := legal_entity_id;
2707:
2708: IF (org_id is not null) THEN
2709: select mo_global.GET_CURRENT_ORG_ID
2710: into current_org_id

Line 2766: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '

2762: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2763: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
2764: X_PROGRAM_ID => to_number(NULL),
2765: X_REQUEST_ID => to_number(NULL),
2766: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2767: );
2768: IF l_DEBUG in ('Y', 'C') THEN
2769: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2770: END IF;

Line 2855: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2851: X_CLEARED_DATE => trx_date,
2852: X_CLEARED_AMOUNT => transaction_amount,
2853: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2854: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2855: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2856: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2857: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2858: X_PASSIN_MODE => passin_mode,
2859: x_statement_line_id => stmt_line_id,

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

2852: X_CLEARED_AMOUNT => transaction_amount,
2853: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2854: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2855: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2856: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2857: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2858: X_PASSIN_MODE => passin_mode,
2859: x_statement_line_id => stmt_line_id,
2860: x_statement_line_type => null

Line 2857: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2853: X_CLEARED_ERROR_AMOUNT => NVL(error_amount,0),
2854: X_CLEARED_CHARGE_AMOUNT => NVL(charge_amount,0),
2855: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2856: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2857: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2858: X_PASSIN_MODE => passin_mode,
2859: x_statement_line_id => stmt_line_id,
2860: x_statement_line_type => null
2861: ) ;

Line 2877: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,

2873: X_CLEARED_DATE => trx_date,
2874: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2875: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2876: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2877: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2878: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2879: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2880: X_PASSIN_MODE => passin_mode
2881: ) ;

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

2874: X_CLEARED_AMOUNT => NVL(amount_cleared,0),
2875: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2876: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2877: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2878: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2879: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2880: X_PASSIN_MODE => passin_mode
2881: ) ;
2882: */

Line 2879: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,

2875: X_CLEARED_ERROR_AMOUNT => NVL(errors_amount,0),
2876: X_CLEARED_CHARGE_AMOUNT => NVL(charges_amount,0),
2877: X_CLEARED_EXCHANGE_RATE_TYPE => CE_AUTO_BANK_CLEAR.G_exchange_rate_type,
2878: X_CLEARED_EXCHANGE_RATE_DATE => to_date(to_char(CE_AUTO_BANK_CLEAR.G_exchange_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
2879: X_CLEARED_EXCHANGE_RATE => CE_AUTO_BANK_CLEAR.G_exchange_rate,
2880: X_PASSIN_MODE => passin_mode
2881: ) ;
2882: */
2883: IF l_DEBUG in ('Y', 'C') THEN

Line 2895: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2891: -- bug 4247469 the CE_AUTO_BANK_MATCH.csl_reconcile_flag need to be cleared
2892: -- in case a journal is processed before the stmt transaction
2893: CE_AUTO_BANK_MATCH.csl_reconcile_flag := NULL;
2894:
2895: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2896: Y_statement_line_id => trx_id,
2897: Y_cleared_trx_type => clearing_trx_type,
2898: Y_cleared_trx_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2899: Y_ar_cash_receipt_id => cash_receipt_id,

Line 2904: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);

2900: Y_reference_status => status,
2901: Y_auto_reconciled_flag => 'N',
2902: Y_status_flag => 'U');
2903:
2904: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);
2905:
2906: -- after unreconcile, update the reconciled_status of this trx in the GT table to 'N'
2907: CE_AUTO_BANK_MATCH.update_gt_reconciled_status(260, trx_id, 'N');
2908:

Line 2937: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2933: ELSE
2934: CE_AUTO_BANK_MATCH.csl_reconcile_flag := 'JE';
2935: END IF;
2936:
2937: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2938: Y_statement_line_id => CE_AUTO_BANK_MATCH.csl_statement_line_id,
2939: Y_cleared_trx_type => clearing_trx_type,
2940: Y_cleared_trx_id => trx_id,
2941: Y_ar_cash_receipt_id => cash_receipt_id,

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

2943: Y_auto_reconciled_flag => 'N',
2944: Y_status_flag => 'U');
2945:
2946: IF l_DEBUG in ('Y', 'C') THEN
2947: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2948: END IF;
2949:
2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2951:

Line 2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

2946: IF l_DEBUG in ('Y', 'C') THEN
2947: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2948: END IF;
2949:
2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2951:
2952: IF l_DEBUG in ('Y', 'C') THEN
2953: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2954: END IF;

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

2949:
2950: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2951:
2952: IF l_DEBUG in ('Y', 'C') THEN
2953: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2954: END IF;
2955: END IF;
2956: IF (X_header_or_line = 'HEADERS') THEN
2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

Line 2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

2953: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
2954: END IF;
2955: END IF;
2956: IF (X_header_or_line = 'HEADERS') THEN
2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2958: END IF;
2959: IF l_DEBUG in ('Y', 'C') THEN
2960: cep_standard.debug('< 2961: END IF;

Line 2960: cep_standard.debug('<

2956: IF (X_header_or_line = 'HEADERS') THEN
2957: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
2958: END IF;
2959: IF l_DEBUG in ('Y', 'C') THEN
2960: cep_standard.debug('< 2961: END IF;
2962:
2963: EXCEPTION
2964: when others then

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

2962:
2963: EXCEPTION
2964: when others then
2965: IF l_DEBUG in ('Y', 'C') THEN
2966: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.unclear_process');
2967: END IF;
2968: RAISE;
2969: END unclear_process;
2970:

Line 3191: END CE_AUTO_BANK_CLEAR1;

3187: when others then
3188: null;
3189: END populate_avail_trx;
3190:
3191: END CE_AUTO_BANK_CLEAR1;