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