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_CLEAR dependencies on CE_AUTO_BANK_CLEAR

Line 1: PACKAGE BODY CE_AUTO_BANK_CLEAR AS

1: PACKAGE BODY CE_AUTO_BANK_CLEAR AS
2: /* $Header: ceabrcrb.pls 120.14.12010000.3 2008/11/20 09:04:33 vnetan ship $ */
3: CURSOR C_STATEMENT_LINE_SEQ IS SELECT ce_statement_lines_s.nextval from sys.dual;
4:
5: FUNCTION body_revision RETURN VARCHAR2 IS

Line 24: CE_AUTO_BANK_CLEAR.yes_manual_clearing := 1;

20: | set_manual_clearing |
21: --------------------------------------------------------------------- */
22: PROCEDURE set_manual_clearing IS
23: BEGIN
24: CE_AUTO_BANK_CLEAR.yes_manual_clearing := 1;
25: END set_manual_clearing;
26:
27: PROCEDURE set_reverse_mode IS
28: BEGIN

Line 29: CE_AUTO_BANK_CLEAR.yes_reverse_mode := 1;

25: END set_manual_clearing;
26:
27: PROCEDURE set_reverse_mode IS
28: BEGIN
29: CE_AUTO_BANK_CLEAR.yes_reverse_mode := 1;
30: END set_reverse_mode;
31:
32: PROCEDURE unset_manual_clearing IS
33: BEGIN

Line 34: CE_AUTO_BANK_CLEAR.yes_manual_clearing := 0;

30: END set_reverse_mode;
31:
32: PROCEDURE unset_manual_clearing IS
33: BEGIN
34: CE_AUTO_BANK_CLEAR.yes_manual_clearing := 0;
35: END unset_manual_clearing;
36:
37: PROCEDURE unset_reverse_mode IS
38: BEGIN

Line 39: CE_AUTO_BANK_CLEAR.yes_reverse_mode := 0;

35: END unset_manual_clearing;
36:
37: PROCEDURE unset_reverse_mode IS
38: BEGIN
39: CE_AUTO_BANK_CLEAR.yes_reverse_mode := 0;
40: END unset_reverse_mode;
41:
42: FUNCTION get_manual_clearing RETURN NUMBER IS
43: BEGIN

Line 44: RETURN CE_AUTO_BANK_CLEAR.yes_manual_clearing;

40: END unset_reverse_mode;
41:
42: FUNCTION get_manual_clearing RETURN NUMBER IS
43: BEGIN
44: RETURN CE_AUTO_BANK_CLEAR.yes_manual_clearing;
45: END get_manual_clearing;
46:
47: FUNCTION get_reverse_mode RETURN NUMBER IS
48: BEGIN

Line 49: RETURN CE_AUTO_BANK_CLEAR.yes_reverse_mode;

45: END get_manual_clearing;
46:
47: FUNCTION get_reverse_mode RETURN NUMBER IS
48: BEGIN
49: RETURN CE_AUTO_BANK_CLEAR.yes_reverse_mode;
50: END get_reverse_mode;
51:
52: /* ---------------------------------------------------------------------
53: | PRIVATE PROCEDURE |

Line 63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');

59: PROCEDURE update_line_status (
60: X_statement_line_id NUMBER,
61: X_status VARCHAR2) IS
62: BEGIN
63: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.update_line_status');
64: if (X_status = 'RECONCILED') then
65: if (CE_AUTO_BANK_MATCH.trx_currency_type = 'BANK'
66: and CE_AUTO_BANK_MATCH.foreign_exchange_defaulted = 'Y') then
67: UPDATE ce_statement_lines l

Line 102: cep_standard.debug('<

98: reconcile_to_statement_flag =
99: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag
100: WHERE statement_line_id = X_statement_line_id;
101: end if;
102: cep_standard.debug('< 103: EXCEPTION
104: WHEN OTHERS THEN
105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');
106: RAISE;

Line 105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');

101: end if;
102: cep_standard.debug('< 103: EXCEPTION
104: WHEN OTHERS THEN
105: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.update_line_status');
106: RAISE;
107: END update_line_status;
108:
109: /* ---------------------------------------------------------------------

Line 131: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.DM_reversals');

127: doc_sequence_id NUMBER) IS
128: out_trx_number ar_payment_schedules.trx_number%TYPE;
129: out_status varchar2(10);
130: BEGIN
131: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.DM_reversals');
132:
133: ARP_CASHBOOK.debit_memo_reversal
134: ( p_cash_receipt_id => cash_receipt_id,
135: p_cc_id => cc_id,

Line 150: cep_standard.debug('<

146: p_tw_status => out_status,
147: p_module_name => 'CEXCABMR',
148: p_module_version => '11.5');
149:
150: cep_standard.debug('< 151: END DM_reversals;
152:
153: /* ---------------------------------------------------------------------
154: | PRIVATE PROCEDURE |

Line 167: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reversals');

163: module_name VARCHAR2,
164: comment VARCHAR2 ) IS
165: history_id AR_CASH_RECEIPT_HISTORY_ALL.cash_receipt_history_id%TYPE;
166: BEGIN
167: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reversals');
168: ARP_CASHBOOK.reverse( p_cr_id => cash_receipt_id,
169: p_reversal_gl_date => gl_date,
170: p_reversal_date => sysdate,
171: p_reversal_comments => comment,

Line 177: cep_standard.debug('<

173: p_reversal_category => category,
174: p_module_name => module_name,
175: p_module_version => '1.0',
176: p_crh_id => history_id);
177: cep_standard.debug('< 178: END reversals;
179:
180: /* ---------------------------------------------------------------------
181: | PRIVATE PROCEDURE |

Line 227: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_rbatch');

223: X_original_amount NUMBER DEFAULT NULL,
224: X_effective_date DATE,
225: X_float_handling_flag VARCHAR2) IS
226: BEGIN
227: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_rbatch');
228: CE_AUTO_BANK_CLEAR1.reconcile_rbatch(
229: passin_mode,
230: rbatch_id,
231: X_statement_line_id,

Line 228: CE_AUTO_BANK_CLEAR1.reconcile_rbatch(

224: X_effective_date DATE,
225: X_float_handling_flag VARCHAR2) IS
226: BEGIN
227: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_rbatch');
228: CE_AUTO_BANK_CLEAR1.reconcile_rbatch(
229: passin_mode,
230: rbatch_id,
231: X_statement_line_id,
232: gl_date,

Line 265: cep_standard.debug('<

261: X_statement_amount,
262: X_original_amount,
263: X_effective_date,
264: X_float_handling_flag);
265: cep_standard.debug('< 266: END reconcile_rbatch;
267:
268: /* ---------------------------------------------------------------------
269: | PRIVATE PROCEDURE |

Line 306: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.misc_receipt');

302: X_cr_id IN OUT NOCOPY NUMBER,
303: X_effective_date DATE,
304: X_org_id NUMBER ) IS
305: BEGIN
306: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.misc_receipt');
307: CE_AUTO_BANK_CLEAR1.misc_receipt(
308: X_passin_mode,
309: X_trx_number,
310: X_doc_sequence_value,

Line 307: CE_AUTO_BANK_CLEAR1.misc_receipt(

303: X_effective_date DATE,
304: X_org_id NUMBER ) IS
305: BEGIN
306: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.misc_receipt');
307: CE_AUTO_BANK_CLEAR1.misc_receipt(
308: X_passin_mode,
309: X_trx_number,
310: X_doc_sequence_value,
311: X_doc_sequence_id,

Line 341: cep_standard.debug('<

337: trx_currency_type,
338: X_cr_id,
339: X_effective_date,
340: X_org_id);
341: cep_standard.debug('< 342: END misc_receipt;
343:
344: /* ---------------------------------------------------------------------
345: | PRIVATE PROCEDURE |

Line 376: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pbatch');

372: X_bank_currency_code VARCHAR2,
373: pgroup_id VARCHAR2 default null -- FOR SEPA ER 6700007
374: ) IS
375: BEGIN
376: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pbatch');
377: CE_AUTO_BANK_CLEAR1.reconcile_pbatch(
378: passin_mode,
379: pbatch_id,
380: statement_line_id,

Line 377: CE_AUTO_BANK_CLEAR1.reconcile_pbatch(

373: pgroup_id VARCHAR2 default null -- FOR SEPA ER 6700007
374: ) IS
375: BEGIN
376: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pbatch');
377: CE_AUTO_BANK_CLEAR1.reconcile_pbatch(
378: passin_mode,
379: pbatch_id,
380: statement_line_id,
381: gl_date,

Line 402: cep_standard.debug('<

398: X_effective_date,
399: X_float_handling_flag,
400: X_bank_currency_code,
401: pgroup_id);
402: cep_standard.debug('< 403: END reconcile_pbatch;
404:
405: /* ---------------------------------------------------------------------
406: | PRIVATE PROCEDURE |

Line 419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');

415: precision NUMBER;
416: ext_precision NUMBER;
417: min_acct_unit NUMBER;
418: BEGIN
419: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
420: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
421: CE_AUTO_BANK_MATCH.csl_match_type);
422: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.calc_csl_amount = '||
423: CE_AUTO_BANK_MATCH.calc_csl_amount);

Line 630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');

626: CE_AUTO_BANK_MATCH.csl_exchange_rate := real_rate;
627: CE_AUTO_BANK_MATCH.csl_exchange_rate_type := 'User';
628: CE_AUTO_BANK_MATCH.csl_exchange_rate_date := sysdate;
629: END IF;
630: cep_standard.debug('CE_AUTO_BANK_CLEAR.calc_foreign_clearing_amounts');
631: END calc_foreign_clearing_amounts;
632:
633: /* ---------------------------------------------------------------------
634: | PRIVATE PROCEDURE |

Line 648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');

644: difference_amount NUMBER;
645: clearing_sign NUMBER;
646: success BOOLEAN;
647: BEGIN
648: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.calculate_clearing_amounts');
649: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.csl_match_type = '||
650: CE_AUTO_BANK_MATCH.csl_match_type);
651: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_match_type = '||
652: CE_AUTO_BANK_MATCH.trx_match_type);

Line 746: cep_standard.debug('<

742:
743: cep_standard.debug('DEBUG: CE_AUTO_BANK_MATCH.trx_errors_amount = '||
744: CE_AUTO_BANK_MATCH.trx_errors_amount);
745:
746: cep_standard.debug('< 747: RETURN (success);
748: EXCEPTION
749: WHEN OTHERS THEN
750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );

Line 750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );

746: cep_standard.debug('< 747: RETURN (success);
748: EXCEPTION
749: WHEN OTHERS THEN
750: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.calculate_clearing_amounts' );
751: RAISE;
752: END calculate_clearing_amounts;
753:
754: /* ---------------------------------------------------------------------

Line 771: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.trx_remain' );

767: cursor_id INTEGER;
768: exec_id INTEGER;
769:
770: BEGIN
771: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.trx_remain' );
772: tmp_query := 'select count(*)
773: from ce_801_eft_reconciled_v
774: where clearing_trx_type = ''PAY_EFT''
775: and to_char(statement_line_id) in (' || stmt_ln_list ||')

Line 802: cep_standard.debug('<

798: DBMS_SQL.COLUMN_VALUE(cursor_id, 1, count_pay_eft1);
799: END IF;
800:
801: cep_standard.debug('count_pay_eft1 = '|| count_pay_eft1);
802: cep_standard.debug('< 803:
804: return count_pay_eft1;
805:
806: EXCEPTION

Line 808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );

804: return count_pay_eft1;
805:
806: EXCEPTION
807: WHEN OTHERS THEN
808: cep_standard.debug('EXCEPTION - OTHERS: CE_AUTO_BANK_CLEAR.trx_remain' );
809: IF DBMS_SQL.IS_OPEN(cursor_id) THEN
810: DBMS_SQL.CLOSE_CURSOR(cursor_id);
811: cep_standard.debug('Cursor Closed');
812: END IF;

Line 851: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_stmt');

847: X_currency_code VARCHAR2 default NULL,
848: X_bank_trx_number VARCHAR2 default NULL,
849: X_reversed_receipt_flag VARCHAR2) IS
850: BEGIN
851: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_stmt');
852: CE_AUTO_BANK_CLEAR1.reconcile_stmt(
853: passin_mode,
854: tx_type,
855: trx_id,

Line 852: CE_AUTO_BANK_CLEAR1.reconcile_stmt(

848: X_bank_trx_number VARCHAR2 default NULL,
849: X_reversed_receipt_flag VARCHAR2) IS
850: BEGIN
851: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_stmt');
852: CE_AUTO_BANK_CLEAR1.reconcile_stmt(
853: passin_mode,
854: tx_type,
855: trx_id,
856: trx_status,

Line 880: cep_standard.debug('<

876: X_float_handling_flag,
877: X_currency_code,
878: X_bank_trx_number,
879: X_reversed_receipt_flag);
880: cep_standard.debug('< 881: END reconcile_stmt;
882:
883: /* ---------------------------------------------------------------------
884: | PRIVATE PROCEDURE |

Line 921: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_trx');

917: X_reversed_receipt_flag VARCHAR2,
918: X_org_id NUMBER DEFAULT NULL,
919: X_legal_entity_id NUMBER DEFAULT NULL) IS
920: BEGIN
921: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_trx');
922: CE_AUTO_BANK_CLEAR1.reconcile_trx(
923: passin_mode,
924: tx_type,
925: trx_id,

Line 922: CE_AUTO_BANK_CLEAR1.reconcile_trx(

918: X_org_id NUMBER DEFAULT NULL,
919: X_legal_entity_id NUMBER DEFAULT NULL) IS
920: BEGIN
921: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_trx');
922: CE_AUTO_BANK_CLEAR1.reconcile_trx(
923: passin_mode,
924: tx_type,
925: trx_id,
926: trx_status,

Line 954: cep_standard.debug('<

950: X_float_handling_flag,
951: X_reversed_receipt_flag,
952: X_org_id,
953: X_legal_entity_id);
954: cep_standard.debug('< 955: END reconcile_trx;
956:
957: /* ---------------------------------------------------------------------
958: | PRIVATE PROCEDURE |

Line 981: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pay_eft');

977: X_payroll_payment_format VARCHAR2,
978: X_effective_date DATE,
979: X_float_handling_flag VARCHAR2) IS
980: BEGIN
981: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pay_eft');
982: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft(
983: passin_mode,
984: tx_type,
985: trx_count,

Line 982: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft(

978: X_effective_date DATE,
979: X_float_handling_flag VARCHAR2) IS
980: BEGIN
981: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_pay_eft');
982: CE_AUTO_BANK_CLEAR1.reconcile_pay_eft(
983: passin_mode,
984: tx_type,
985: trx_count,
986: trx_group,

Line 1000: cep_standard.debug('<

996: X_bank_account_id,
997: X_payroll_payment_format,
998: X_effective_date,
999: X_float_handling_flag);
1000: cep_standard.debug('< 1001: END reconcile_pay_eft;
1002:
1003: /* ---------------------------------------------------------------------
1004: | PRIVATE PROCEDURE |

Line 1034: CE_AUTO_BANK_CLEAR1.unclear_process(

1030: xrate NUMBER,
1031: org_id NUMBER,
1032: legal_entity_id NUMBER ) IS
1033: BEGIN
1034: CE_AUTO_BANK_CLEAR1.unclear_process(
1035: passin_mode ,
1036: X_header_or_line ,
1037: tx_type ,
1038: clearing_trx_type ,

Line 1077: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_process');

1073: app_short_name VARCHAR2(30);
1074: d_statement_header_id CE_STATEMENT_HEADERS.statement_header_id%TYPE;
1075: misc_number AR_CASH_RECEIPTS_ALL.receipt_number%TYPE;
1076: BEGIN
1077: cep_standard.debug('>>CE_AUTO_BANK_CLEAR.reconcile_process');
1078: --
1079: -- Statement lines
1080: --
1081: IF (CE_AUTO_BANK_MATCH.csl_match_type = 'MISC' AND

Line 1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,

1110: X_currency_code => CE_AUTO_BANK_MATCH.trx_currency_code,
1111: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1112: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := 'Y';
1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');

Line 1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,

1113: if (CE_AUTO_BANK_MATCH.csl_match_correction_type = 'REVERSAL') then
1114: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id,
1115: 'RECONCILED');
1116: else /* ADJUSTMENT */
1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');
1119: end if;
1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
1121: CE_AUTO_BANK_CLEAR.update_line_status(

Line 1121: CE_AUTO_BANK_CLEAR.update_line_status(

1117: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.trx_id2,
1118: 'RECONCILED');
1119: end if;
1120: CE_AUTO_BANK_MATCH.reconcile_to_statement_flag := NULL;
1121: CE_AUTO_BANK_CLEAR.update_line_status(
1122: CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1123: END IF;
1124: --
1125: -- Transaction

Line 1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1153: X_statement_header_id => d_statement_header_id,
1154: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1155: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1156: X_reversed_receipt_flag => CE_AUTO_BANK_MATCH.reversed_receipt_flag);
1157: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1158: END IF;
1159: --
1160: -- Payroll EFT Transaction
1161: --

Line 1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1178: X_bank_account_id => CE_AUTO_BANK_MATCH.csh_bank_account_id,
1179: X_payroll_payment_format => CE_AUTO_BANK_MATCH.csl_payroll_payment_format,
1180: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1181: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1182: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1183: END IF;
1184: --
1185: -- Payment Batch
1186: --

Line 1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1206: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1207: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1208: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency);
1209:
1210: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1211: END IF;
1212: --
1213: -- Payment Group
1214: --

Line 1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1235: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1236: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag,
1237: X_bank_currency_code => CE_AUTO_BANK_MATCH.aba_bank_currency,
1238: pgroup_id => CE_AUTO_BANK_MATCH.LOGICAL_GROUP_REFERENCE);
1239: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1240: END IF;
1241: --
1242: -- Remittance Batch
1243: --

Line 1260: module => 'CE_AUTO_BANK_CLEAR',

1256: exchange_rate_type => CE_AUTO_BANK_MATCH.csl_exchange_rate_type,
1257: exchange_rate => CE_AUTO_BANK_MATCH.csl_exchange_rate,
1258: exchange_rate_date => CE_AUTO_BANK_MATCH.csl_exchange_rate_date,
1259: trx_currency_type => CE_AUTO_BANK_MATCH.trx_currency_type,
1260: module => 'CE_AUTO_BANK_CLEAR',
1261: X_TRX_NUMBER => misc_number,
1262: X_TRX_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1263: X_DEPOSIT_DATE => to_date(to_char(CE_AUTO_BANK_MATCH.csl_trx_date,'YYYY/MM/DD'),'YYYY/MM/DD'),
1264: X_AMOUNT => -CE_AUTO_BANK_MATCH.trx_charges_amount,

Line 1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');

1277: X_DR_VAT_TAX_ID => CE_AUTO_BANK_REC.G_dr_vat_tax_code,
1278: X_statement_header_id => d_statement_header_id,
1279: X_effective_date => CE_AUTO_BANK_MATCH.csl_effective_date,
1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1282: END IF;
1283: END IF;
1284: cep_standard.debug('< 1285: EXCEPTION

Line 1284: cep_standard.debug('<

1280: X_float_handling_flag => CE_AUTO_BANK_REC.G_float_handling_flag);
1281: CE_AUTO_BANK_CLEAR.update_line_status(CE_AUTO_BANK_MATCH.csl_statement_line_id,'RECONCILED');
1282: END IF;
1283: END IF;
1284: cep_standard.debug('< 1285: EXCEPTION
1286: WHEN APP_EXCEPTION.application_exception THEN
1287: encoded_message := FND_MESSAGE.GET_ENCODED;
1288: IF (encoded_message IS NOT NULL) THEN

Line 1307: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.reconcile_process OTHERS');

1303: --DELETE FROM ce_statement_reconciliations
1304: DELETE FROM ce_statement_reconcils_all
1305: WHERE statement_line_id = CE_AUTO_BANK_MATCH.csl_statement_line_id;
1306: WHEN OTHERS THEN
1307: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_CLEAR.reconcile_process OTHERS');
1308: /*
1309: IF (rbatch_cursor%ISOPEN) THEN
1310: CLOSE rbatch_cursor;
1311: END IF;

Line 1319: END CE_AUTO_BANK_CLEAR;

1315: */
1316: RAISE;
1317: END reconcile_process;
1318:
1319: END CE_AUTO_BANK_CLEAR;