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_CLEAR1

Line 1: PACKAGE BODY CE_AUTO_BANK_CLEAR1 AS

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

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

142: X_effective_date DATE,
143: X_float_handling_flag VARCHAR2 ) IS
144: BEGIN
145: IF l_DEBUG in ('Y', 'C') THEN
146: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.validate_effective_date');
147: END IF;
148: IF (X_effective_date > sysdate AND
149: X_float_handling_flag = 'E' AND
150: passin_mode = 'AUTO') THEN

Line 155: cep_standard.debug('<

151: FND_MESSAGE.set_name( 'CE','CE_FLOAT_VIOLATION');
152: RAISE APP_EXCEPTION.application_exception;
153: END IF;
154: IF l_DEBUG in ('Y', 'C') THEN
155: cep_standard.debug('< 156: END IF;
157: END validate_effective_date;
158:
159: /* ---------------------------------------------------------------------

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

181: orig_status IN VARCHAR2) RETURN BOOLEAN IS
182: x_status AR_CASH_RECEIPT_HISTORY_ALL.status%TYPE;
183: BEGIN
184: IF l_DEBUG in ('Y', 'C') THEN
185: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.check_matching_status');
186: END IF;
187: SELECT crh.status
188: INTO x_status
189: FROM ce_statement_recon_gt_v rec, --ce_statement_reconcils_all rec,

Line 208: cep_standard.debug('<

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

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

214: END IF;
215: RETURN TRUE;
216: WHEN OTHERS THEN
217: IF l_DEBUG in ('Y', 'C') THEN
218: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.check_matching_status');
219: END IF;
220: RAISE;
221: END check_matching_status;
222:

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

230: PROCEDURE update_line_unreconciled (X_statement_line_id NUMBER) IS
231: c_count_reconciled NUMBER;
232: BEGIN
233: IF l_DEBUG in ('Y', 'C') THEN
234: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
235: END IF;
236:
237: SELECT count(*)
238: INTO c_count_reconciled

Line 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 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 756: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 913: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 988: cep_standard.debug('<

984: X_org_id => CE_AUTO_BANK_MATCH.trx_org_id );
985: END IF;
986: END IF;
987: IF l_DEBUG in ('Y', 'C') THEN
988: cep_standard.debug('< 989: END IF;
990: EXCEPTION
991: WHEN OTHERS THEN
992: -- bug 2875549

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

989: END IF;
990: EXCEPTION
991: WHEN OTHERS THEN
992: -- bug 2875549
993: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_rbatch');
994: if (passin_mode = 'AUTO') then
995: IF rbatch_cursor%ISOPEN THEN
996: CLOSE rbatch_cursor;
997: END IF;

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

1056:
1057:
1058: BEGIN
1059: IF l_DEBUG in ('Y', 'C') THEN
1060: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1061: END IF;
1062: auto_reconcile_flag := 'Y';
1063: CE_AUTO_BANK_MATCH.csl_bank_trx_number := X_bank_trx_number;
1064: --CE_AUTO_BANK_MATCH.csl_amount := amount_cleared;

Line 1082: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1078: cep_standard.debug('>>CE_AUTO_BANK_MATCH.csl_trx_date = '|| CE_AUTO_BANK_MATCH.csl_trx_date);
1079:
1080: END IF;
1081:
1082: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1083: X_effective_date,
1084: X_float_handling_flag);
1085: --
1086: -- The batch cannot be cleared and reconciled as one transaction so each

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

1146: IF l_DEBUG in ('Y', 'C') THEN
1147: cep_standard.debug('reconcile_pay_eft: ' || 'cleared_trx_type='||cleared_trx_type||
1148: ',cleared_trx_id='||to_char(cleared_trx_id));
1149: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1150: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1151: END IF;
1152:
1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1154: Y_cleared_trx_type => cleared_trx_type,

Line 1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1149: cep_standard.debug(',auto_reconciled_flag='||auto_reconciled_flag||',amount_cleared='||to_char(amount_to_clear));
1150: cep_standard.debug('reconcile_pay_eft: call CE_AUTO_BANK_CLEAR1.insert_reconciliation ');
1151: END IF;
1152:
1153: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1154: Y_cleared_trx_type => cleared_trx_type,
1155: Y_cleared_trx_id => cleared_trx_id,
1156: Y_ar_cash_receipt_id => null,
1157: Y_reference_status => null,

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

1165: END IF;
1166:
1167:
1168: IF l_DEBUG in ('Y', 'C') THEN
1169: cep_standard.debug('reconcile_pay_eft: ' || '<<< End CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1170: END IF;
1171:
1172: END LOOP; -- pay_eft_cursor
1173: CLOSE pay_eft_cursor;

Line 1178: cep_standard.debug('<

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

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

1178: cep_standard.debug('< 1179: END IF;
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: cep_standard.debug('Exception - OTHERS: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft');
1183: IF pay_eft_cursor%ISOPEN THEN
1184: CLOSE pay_eft_cursor;
1185: END IF;
1186: RAISE;

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

1235: current_org_id number;
1236: X_REMIT_BANK_ACCT_USE_ID number;
1237: BEGIN
1238: IF l_DEBUG in ('Y', 'C') THEN
1239: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.misc_receipt');
1240: END IF;
1241: IF (X_statement_line_id IS NULL) THEN
1242: OPEN C_STATEMENT_LINE_SEQ;
1243: FETCH C_STATEMENT_LINE_SEQ INTO X_statement_line_id;

Line 1459: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 1469: cep_standard.debug('<

1465: Y_status_flag => 'M',
1466: Y_amount => X_bank_account_amount);
1467: END IF;
1468: IF l_DEBUG in ('Y', 'C') THEN
1469: cep_standard.debug('< 1470: END IF;
1471: END misc_receipt;
1472:
1473: /* ---------------------------------------------------------------------

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

1512: x_legal_entity_id number;
1513: clearing_flag VARCHAR2(1) := 'N'; -- Bug 13803033
1514: BEGIN
1515: IF l_DEBUG in ('Y', 'C') THEN
1516: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1517: cep_standard.debug('passin_mode='||passin_mode );
1518: END IF;
1519: auto_reconciled_flag := 'Y';
1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

Line 1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1516: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1517: cep_standard.debug('passin_mode='||passin_mode );
1518: END IF;
1519: auto_reconciled_flag := 'Y';
1520: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1521: X_effective_date,
1522: X_float_handling_flag);
1523: -- Bug 13803033 Start
1524: IF (passin_mode <> 'MANUAL_C') THEN

Line 1553: CE_AUTO_BANK_CLEAR1.create_statement_line;

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

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

1588: IF l_DEBUG in ('Y', 'C') THEN
1589: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1590: ', check_id='||check_id||',check_status='||check_status );
1591: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1595: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1596: Y_cleared_trx_id => check_id,

Line 1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

1590: ', check_id='||check_id||',check_status='||check_status );
1591: cep_standard.debug('batch_app_id='||batch_app_id||', l_gt_seq_id='||l_gt_seq_id);
1592: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1593: END IF;
1594: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
1595: Y_cleared_trx_type => batch_trx_type, -- 'PAYMENT',
1596: Y_cleared_trx_id => check_id,
1597: Y_ar_cash_receipt_id => NULL,
1598: Y_reference_status => check_status,

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

1619: IF l_DEBUG in ('Y', 'C') THEN
1620: cep_standard.debug('batch_trx_type='||batch_trx_type ||
1621: ', check_id='||check_id||',check_status='||check_status );
1622: cep_standard.debug('batch_app_id='||batch_app_id);
1623: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.insert_reconciliation');
1624: END IF;
1625: CE_AUTO_BANK_MATCH.trx_org_id := x_org_id;
1626: CE_AUTO_BANK_MATCH.trx_legal_entity_id := x_legal_entity_id;
1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

Line 1627: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '

1702: X_PROGRAM_UPDATE_DATE => sysdate,
1703: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
1704: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1705: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1706: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch '
1707: );
1708: IF l_DEBUG in ('Y', 'C') THEN
1709: cep_standard.debug('reconcile_pbatch: ' || '<< 1710: END IF;

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

1736: P_PROGRAM_UPDATE_DATE => sysdate,
1737: P_PROGRAM_APPLICATION_ID => NVL(FND_GLOBAL.prog_appl_id,-1),
1738: P_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
1739: P_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
1740: P_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_pbatch',
1741: P_LOGICAL_GROUP_REFERENCE => pgroup_id);-- FOR SEPA ER 6700007
1742:
1743: cep_standard.debug('end call IBY_CE_BATCH_RECON_PKG.Payment_Instruction_Clearing');
1744:

Line 1766: cep_standard.debug('<

1762: and current_record_flag = 'Y'
1763: and amount is null;
1764: END IF;
1765: IF l_DEBUG in ('Y', 'C') THEN
1766: cep_standard.debug('< 1767: END IF;
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');

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

1766: cep_standard.debug('< 1767: END IF;
1768: EXCEPTION
1769: WHEN OTHERS THEN
1770: cep_standard.debug('Exception: CE_AUTO_BANK_CLEAR1.reconcile_pbatch');
1771: if (passin_mode = 'AUTO') then
1772: IF pbatch_cursor%ISOPEN THEN
1773: CLOSE pbatch_cursor;
1774: END IF;

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

1822: x_trx_amount2 NUMBER;
1823: x_trx_amount3 NUMBER;
1824: BEGIN
1825: IF l_DEBUG in ('Y', 'C') THEN
1826: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1827: END IF;
1828: IF (passin_mode <> 'MANUAL_C') THEN
1829: clearing_flag := 'Y';
1830: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

Line 1830: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,

1826: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_stmt, passin_mode = '||passin_mode );
1827: END IF;
1828: IF (passin_mode <> 'MANUAL_C') THEN
1829: clearing_flag := 'Y';
1830: CE_AUTO_BANK_CLEAR1.validate_effective_date( passin_mode,
1831: X_effective_date,
1832: X_float_handling_flag);
1833: END IF;
1834: IF (passin_mode IN ('MANUAL_L','MANUAL_C')) THEN

Line 2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '

2001: X_PROGRAM_UPDATE_DATE => sysdate,
2002: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2003: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2004: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2005: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_stmt '
2006: );
2007: IF l_DEBUG in ('Y', 'C') THEN
2008: cep_standard.debug('reconcile_stmt: ' || '<< 2009: END IF;

Line 2076: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2086: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2123: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2166: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2179: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2193: cep_standard.debug('<

2189: CE_AUTO_BANK_CLEAR.update_line_status(
2190: CE_AUTO_BANK_MATCH.csl_statement_line_id, 'RECONCILED');
2191: end if;
2192: IF l_DEBUG in ('Y', 'C') THEN
2193: cep_standard.debug('< 2194: END IF;
2195: END reconcile_stmt;
2196:
2197: /* ---------------------------------------------------------------------

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

2239: X_RESULT VARCHAR2(100);
2240: X_RECONCILED_METHOD VARCHAR2(1);
2241: current_org_id NUMBER;
2242: BEGIN
2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2245:
2246: -- Bug 16298972 Start
2247: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for manual recon.

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

2240: X_RECONCILED_METHOD VARCHAR2(1);
2241: current_org_id NUMBER;
2242: BEGIN
2243: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2244: cep_standard.debug('CE_AUTO_BANK_CLEAR1.csl_reconcile_flag = '||CE_AUTO_BANK_MATCH.csl_reconcile_flag);
2245:
2246: -- Bug 16298972 Start
2247: -- Reset the G_RECEIPT_PROCESSED_FLAG flag for manual recon.
2248: IF G_RECEIPT_PROCESSED_FLAG AND passin_mode <> 'AUTO' THEN

Line 2262: CE_AUTO_BANK_CLEAR1.validate_effective_date(

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

Line 2301: CE_AUTO_BANK_CLEAR1.create_statement_line;

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

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

2499: X_PROGRAM_UPDATE_DATE => sysdate,
2500: X_PROGRAM_APPLICATION_ID=> NVL(FND_GLOBAL.prog_appl_id,-1),
2501: X_PROGRAM_ID => NVL(FND_GLOBAL.conc_program_id,-1),
2502: X_REQUEST_ID => NVL(FND_GLOBAL.conc_request_id,-1),
2503: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.reconcile_trx ');
2504:
2505: cep_standard.debug('reconcile_trx: ' || '<< 2506: END IF;
2507: cleared_trx_id := CE_AUTO_BANK_MATCH.trx_id;

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

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

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

2686: ',reference_status='||reference_status||
2687: ',auto_reconciled_flag='||auto_reconciled_flag||
2688: ',amount_cleared='|| to_char(amount_cleared));
2689:
2690: cep_standard.debug('reconcile_trx: calling CE_AUTO_BANK_CLEAR1.insert_reconciliation');
2691:
2692: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2693: Y_cleared_trx_type => cleared_trx_type,
2694: Y_cleared_trx_id => cleared_trx_id,

Line 2692: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

2688: ',amount_cleared='|| to_char(amount_cleared));
2689:
2690: cep_standard.debug('reconcile_trx: calling CE_AUTO_BANK_CLEAR1.insert_reconciliation');
2691:
2692: CE_AUTO_BANK_CLEAR1.insert_reconciliation (
2693: Y_cleared_trx_type => cleared_trx_type,
2694: Y_cleared_trx_id => cleared_trx_id,
2695: Y_ar_cash_receipt_id => ar_cash_receipt_id,
2696: Y_reference_status => reference_status,

Line 2713: cep_standard.debug('<

2709: cep_standard.debug('Call to AR API ARP_CASHBOOK.refresh_risk_value ended successfully.');
2710: END IF;
2711: -- Bug 16298972 End
2712: */
2713: cep_standard.debug('< 2714:
2715: -- 14840476 : Added exception block
2716: EXCEPTION
2717: WHEN OTHERS THEN

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

2758:
2759: BEGIN
2760:
2761: IF l_DEBUG in ('Y', 'C') THEN
2762: cep_standard.debug('>>CE_AUTO_BANK_CLEAR1.unclear_process');
2763:
2764: cep_standard.debug('passin_mode = ' ||passin_mode||' tx_type = '|| tx_type ||
2765: ', clearing_trx_type = ' ||clearing_trx_type || ', org_id = ' ||org_id ||
2766: ', legal_entity_id = ' ||legal_entity_id);

Line 2853: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '

2849: X_PROGRAM_UPDATE_DATE => to_date(NULL),
2850: X_PROGRAM_APPLICATION_ID=> to_number(NULL),
2851: X_PROGRAM_ID => to_number(NULL),
2852: X_REQUEST_ID => to_number(NULL),
2853: X_CALLING_SEQUENCE => 'CE_AUTO_BANK_CLEAR1.unclear_process '
2854: );
2855: IF l_DEBUG in ('Y', 'C') THEN
2856: cep_standard.debug('unclear_process: ' || '>>>AP_RECONCILIATION_PKG.recon_payment_history');
2857: END IF;

Line 2984: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

Line 2993: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(trx_id);

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

Line 3026: CE_AUTO_BANK_CLEAR1.insert_reconciliation (

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

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

3032: Y_auto_reconciled_flag => 'N',
3033: Y_status_flag => 'U');
3034:
3035: IF l_DEBUG in ('Y', 'C') THEN
3036: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3037: END IF;
3038:
3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3040:

Line 3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

3035: IF l_DEBUG in ('Y', 'C') THEN
3036: cep_standard.debug('call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3037: END IF;
3038:
3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3040:
3041: IF l_DEBUG in ('Y', 'C') THEN
3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3043: END IF;

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

3038:
3039: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3040:
3041: IF l_DEBUG in ('Y', 'C') THEN
3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3043: END IF;
3044: END IF;
3045: IF (X_header_or_line = 'HEADERS') THEN
3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

Line 3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);

3042: cep_standard.debug('end call CE_AUTO_BANK_CLEAR1.update_line_unreconciled');
3043: END IF;
3044: END IF;
3045: IF (X_header_or_line = 'HEADERS') THEN
3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3047: END IF;
3048: IF l_DEBUG in ('Y', 'C') THEN
3049: cep_standard.debug('< 3050: END IF;

Line 3049: cep_standard.debug('<

3045: IF (X_header_or_line = 'HEADERS') THEN
3046: CE_AUTO_BANK_CLEAR1.update_line_unreconciled(stmt_line_id);
3047: END IF;
3048: IF l_DEBUG in ('Y', 'C') THEN
3049: cep_standard.debug('< 3050: END IF;
3051:
3052: EXCEPTION
3053: when others then

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

3051:
3052: EXCEPTION
3053: when others then
3054: IF l_DEBUG in ('Y', 'C') THEN
3055: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR1.unclear_process');
3056: END IF;
3057: RAISE;
3058: END unclear_process;
3059:

Line 3280: END CE_AUTO_BANK_CLEAR1;

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