[Home] [Help]
1: PACKAGE BODY CE_AUTO_BANK_IMPORT AS
2: /* $Header: ceabrimb.pls 120.22.12010000.5 2008/12/16 09:29:13 bkkashya ship $ */
3: l_DEBUG varchar2(1) := NVL(FND_PROFILE.value('CE_DEBUG'), 'N');
4: --l_DEBUG varchar2(1) := 'Y';
5:
150: ce_statement_lines_interface l
151: WHERE curr.currency_code(+) = l.currency_code
152: AND gt.user_conversion_type(+) = l.user_exchange_rate_type
153: AND ctc.trx_code(+) = l.trx_code
154: AND ctc.bank_account_id(+) = CE_AUTO_BANK_IMPORT.G_bank_account_id
155:
156: -- Code added for bug 7531187
157: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)
158: FROM ce_Transaction_Codes ctc2
155:
156: -- Code added for bug 7531187
157: AND nvl(ctc.Reconciliation_Sequence,1) = (SELECT nvl(min(ctc2.Reconciliation_Sequence),1)
158: FROM ce_Transaction_Codes ctc2
159: WHERE ctc2.Bank_Account_Id (+) =CE_AUTO_BANK_IMPORT.G_bank_account_id
160: AND ctc2.trx_Code (+) = l.trx_Code)
161: -- End of Code for bug 7531187
162:
163: AND l.statement_number = p_statement_number
189:
190: FUNCTION header_error (error_name VARCHAR2) RETURN BOOLEAN IS
191: BEGIN
192: IF l_DEBUG in ('Y', 'C') THEN
193: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
194: END IF;
195: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
196: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
197: IF l_DEBUG in ('Y', 'C') THEN
191: BEGIN
192: IF l_DEBUG in ('Y', 'C') THEN
193: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
194: END IF;
195: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
196: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
197: IF l_DEBUG in ('Y', 'C') THEN
198: cep_standard.debug('<
192: IF l_DEBUG in ('Y', 'C') THEN
193: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_error');
194: END IF;
195: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
196: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
197: IF l_DEBUG in ('Y', 'C') THEN
198: cep_standard.debug('<
200: RETURN TRUE;
194: END IF;
195: CE_HEADER_INTERFACE_ERRORS_PKG.insert_row(CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
196: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, error_name);
197: IF l_DEBUG in ('Y', 'C') THEN
198: cep_standard.debug('<
200: RETURN TRUE;
201: END header_error;
202:
210: FUNCTION line_error (line_number NUMBER, error_name VARCHAR2) RETURN BOOLEAN IS
211: x_rowid VARCHAR2(100);
212: BEGIN
213: IF l_DEBUG in ('Y', 'C') THEN
214: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');
215: END IF;
216: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
217: x_rowid,
218: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
214: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_error');
215: END IF;
216: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
217: x_rowid,
218: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
219: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
220: line_number,
221: error_name);
222: IF l_DEBUG in ('Y', 'C') THEN
215: END IF;
216: CE_LINE_INTERFACE_ERRORS_PKG.insert_row(
217: x_rowid,
218: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
219: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
220: line_number,
221: error_name);
222: IF l_DEBUG in ('Y', 'C') THEN
223: cep_standard.debug('<
219: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
220: line_number,
221: error_name);
222: IF l_DEBUG in ('Y', 'C') THEN
223: cep_standard.debug('<
225: RETURN TRUE;
226: END line_error;
227:
249: SELECT 1
250: INTO l_return
251: FROM CE_BANK_ACCT_BALANCES
252: WHERE BANK_ACCOUNT_ID = p_bank_account_id
253: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
254: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
255: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
256: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
257:
250: INTO l_return
251: FROM CE_BANK_ACCT_BALANCES
252: WHERE BANK_ACCOUNT_ID = p_bank_account_id
253: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
254: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
255: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
256: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
257:
258: return l_return;
251: FROM CE_BANK_ACCT_BALANCES
252: WHERE BANK_ACCOUNT_ID = p_bank_account_id
253: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
254: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
255: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
256: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
257:
258: return l_return;
259: EXCEPTION
252: WHERE BANK_ACCOUNT_ID = p_bank_account_id
253: AND BALANCE_DATE = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date)
254: AND NVL(LEDGER_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)
255: AND NVL(AVAILABLE_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,0)
256: AND NVL(VALUE_DATED_BALANCE,0) = NVL(CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,0);
257:
258: return l_return;
259: EXCEPTION
260: WHEN OTHERS THEN
277: bu_error_found boolean;
278:
279: BEGIN
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
282: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
283: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
284: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
285: END IF;
278:
279: BEGIN
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
282: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
283: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
284: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
285: END IF;
286:
279: BEGIN
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
282: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
283: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
284: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
285: END IF;
286:
287: XTR_WRAPPER_API_P.bank_account_verification(
280: IF l_DEBUG in ('Y', 'C') THEN
281: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.xtr_shared_account'||
282: 'P_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID ||
283: ', G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id||
284: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
285: END IF;
286:
287: XTR_WRAPPER_API_P.bank_account_verification(
288: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
284: ' G_cshi_currency_code = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
285: END IF;
286:
287: XTR_WRAPPER_API_P.bank_account_verification(
288: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
289: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
290: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
291: P_RESULT => X_RESULT,
292: P_ERROR_MSG => X_ERROR_MSG);
285: END IF;
286:
287: XTR_WRAPPER_API_P.bank_account_verification(
288: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
289: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
290: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
291: P_RESULT => X_RESULT,
292: P_ERROR_MSG => X_ERROR_MSG);
293:
286:
287: XTR_WRAPPER_API_P.bank_account_verification(
288: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
289: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
290: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
291: P_RESULT => X_RESULT,
292: P_ERROR_MSG => X_ERROR_MSG);
293:
294: X_ACCOUNT_RESULT := X_RESULT;
300:
301: if (x_account_result = 'XTR1_NOT_SETUP' ) then
302: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);
303: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
304: bu_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_XTR_ACCT_NOT_SETUP');
305: update_header_status('E');
306: end if;
307:
308: IF l_DEBUG in ('Y', 'C') THEN
305: update_header_status('E');
306: end if;
307:
308: IF l_DEBUG in ('Y', 'C') THEN
309: cep_standard.debug('<
311:
312: EXCEPTION
313: WHEN OTHERS THEN
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: IF l_DEBUG in ('Y', 'C') THEN
315: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.xtr_shared_account');
316: END IF;
317: RAISE;
318: END xtr_shared_account;
319:
330: bu_error_found boolean;
331: set_warning boolean;
332: BEGIN
333: IF l_DEBUG in ('Y', 'C') THEN
334: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
331: set_warning boolean;
332: BEGIN
333: IF l_DEBUG in ('Y', 'C') THEN
334: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
332: BEGIN
333: IF l_DEBUG in ('Y', 'C') THEN
334: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
333: IF l_DEBUG in ('Y', 'C') THEN
334: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
334: cep_standard.debug('>> CE_AUTO_BANK_IMPORT.transfer_bank_balances');
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
335: cep_standard.debug('transfer_bank_balances G_CSHI_ORG_ID = '|| CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
336: cep_standard.debug('transfer_bank_balances G_BANK_ACCOUNT_ID = '|| CE_AUTO_BANK_IMPORT.G_bank_account_id);
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
344: END IF;
337: cep_standard.debug('transfer_bank_balances G_CSHI_CURRENCY_CODE = '|| CE_AUTO_BANK_IMPORT.G_cshi_currency_code);
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
344: END IF;
345:
338: cep_standard.debug('transfer_bank_balances G_CSHI_STATEMENT_DATE = '|| CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
344: END IF;
345:
346: bu_error_found := FALSE;
339: cep_standard.debug('transfer_bank_balances G_CSHI_CONTROL_END_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance);
340: cep_standard.debug('transfer_bank_balances G_CSHI_CASHFLOW_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance);
341: cep_standard.debug('transfer_bank_balances G_CSHI_INT_CALC_BALANCE = '|| CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance);
342: cep_standard.debug('transfer_bank_balances G_CSHI_ONE_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_one_day_float);
343: cep_standard.debug('transfer_bank_balances G_CSHI_TWO_DAY_FLOAT = '|| CE_AUTO_BANK_IMPORT.G_cshi_two_day_float);
344: END IF;
345:
346: bu_error_found := FALSE;
347:
347:
348:
349:
350: XTR_WRAPPER_API_P.bank_balance_upload(
351: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
348:
349:
350: XTR_WRAPPER_API_P.bank_balance_upload(
351: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
349:
350: XTR_WRAPPER_API_P.bank_balance_upload(
351: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
350: XTR_WRAPPER_API_P.bank_balance_upload(
351: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
351: P_ORG_ID => CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID, --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
352: P_CE_BANK_ACCOUNT_ID => CE_AUTO_BANK_IMPORT.G_bank_account_id,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
360: P_RESULT => X_RESULT,
353: P_CURRENCY_CODE => CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
360: P_RESULT => X_RESULT,
361: P_ERROR_MSG => X_ERROR_MSG);
354: P_BALANCE_DATE => CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
360: P_RESULT => X_RESULT,
361: P_ERROR_MSG => X_ERROR_MSG);
362: IF l_DEBUG in ('Y', 'C') THEN
355: P_BALANCE_AMOUNT_A => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
356: P_BALANCE_AMOUNT_B => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
357: P_BALANCE_AMOUNT_C => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
358: P_ONE_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
359: P_TWO_DAY_FLOAT => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
360: P_RESULT => X_RESULT,
361: P_ERROR_MSG => X_ERROR_MSG);
362: IF l_DEBUG in ('Y', 'C') THEN
363: cep_standard.debug('transfer_bank_balances x_result = '|| x_result);
371: return TRUE;
372: else /* do not import */
373: FND_FILE.put_line(FND_FILE.LOG, X_ERROR_MSG);
374: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
375: bu_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_BU_FAILED');
376: update_header_status('E');
377: return FALSE;
378: end if;
379: IF l_DEBUG in ('Y', 'C') THEN
376: update_header_status('E');
377: return FALSE;
378: end if;
379: IF l_DEBUG in ('Y', 'C') THEN
380: cep_standard.debug('<
382: EXCEPTION
383: WHEN OTHERS THEN
384: IF l_DEBUG in ('Y', 'C') THEN
381: END IF;
382: EXCEPTION
383: WHEN OTHERS THEN
384: IF l_DEBUG in ('Y', 'C') THEN
385: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_bank_balances');
386: END IF;
387: RAISE;
388: END transfer_bank_balances;
389:
400: -----------------------------------------------------------------------*/
401: PROCEDURE purge_data IS
402: BEGIN
403: IF l_DEBUG in ('Y', 'C') THEN
404: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
405: END IF;
406: DELETE FROM ce_statement_headers_int sh
407: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
408:
403: IF l_DEBUG in ('Y', 'C') THEN
404: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.purge_data');
405: END IF;
406: DELETE FROM ce_statement_headers_int sh
407: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
408:
409: DELETE FROM ce_statement_lines_interface sl
410: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
411: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
406: DELETE FROM ce_statement_headers_int sh
407: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
408:
409: DELETE FROM ce_statement_lines_interface sl
410: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
411: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
412: IF l_DEBUG in ('Y', 'C') THEN
413: cep_standard.debug('<
407: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
408:
409: DELETE FROM ce_statement_lines_interface sl
410: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
411: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
412: IF l_DEBUG in ('Y', 'C') THEN
413: cep_standard.debug('<
415: EXCEPTION
409: DELETE FROM ce_statement_lines_interface sl
410: WHERE sl.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
411: AND sl.statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number;
412: IF l_DEBUG in ('Y', 'C') THEN
413: cep_standard.debug('<
415: EXCEPTION
416: WHEN others THEN
417: IF l_DEBUG in ('Y', 'C') THEN
414: END IF;
415: EXCEPTION
416: WHEN others THEN
417: IF l_DEBUG in ('Y', 'C') THEN
418: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.purge_data' );
419: RAISE;
420: END IF;
421: END purge_data;
422:
432: --------------------------------------------------------------------- */
433: PROCEDURE archive_lines IS
434: BEGIN
435: IF l_DEBUG in ('Y', 'C') THEN
436: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_lines');
437: END IF;
438: INSERT INTO ce_arch_interface_lines
439: (bank_account_num,
440: statement_number,
512: attribute13,
513: attribute14,
514: attribute15
515: FROM ce_statement_lines_interface
516: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
517: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
518: IF l_DEBUG in ('Y', 'C') THEN
519: cep_standard.debug('<
513: attribute14,
514: attribute15
515: FROM ce_statement_lines_interface
516: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
517: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
518: IF l_DEBUG in ('Y', 'C') THEN
519: cep_standard.debug('<
521: EXCEPTION
515: FROM ce_statement_lines_interface
516: WHERE statement_number = CE_AUTO_BANK_IMPORT.G_cshi_statement_number
517: AND bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num;
518: IF l_DEBUG in ('Y', 'C') THEN
519: cep_standard.debug('<
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF l_DEBUG in ('Y', 'C') THEN
520: END IF;
521: EXCEPTION
522: WHEN OTHERS THEN
523: IF l_DEBUG in ('Y', 'C') THEN
524: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_lines');
525: END IF;
526: RAISE;
527: END archive_lines;
528:
538: ---------------------------------------------------------------------- */
539: PROCEDURE archive_header IS
540: BEGIN
541: IF l_DEBUG in ('Y', 'C') THEN
542: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.archive_header');
543: END IF;
544: INSERT INTO ce_arch_interface_headers
545: (statement_number,
546: bank_account_num,
632: last_updated_by,
633: last_update_date
634: --org_id
635: FROM ce_statement_headers_int
636: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
637: IF l_DEBUG in ('Y', 'C') THEN
638: cep_standard.debug('<
640: EXCEPTION
634: --org_id
635: FROM ce_statement_headers_int
636: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
637: IF l_DEBUG in ('Y', 'C') THEN
638: cep_standard.debug('<
640: EXCEPTION
641: WHEN OTHERS THEN
642: IF l_DEBUG in ('Y', 'C') THEN
639: END IF;
640: EXCEPTION
641: WHEN OTHERS THEN
642: IF l_DEBUG in ('Y', 'C') THEN
643: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.archive_header');
644: END IF;
645: RAISE;
646: END archive_header;
647:
665: seq_value IN OUT NOCOPY NUMBER) RETURN BOOLEAN IS
666: l_return_code NUMBER;
667: BEGIN
668: IF l_DEBUG in ('Y', 'C') THEN
669: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );
670: END IF;
671: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN
672: --
673: -- bug# 1062247
682: seq_id,
683: 'N', 'N');
684:
685: IF l_DEBUG in ('Y', 'C') THEN
686: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
687: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
688: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
689: END IF;
690: END IF;
683: 'N', 'N');
684:
685: IF l_DEBUG in ('Y', 'C') THEN
686: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
687: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
688: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
689: END IF;
690: END IF;
691: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
684:
685: IF l_DEBUG in ('Y', 'C') THEN
686: cep_standard.debug('get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.dbseqname: '|| seq_name || '----------' ||
687: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.seq_id: '|| TO_CHAR( seq_id ) || '----------' ||
688: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
689: END IF;
690: END IF;
691: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
692: AND (CE_AUTO_BANK_REC.G_sequence_numbering = 'A' )) THEN
694: ELSE
695: RETURN TRUE;
696: END IF;
697: IF l_DEBUG in ('Y', 'C') THEN
698: cep_standard.debug('<
700: EXCEPTION
701: WHEN OTHERS THEN
702: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN
719: FUNCTION lock_statement RETURN BOOLEAN IS
720: X_statement_number CE_STATEMENT_HEADERS_INT.statement_number%TYPE;
721: BEGIN
722: IF l_DEBUG in ('Y', 'C') THEN
723: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement');
724: END IF;
725: SELECT statement_number
726: INTO X_statement_number
727: FROM ce_statement_headers_int
724: END IF;
725: SELECT statement_number
726: INTO X_statement_number
727: FROM ce_statement_headers_int
728: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
729: FOR UPDATE OF statement_number NOWAIT;
730:
731: IF l_DEBUG in ('Y', 'C') THEN
732: cep_standard.debug('<
728: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid
729: FOR UPDATE OF statement_number NOWAIT;
730:
731: IF l_DEBUG in ('Y', 'C') THEN
732: cep_standard.debug('<
734: RETURN(TRUE);
735: EXCEPTION
736: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
734: RETURN(TRUE);
735: EXCEPTION
736: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
737: IF l_DEBUG in ('Y', 'C') THEN
738: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement STATEMENT LOCKED');
739: END IF;
740: return(FALSE);
741: WHEN OTHERS THEN
742: IF l_DEBUG in ('Y', 'C') THEN
739: END IF;
740: return(FALSE);
741: WHEN OTHERS THEN
742: IF l_DEBUG in ('Y', 'C') THEN
743: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement');
744: END IF;
745: RAISE;
746: return(FALSE);
747: END lock_statement;
759: FUNCTION lock_statement_line(csli_rowid IN VARCHAR2) RETURN BOOLEAN IS
760: csli_amount CE_STATEMENT_LINES.amount%TYPE;
761: BEGIN
762: IF l_DEBUG in ('Y', 'C') THEN
763: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.lock_statement_line');
764: END IF;
765: SELECT amount
766: INTO csli_amount
767: FROM ce_statement_lines_interface
767: FROM ce_statement_lines_interface
768: WHERE rowid = csli_rowid
769: FOR UPDATE OF bank_account_num NOWAIT;
770: IF l_DEBUG in ('Y', 'C') THEN
771: cep_standard.debug('<
773: RETURN(TRUE);
774: EXCEPTION
775: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
773: RETURN(TRUE);
774: EXCEPTION
775: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
776: IF l_DEBUG in ('Y', 'C') THEN
777: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line STATEMENT LOCKED');
778: END IF;
779: return(FALSE);
780: WHEN OTHERS THEN
781: IF l_DEBUG in ('Y', 'C') THEN
778: END IF;
779: return(FALSE);
780: WHEN OTHERS THEN
781: IF l_DEBUG in ('Y', 'C') THEN
782: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.lock_statement_line');
783: END IF;
784: RAISE;
785: return(FALSE);
786: END lock_statement_line;
807: curr_relation VARCHAR2(30);
808:
809: BEGIN
810: IF l_DEBUG in ('Y', 'C') THEN
811: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
812: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
813: END IF;
814:
815: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
947: attribute13,
948: attribute14,
949: attribute15)
950: SELECT ce_statement_lines_s.nextval,
951: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
952: csli.line_number,
953: csli.trx_date,
954: (select distinct ctc.trx_type
955: from ce_transaction_codes ctc
1008: --AND ctc.trx_code(+) = csli.trx_code
1009: --AND NVL(ctc.bank_account_id,aba.bank_account_id) =
1010: -- aba.bank_account_id
1011: AND csli.statement_number =
1012: CE_AUTO_BANK_IMPORT.G_cshi_statement_number
1013: AND csli.bank_account_num = aba.bank_account_num
1014: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1015: END IF;
1016: END IF;
1010: -- aba.bank_account_id
1011: AND csli.statement_number =
1012: CE_AUTO_BANK_IMPORT.G_cshi_statement_number
1013: AND csli.bank_account_num = aba.bank_account_num
1014: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1015: END IF;
1016: END IF;
1017: IF l_DEBUG in ('Y', 'C') THEN
1018: cep_standard.debug('<
1014: AND aba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1015: END IF;
1016: END IF;
1017: IF l_DEBUG in ('Y', 'C') THEN
1018: cep_standard.debug('<
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF l_DEBUG in ('Y', 'C') THEN
1019: END IF;
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: IF l_DEBUG in ('Y', 'C') THEN
1023: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_lines');
1024: END IF;
1025: RAISE;
1026: END transfer_lines;
1027:
1054: X_bank_acct_balance_id NUMBER;
1055:
1056: BEGIN
1057: IF l_DEBUG in ('Y', 'C') THEN
1058: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1059: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1060: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1061: END IF;
1062: --
1055:
1056: BEGIN
1057: IF l_DEBUG in ('Y', 'C') THEN
1058: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1059: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1060: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1061: END IF;
1062: --
1063: -- Call the AOL sequence numbering routine to get Seq. number
1056: BEGIN
1057: IF l_DEBUG in ('Y', 'C') THEN
1058: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_header '||
1059: ' CE_AUTO_BANK_IMPORT.aba_bank_account_id : '|| aba_bank_account_id||
1060: ', CE_AUTO_BANK_IMPORT.aba_bank_account_name : '|| aba_bank_account_name);
1061: END IF;
1062: --
1063: -- Call the AOL sequence numbering routine to get Seq. number
1064: --
1061: END IF;
1062: --
1063: -- Call the AOL sequence numbering routine to get Seq. number
1064: --
1065: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1066: aba_bank_account_name,
1067: CE_AUTO_BANK_REC.G_set_of_books_id,
1068: 'A',
1069: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1065: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1066: aba_bank_account_name,
1067: CE_AUTO_BANK_REC.G_set_of_books_id,
1068: 'A',
1069: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1070: l_dbseqname,
1071: l_doc_seq_id,
1072: l_doc_seq_value );
1073:
1078: IF l_DEBUG in ('Y', 'C') THEN
1079: cep_standard.debug('transfer_header not l_valid_seq ');
1080: END IF;
1081:
1082: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1083: update_header_status('E');
1084: return FALSE;
1085: ELSE
1086: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1082: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1083: update_header_status('E');
1084: return FALSE;
1085: ELSE
1086: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1087: IF l_DEBUG in ('Y', 'C') THEN
1088: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1089: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1090: END IF;
1196: ELSIF ( nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1197:
1198: --check if statement date is less than sysdate
1199: -- cannot import statements with date greater than or equal to sysdate
1200: if (trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date) >= trunc(sysdate)) then
1201: l_dup_balance:= CE_AUTO_BANK_IMPORT.header_error('CE_LOD_STATEMENT_DATE');
1202: RETURN FALSE;
1203: end if;
1204:
1197:
1198: --check if statement date is less than sysdate
1199: -- cannot import statements with date greater than or equal to sysdate
1200: if (trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date) >= trunc(sysdate)) then
1201: l_dup_balance:= CE_AUTO_BANK_IMPORT.header_error('CE_LOD_STATEMENT_DATE');
1202: RETURN FALSE;
1203: end if;
1204:
1205: select count(1)
1205: select count(1)
1206: into x_bal_count
1207: from ce_bank_acct_balances
1208: where bank_account_id = aba_bank_account_id
1209: and balance_date = trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date);
1210:
1211: IF x_bal_count > 0 THEN
1212: x_flag:='YI'; --balance already exist when inserting through loader
1213: --check if all the balance values are same, if yes then no log message required
1211: IF x_bal_count > 0 THEN
1212: x_flag:='YI'; --balance already exist when inserting through loader
1213: --check if all the balance values are same, if yes then no log message required
1214: if ( check_balance_values(aba_bank_account_id)=0)then
1215: l_dup_balance:=CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BALANCE');
1216: end if;
1217: ELSE
1218: x_flag:='N';
1219: END IF;
1222: -- flag would be null.
1223: IF ( NVL(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
1224: CE_STAT_HDRS_DML_PKG.insert_row (
1225: X_rowid => x_temp_rowid,
1226: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1227: X_bank_account_id => aba_bank_account_id,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1224: CE_STAT_HDRS_DML_PKG.insert_row (
1225: X_rowid => x_temp_rowid,
1226: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1227: X_bank_account_id => aba_bank_account_id,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1225: X_rowid => x_temp_rowid,
1226: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1227: X_bank_account_id => aba_bank_account_id,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1226: X_statement_header_id => CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id,
1227: X_bank_account_id => aba_bank_account_id,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1227: X_bank_account_id => aba_bank_account_id,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1228: X_statement_number => CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1229: X_statement_date => trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1230: X_check_digits => CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1231: X_control_begin_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1232: X_control_end_balance => CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1240: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1233: X_cashflow_balance => CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1240: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1241: X_doc_sequence_id => l_doc_seq_id,
1234: X_int_calc_balance => CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1240: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1241: X_doc_sequence_id => l_doc_seq_id,
1242: X_doc_sequence_value => l_doc_seq_value,
1235: X_one_day_float => CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1240: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1241: X_doc_sequence_id => l_doc_seq_id,
1242: X_doc_sequence_value => l_doc_seq_value,
1243: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1236: X_two_day_float => CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1237: X_control_total_dr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1238: X_control_total_cr => CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1239: X_control_dr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1240: X_control_cr_line_count => CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1241: X_doc_sequence_id => l_doc_seq_id,
1242: X_doc_sequence_value => l_doc_seq_value,
1243: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1244: X_creation_date => sysdate,
1243: X_created_by => NVL(FND_GLOBAL.user_id,-1),
1244: X_creation_date => sysdate,
1245: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1246: X_last_update_date => sysdate,
1247: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1244: X_creation_date => sysdate,
1245: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1246: X_last_update_date => sysdate,
1247: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1245: X_last_updated_by => NVL(FND_GLOBAL.user_id,-1),
1246: X_last_update_date => sysdate,
1247: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1246: X_last_update_date => sysdate,
1247: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1247: X_attribute_category => CE_AUTO_BANK_IMPORT.G_cshi_attribute_category ,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1248: X_attribute1 => CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1249: X_attribute2 => CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1250: X_attribute3 => CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1251: X_attribute4 => CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1252: X_attribute5 => CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1253: X_attribute6 => CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1254: X_attribute7 => CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1255: X_attribute8 => CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1263: X_auto_loaded_flag => 'Y',
1256: X_attribute9 => CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1263: X_auto_loaded_flag => 'Y',
1264: X_statement_complete_flag => 'N',
1257: X_attribute10 => CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1263: X_auto_loaded_flag => 'Y',
1264: X_statement_complete_flag => 'N',
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1258: X_attribute11 => CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1259: X_attribute12 => CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1260: X_attribute13 => CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1263: X_auto_loaded_flag => 'Y',
1264: X_statement_complete_flag => 'N',
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1266: X_balance_flag => x_flag,
1263: X_auto_loaded_flag => 'Y',
1264: X_statement_complete_flag => 'N',
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1266: X_balance_flag => x_flag,
1267: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1268: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1269: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1270: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1271: -- 5916290 : GDF Changes
1264: X_statement_complete_flag => 'N',
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1266: X_balance_flag => x_flag,
1267: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1268: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1269: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1270: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1271: -- 5916290 : GDF Changes
1272: X_bank_acct_balance_id => NULL,
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1266: X_balance_flag => x_flag,
1267: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1268: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1269: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1270: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1271: -- 5916290 : GDF Changes
1272: X_bank_acct_balance_id => NULL,
1273: X_global_att_category => NULL,
1266: X_balance_flag => x_flag,
1267: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1268: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1269: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1270: X_average_close_available_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1271: -- 5916290 : GDF Changes
1272: X_bank_acct_balance_id => NULL,
1273: X_global_att_category => NULL,
1274: X_global_attribute1 => NULL,
1318: object_version_number)
1319: values
1320: (X_bank_acct_balance_id,
1321: aba_bank_account_id,
1322: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1319: values
1320: (X_bank_acct_balance_id,
1321: aba_bank_account_id,
1322: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1320: (X_bank_acct_balance_id,
1321: aba_bank_account_id,
1322: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1321: aba_bank_account_id,
1322: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1322: trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date),
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1323: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1331: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1324: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1331: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1332: sysdate,
1325: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1331: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1332: sysdate,
1333: NVL(FND_GLOBAL.user_id,-1),
1326: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1331: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1332: sysdate,
1333: NVL(FND_GLOBAL.user_id,-1),
1334: sysdate,
1327: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1328: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1329: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1330: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1331: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1332: sysdate,
1333: NVL(FND_GLOBAL.user_id,-1),
1334: sysdate,
1335: NVL(FND_GLOBAL.user_id,-1),
1346: RETURN FALSE;
1347: END IF;
1348: END IF;
1349: IF l_DEBUG in ('Y', 'C') THEN
1350: cep_standard.debug('<
1352: EXCEPTION
1353: WHEN APP_EXCEPTION.application_exception THEN
1354: IF l_DEBUG in ('Y', 'C') THEN
1351: END IF;
1352: EXCEPTION
1353: WHEN APP_EXCEPTION.application_exception THEN
1354: IF l_DEBUG in ('Y', 'C') THEN
1355: cep_standard.debug('EXCEPTION:CE_AUTO_BANK_IMPORT.transfer_header-APP_EXCEPTION');
1356: END IF;
1357: l_encoded_message := FND_MESSAGE.GET_ENCODED;
1358: IF (l_encoded_message IS NOT NULL) THEN
1359: FND_MESSAGE.parse_encoded(l_encoded_message,l_app_short_name,l_message_name);
1362: cep_standard.debug('transfer_header: ' || 'No messages on stack');
1363: END IF;
1364: l_message_name := 'OTHER_APP_ERROR';
1365: END IF;
1366: l_valid_seq := CE_AUTO_BANK_IMPORT.header_error('CE_DOC_SEQUENCE_HEADER_ERR');
1367: update_header_status('E');
1368: return FALSE;
1369: WHEN OTHERS THEN
1370: IF l_DEBUG in ('Y', 'C') THEN
1367: update_header_status('E');
1368: return FALSE;
1369: WHEN OTHERS THEN
1370: IF l_DEBUG in ('Y', 'C') THEN
1371: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.transfer_header');
1372: END IF;
1373: RAISE;
1374: END transfer_header;
1375:
1392: --------------------------------------------------------------------- */
1393: PROCEDURE update_header_status(p_status VARCHAR2) IS
1394: BEGIN
1395: IF l_DEBUG in ('Y', 'C') THEN
1396: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1397: END IF;
1398: UPDATE ce_statement_headers_int
1399: SET record_status_flag = p_status
1400: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1396: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.update_header_status');
1397: END IF;
1398: UPDATE ce_statement_headers_int
1399: SET record_status_flag = p_status
1400: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1401: IF l_DEBUG in ('Y', 'C') THEN
1402: cep_standard.debug('<
1404: EXCEPTION
1398: UPDATE ce_statement_headers_int
1399: SET record_status_flag = p_status
1400: WHERE rowid = CE_AUTO_BANK_IMPORT.G_cshi_rowid;
1401: IF l_DEBUG in ('Y', 'C') THEN
1402: cep_standard.debug('<
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: IF l_DEBUG in ('Y', 'C') THEN
1403: END IF;
1404: EXCEPTION
1405: WHEN OTHERS THEN
1406: IF l_DEBUG in ('Y', 'C') THEN
1407: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.update_header_status');
1408: END IF;
1409: RAISE;
1410: END update_header_status;
1411:
1427: FUNCTION validate_control_totals RETURN BOOLEAN IS
1428: error_found BOOLEAN;
1429: BEGIN
1430: IF l_DEBUG in ('Y', 'C') THEN
1431: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1432: END IF;
1433: error_found := FALSE;
1434: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1435: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1430: IF l_DEBUG in ('Y', 'C') THEN
1431: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1432: END IF;
1433: error_found := FALSE;
1434: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1435: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1436: END IF;
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1431: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_control_totals');
1432: END IF;
1433: error_found := FALSE;
1434: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1435: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1436: END IF;
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1439: END IF;
1433: error_found := FALSE;
1434: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1435: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1436: END IF;
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1439: END IF;
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1434: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,CE_AUTO_BANK_IMPORT.G_dr_sum) <> CE_AUTO_BANK_IMPORT.G_dr_sum) THEN
1435: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_DR_TOTAL');
1436: END IF;
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1439: END IF;
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1442: END IF;
1436: END IF;
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1439: END IF;
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1442: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1437: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,CE_AUTO_BANK_IMPORT.G_cr_sum) <> CE_AUTO_BANK_IMPORT.G_cr_sum) THEN
1438: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_CR_TOTAL');
1439: END IF;
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1442: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1439: END IF;
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1442: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1440: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,CE_AUTO_BANK_IMPORT.G_dr_count) <> CE_AUTO_BANK_IMPORT.G_dr_count) THEN
1441: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DR_LINE_COUNT');
1442: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1442: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1443: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,CE_AUTO_BANK_IMPORT.G_cr_count) <> CE_AUTO_BANK_IMPORT.G_cr_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1444: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CR_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1452: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1445: END IF;
1446: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,0) -
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1452: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1453: END IF;
1447: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,0) +
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1452: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1453: END IF;
1454: IF l_DEBUG in ('Y', 'C') THEN
1455: cep_standard.debug('<
1448: NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,0) <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,0)) THEN
1449: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CTRL_END_BALANCE');
1450: END IF;
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1452: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1453: END IF;
1454: IF l_DEBUG in ('Y', 'C') THEN
1455: cep_standard.debug('<
1451: IF (NVL(CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,CE_AUTO_BANK_IMPORT.G_total_count) <> CE_AUTO_BANK_IMPORT.G_total_count) THEN
1452: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_LINE_COUNT');
1453: END IF;
1454: IF l_DEBUG in ('Y', 'C') THEN
1455: cep_standard.debug('<
1457: return error_found;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1456: END IF;
1457: return error_found;
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.validate_control_totals');
1461: RAISE;
1462: END validate_control_totals;
1463:
1464: /* ---------------------------------------------------------------------
1474: trx_code_count NUMBER;
1475: aba_bank_account_id NUMBER;
1476: BEGIN
1477: IF l_DEBUG in ('Y', 'C') THEN
1478: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.validate_bank_account');
1479: END IF;
1480: --
1481: -- Bank and bank branch name validations
1482: -- NOTE: We just check for the 'INTERNAL' accounts
1487: INTO aba_bank_account_id
1488: FROM ap_bank_branches abb,
1489: ap_bank_accounts aba
1490: WHERE aba.bank_branch_id = abb.bank_branch_id
1491: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1492: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1493: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1494: AND aba.account_type = 'INTERNAL';
1495: */
1488: FROM ap_bank_branches abb,
1489: ap_bank_accounts aba
1490: WHERE aba.bank_branch_id = abb.bank_branch_id
1491: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1492: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1493: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1494: AND aba.account_type = 'INTERNAL';
1495: */
1496: --
1489: ap_bank_accounts aba
1490: WHERE aba.bank_branch_id = abb.bank_branch_id
1491: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1492: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1493: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1494: AND aba.account_type = 'INTERNAL';
1495: */
1496: --
1497: -- Check for existence of the Transaction codes
1499: --
1500: SELECT count(*)
1501: INTO trx_code_count
1502: FROM ce_transaction_codes
1503: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1504: IF (trx_code_count = 0) THEN
1505: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1506: END IF;
1507: --
1501: INTO trx_code_count
1502: FROM ce_transaction_codes
1503: WHERE bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id;
1504: IF (trx_code_count = 0) THEN
1505: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_NO_TRX_CODES');
1506: END IF;
1507: --
1508: -- Bank account currency code validation
1509: --
1506: END IF;
1507: --
1508: -- Bank account currency code validation
1509: --
1510: IF (aba_bank_currency <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_currency_code,aba_bank_currency)) THEN
1511: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1512: END IF;
1513: --
1514: -- Check digits validation -- bug 7214921
1507: --
1508: -- Bank account currency code validation
1509: --
1510: IF (aba_bank_currency <> NVL(CE_AUTO_BANK_IMPORT.G_cshi_currency_code,aba_bank_currency)) THEN
1511: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1512: END IF;
1513: --
1514: -- Check digits validation -- bug 7214921
1515: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1511: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_FOREIGN_CURRENCY');
1512: END IF;
1513: --
1514: -- Check digits validation -- bug 7214921
1515: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1516: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1517: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1518: END IF;
1519: End If ;
1512: END IF;
1513: --
1514: -- Check digits validation -- bug 7214921
1515: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1516: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1517: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1518: END IF;
1519: End If ;
1520:
1513: --
1514: -- Check digits validation -- bug 7214921
1515: If CE_AUTO_BANK_IMPORT.G_cshi_check_digits is not null and aba_bank_check_digits is not null Then
1516: IF ( CE_AUTO_BANK_IMPORT.G_cshi_check_digits <> aba_bank_check_digits ) THEN
1517: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_CHECK_DIGITS');
1518: END IF;
1519: End If ;
1520:
1521: IF l_DEBUG in ('Y', 'C') THEN
1518: END IF;
1519: End If ;
1520:
1521: IF l_DEBUG in ('Y', 'C') THEN
1522: cep_standard.debug('<
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: IF (SQL%NOTFOUND) THEN
1523: END IF;
1524: EXCEPTION
1525: WHEN OTHERS THEN
1526: IF (SQL%NOTFOUND) THEN
1527: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_BANK');
1528: IF l_DEBUG in ('Y', 'C') THEN
1529: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');
1530: END IF;
1531: ELSIF (SQL%ROWCOUNT > 0) THEN
1528: IF l_DEBUG in ('Y', 'C') THEN
1529: cep_standard.debug('validate_bank_account: ' || 'error: BANK NOT FOUND');
1530: END IF;
1531: ELSIF (SQL%ROWCOUNT > 0) THEN
1532: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_DUP_BANK');
1533: IF l_DEBUG in ('Y', 'C') THEN
1534: cep_standard.debug('validate_bank_account: ' || 'error: DUPLICATE BANK');
1535: END IF;
1536: ELSE
1568: error_found BOOLEAN;
1569: account_type VARCHAR2(25);
1570: BEGIN
1571: IF l_DEBUG in ('Y', 'C') THEN
1572: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.header_validation');
1573: END IF;
1574: error_found := FALSE;
1575: bank_error := FALSE;
1576: duplicate_found := FALSE;
1582: INTO account_type
1583: FROM ce_bank_branches_v abb,
1584: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1585: WHERE aba.bank_branch_id = abb.branch_party_id
1586: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1587: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1588: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1589: AND aba.bank_account_id = aba_bank_account_id;
1590: */
1583: FROM ce_bank_branches_v abb,
1584: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1585: WHERE aba.bank_branch_id = abb.branch_party_id
1586: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1587: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1588: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1589: AND aba.bank_account_id = aba_bank_account_id;
1590: */
1591: --
1584: ce_bank_accts_gt_v aba --ce_bank_accounts_v aba
1585: WHERE aba.bank_branch_id = abb.branch_party_id
1586: AND abb.bank_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_name, abb.bank_name)
1587: AND abb.bank_branch_name = nvl(CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,abb.bank_branch_name)
1588: AND aba.bank_account_num = CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num
1589: AND aba.bank_account_id = aba_bank_account_id;
1590: */
1591: --
1592: -- 1. Bank account
1599: -- If the bank account is also used for xtr or payroll, do not check GL DATE
1600:
1601: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1602: --IF (account_type <> 'PAYROLL') THEN
1603: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1604: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1605: gl_date_found :=
1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)
1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));
1600:
1601: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1602: --IF (account_type <> 'PAYROLL') THEN
1603: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1604: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1605: gl_date_found :=
1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)
1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));
1608: IF (NOT gl_date_found) THEN
1605: gl_date_found :=
1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)
1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));
1608: IF (NOT gl_date_found) THEN
1609: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1610: END IF;
1611: END IF;
1612: END IF;
1613: --
1614: -- 3. Already existing in the CE_STATEMENT_HEADERS
1615: --
1616: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1617: IF (r_statement_number IS NOT NULL) THEN
1618: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');
1619: END IF;
1620: END IF;
1621:
1622: IF (bank_error) THEN
1628: END IF;
1629: END IF;
1630:
1631: IF l_DEBUG in ('Y', 'C') THEN
1632: cep_standard.debug('<
1634: RETURN error_found;
1635: EXCEPTION
1636: WHEN OTHERS THEN
1634: RETURN error_found;
1635: EXCEPTION
1636: WHEN OTHERS THEN
1637: IF l_DEBUG in ('Y', 'C') THEN
1638: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.header_validation');
1639: END IF;
1640: RAISE;
1641: RETURN FALSE;
1642: END header_validation;
1674: fixed_rate_yn VARCHAR2(30);
1675:
1676: BEGIN
1677: IF l_DEBUG in ('Y', 'C') THEN
1678: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.line_validation');
1679: END IF;
1680: error_found := FALSE;
1681: --
1682: -- 1. Line Amount
1681: --
1682: -- 1. Line Amount
1683: --
1684: IF (csli_amount IS NULL) THEN
1685: error_found := CE_AUTO_BANK_IMPORT.line_error(csli_line_number, 'CE_NO_AMOUNT');
1686: END IF;
1687:
1688: --
1689: -- 2. Trx Code
1691: -- Null csli_trx_code indicates that the statement interface line is missing
1692: -- a transaction code.
1693: --
1694: IF (csli_trx_code IS NULL) THEN
1695: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_MISSING_TRX_NUM');
1696:
1697: --
1698: -- Non-Null csli_trx_code and null r_trx_code_id indicate transaction code is not
1699: -- defined for the bank.
1701: -- bug 4435028 BAT, we cannot do this validation because there are multiple rows with same trx_code
1702:
1703: --7194081 Uncommented.
1704: ELSIF (r_trx_code_id IS NULL) THEN
1705: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM');
1706:
1707: --
1708: -- Check effective date of this transaction code.
1709: -- defined for the bank.
1710: --
1711: -- bug 4435028 BAT, we cannot do this validation because there are multiple rows with same trx_code
1712: -- cannot get start_date and end_date
1713:
1714: --ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1715: -- r_start_date AND r_end_date) THEN
1716: -- NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1717: -- NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1718:
1712: -- cannot get start_date and end_date
1713:
1714: --ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1715: -- r_start_date AND r_end_date) THEN
1716: -- NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1717: -- NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1718:
1719: -- error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1720:
1713:
1714: --ELSIF ( CE_AUTO_BANK_IMPORT.G_cshi_statement_date NOT BETWEEN
1715: -- r_start_date AND r_end_date) THEN
1716: -- NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1717: -- NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1718:
1719: -- error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1720:
1721: END IF;
1715: -- r_start_date AND r_end_date) THEN
1716: -- NVL(r_start_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date) AND
1717: -- NVL(r_end_date, CE_AUTO_BANK_IMPORT.G_cshi_statement_date)) THEN
1718:
1719: -- error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_TRX_NUM_DATE');
1720:
1721: END IF;
1722:
1723: --
1723: --
1724: -- 3.Exchange rate type
1725: --
1726: IF (csli_user_exchange_rate_type IS NOT NULL AND r_user_conversion_type IS NULL) THEN
1727: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_EXCHANGE_TYPE');
1728: END IF;
1729:
1730: --
1731: -- 4. Currency code
1730: --
1731: -- 4. Currency code
1732: --
1733: IF (csli_currency_code IS NOT NULL AND r_currency_code IS NULL) THEN
1734: error_found := CE_AUTO_BANK_IMPORT.line_error( csli_line_number, 'CE_INVALID_CURRENCY');
1735: END IF;
1736:
1737: --
1738: -- 5. EMU Fixed type is only for valid curr and xdate
1757: CE_AUTO_BANK_REC.G_interface_archive_flag
1758: FROM CE_SYSTEM_PARAMETERS_ALL s,
1759: GL_SETS_OF_BOOKS g,
1760: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1761: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id
1762: and ba.ACCOUNT_OWNER_ORG_ID = s.legal_entity_id
1763: and s.set_of_books_id = g.set_of_books_id;
1764:
1765: END IF;
1786: error_found := line_error(csli_line_number, 'CE_EMU_FIXED_NOT_ALLOWED');
1787: END IF;
1788:
1789: IF l_DEBUG in ('Y', 'C') THEN
1790: cep_standard.debug('<
1792: RETURN error_found;
1793:
1794: EXCEPTION
1793:
1794: EXCEPTION
1795: WHEN OTHERS THEN
1796: IF l_DEBUG in ('Y', 'C') THEN
1797: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.line_validation');
1798: END IF;
1799: RAISE;
1800: RETURN FALSE;
1801: END line_validation;
1848:
1849: --FND_FILE.put_line(FND_FILE.LOG, 'ceabrimb');
1850:
1851: IF l_DEBUG in ('Y', 'C') THEN
1852: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.import_process ');
1853: END IF;
1854:
1855: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1856: CEP_STANDARD.init_security;
1857:
1858: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1859: CE_AUTO_BANK_REC.G_bank_account_id );
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1864: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1858: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1859: CE_AUTO_BANK_REC.G_bank_account_id );
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1864: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1866:
1859: CE_AUTO_BANK_REC.G_bank_account_id );
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1864: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1866:
1867: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1864: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1866:
1867: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1868: -- BUG 4914608
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,
1864: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag;
1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1866:
1867: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1868: -- BUG 4914608
1869: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1872: from ce_BANK_ACCOUNTS
1873: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1874: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1896: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1897: );
1898: END IF;
1899:
1900: IF l_DEBUG in ('Y', 'C') THEN
1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1907: CE_AUTO_BANK_REC.G_statement_number_to,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1914: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1915: CE_AUTO_BANK_IMPORT.G_cshi_check_digits,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1916: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1917: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1918: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1919: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1920: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1921: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1922: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1923: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1924: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1925: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1926: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1927: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1928: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1929: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1930: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1931: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1932: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1933: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1934: CE_AUTO_BANK_IMPORT.G_cshi_attribute1,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1935: CE_AUTO_BANK_IMPORT.G_cshi_attribute2,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1936: CE_AUTO_BANK_IMPORT.G_cshi_attribute3,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1937: CE_AUTO_BANK_IMPORT.G_cshi_attribute4,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1938: CE_AUTO_BANK_IMPORT.G_cshi_attribute5,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1939: CE_AUTO_BANK_IMPORT.G_cshi_attribute6,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1940: CE_AUTO_BANK_IMPORT.G_cshi_attribute7,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1941: CE_AUTO_BANK_IMPORT.G_cshi_attribute8,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1942: CE_AUTO_BANK_IMPORT.G_cshi_attribute9,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1943: CE_AUTO_BANK_IMPORT.G_cshi_attribute10,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1944: CE_AUTO_BANK_IMPORT.G_cshi_attribute11,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1945: CE_AUTO_BANK_IMPORT.G_cshi_attribute12,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1946: CE_AUTO_BANK_IMPORT.G_cshi_attribute13,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1954: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1947: CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1954: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1955: r_statement_number,
1948: CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1954: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1955: r_statement_number,
1956: aba_bank_account_name,
1949: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1954: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1955: r_statement_number,
1956: aba_bank_account_name,
1957: aba_bank_currency,
1950: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1951: CE_AUTO_BANK_IMPORT.G_cshi_bank_name,
1952: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name,
1953: CE_AUTO_BANK_IMPORT.G_cshi_currency_code,
1954: --CE_AUTO_BANK_IMPORT.G_cshi_org_id,
1955: r_statement_number,
1956: aba_bank_account_name,
1957: aba_bank_currency,
1958: aba_bank_check_digits;
1956: aba_bank_account_name,
1957: aba_bank_currency,
1958: aba_bank_check_digits;
1959: IF l_DEBUG in ('Y', 'C') THEN
1960: cep_standard.debug('CE_AUTO_BANK_IMPORT.G_cshi_statement_number ='||CE_AUTO_BANK_IMPORT.G_cshi_statement_number);
1961: END IF;
1962:
1963:
1964: EXIT WHEN bank_cursor%NOTFOUND OR bank_cursor%NOTFOUND IS NULL;
1970: header_error_found := FALSE;
1971: lock_error_found := FALSE;
1972: control_error_found := FALSE;
1973: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1974: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1976: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
1977: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1978: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
1971: lock_error_found := FALSE;
1972: control_error_found := FALSE;
1973: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1974: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1976: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
1977: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1978: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
1979: IF (lock_statement) THEN
1973: CE_HEADER_INTERFACE_ERRORS_PKG.delete_row(
1974: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1976: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
1977: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1978: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
1979: IF (lock_statement) THEN
1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
1974: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1975: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num );
1976: CE_LINE_INTERFACE_ERRORS_PKG.delete_row(
1977: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,
1978: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num, NULL);
1979: IF (lock_statement) THEN
1980: IF l_DEBUG in ('Y', 'C') THEN
1981: cep_standard.debug('aba_bank_account_id =' ||aba_bank_account_id);
1982: END IF;
1984: header_error_found := header_validation(r_statement_number,
1985: aba_bank_currency,
1986: aba_bank_check_digits,
1987: aba_bank_account_id);
1988: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1985: aba_bank_currency,
1986: aba_bank_check_digits,
1987: aba_bank_account_id);
1988: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1993: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
1986: aba_bank_check_digits,
1987: aba_bank_account_id);
1988: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1993: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
1994: LOOP
1987: aba_bank_account_id);
1988: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1993: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
1994: LOOP
1995: FETCH lines_cursor INTO csli_rowid,
1988: CE_AUTO_BANK_IMPORT.G_dr_sum := 0;
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1993: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
1994: LOOP
1995: FETCH lines_cursor INTO csli_rowid,
1996: csli_line_number,
1989: CE_AUTO_BANK_IMPORT.G_cr_sum := 0;
1990: CE_AUTO_BANK_IMPORT.G_dr_count := 0;
1991: CE_AUTO_BANK_IMPORT.G_cr_count := 0;
1992: CE_AUTO_BANK_IMPORT.G_total_count := 0;
1993: OPEN lines_cursor(CE_AUTO_BANK_IMPORT.G_cshi_statement_number, CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num);
1994: LOOP
1995: FETCH lines_cursor INTO csli_rowid,
1996: csli_line_number,
1997: csli_amount,
2010: r_exchange_rate_type,
2011: r_user_conversion_type,
2012: r_currency_code;
2013: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2014: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2011: r_user_conversion_type,
2012: r_currency_code;
2013: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2014: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2019: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2012: r_currency_code;
2013: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2014: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2019: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2020: IF (lock_statement_line(csli_rowid)) THEN
2013: EXIT WHEN lines_cursor%NOTFOUND OR lines_cursor%NOTFOUND IS NULL;
2014: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2019: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2020: IF (lock_statement_line(csli_rowid)) THEN
2021: l_error_found := line_validation( csli_amount,
2014: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.fetch line: ' || csli_line_number);
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2019: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2020: IF (lock_statement_line(csli_rowid)) THEN
2021: l_error_found := line_validation( csli_amount,
2022: csli_user_exchange_rate_type,
2015: CE_AUTO_BANK_IMPORT.G_dr_sum := CE_AUTO_BANK_IMPORT.G_dr_sum + csli_dr_sum;
2016: CE_AUTO_BANK_IMPORT.G_cr_sum := CE_AUTO_BANK_IMPORT.G_cr_sum + csli_cr_sum;
2017: CE_AUTO_BANK_IMPORT.G_dr_count := CE_AUTO_BANK_IMPORT.G_dr_count + csli_dr_count;
2018: CE_AUTO_BANK_IMPORT.G_cr_count := CE_AUTO_BANK_IMPORT.G_cr_count + csli_cr_count;
2019: CE_AUTO_BANK_IMPORT.G_total_count := CE_AUTO_BANK_IMPORT.G_total_count + 1;
2020: IF (lock_statement_line(csli_rowid)) THEN
2021: l_error_found := line_validation( csli_amount,
2022: csli_user_exchange_rate_type,
2023: csli_currency_code,
2035: IF (l_error_found) THEN
2036: line_error_found := TRUE;
2037: END IF;
2038: ELSE
2039: line_error_found := CE_AUTO_BANK_IMPORT.line_error(csli_line_number, 'CE_STATEMENT_LINT_LOCK');
2040: END IF;
2041: END LOOP; -- lines_cursor
2042: close lines_cursor;
2043: control_error_found := validate_control_totals;
2041: END LOOP; -- lines_cursor
2042: close lines_cursor;
2043: control_error_found := validate_control_totals;
2044: ELSE -- Statement header is locked
2045: lock_error_found := CE_AUTO_BANK_IMPORT.header_error('CE_STATEMENT_HINT_LOCK');
2046: END IF; -- Statement header lock
2047: IF (header_error_found OR line_error_found OR lock_error_found) THEN
2048: IF (lock_error_found) THEN
2049: NULL;
2058:
2059: xtr_shared_account(x_account_result);
2060:
2061: IF ((x_account_result = 'XTR1_SHARED' AND nvl(G_cshi_intra_day_flag,'N') <> 'Y') or
2062: (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'Y' AND nvl(G_cshi_intra_day_flag,'N') <> 'Y')) THEN
2063: IF (transfer_bank_balances) THEN
2064: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2065: transfer_lines;
2066: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2072: END IF;
2073: END IF;
2074: END IF;
2075: --ELSIF (x_account_result = 'XTR1_AP' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2076: ELSIF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2077: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2078: transfer_lines;
2079: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2080: archive_header;
2088:
2089: END IF; -- error_found
2090:
2091: -- bug 2732755
2092: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2089: END IF; -- error_found
2090:
2091: -- bug 2732755
2092: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2090:
2091: -- bug 2732755
2092: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2091: -- bug 2732755
2092: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2092: CE_AUTO_BANK_IMPORT.G_cshi_rowid := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2093: CE_AUTO_BANK_IMPORT.G_cshi_statement_number := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2094: CE_AUTO_BANK_IMPORT.G_cshi_bank_account_num := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2095: CE_AUTO_BANK_IMPORT.G_cshi_check_digits := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2096: CE_AUTO_BANK_IMPORT.G_cshi_control_begin_balance := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2097: CE_AUTO_BANK_IMPORT.G_cshi_control_end_balance := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2098: CE_AUTO_BANK_IMPORT.G_cshi_cashflow_balance := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2099: CE_AUTO_BANK_IMPORT.G_cshi_int_calc_balance := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2100: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2101: CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2102: CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2103: CE_AUTO_BANK_IMPORT.G_cshi_close_available_ytd := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2104: CE_AUTO_BANK_IMPORT.G_cshi_one_day_float := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2105: CE_AUTO_BANK_IMPORT.G_cshi_two_day_float := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2106: CE_AUTO_BANK_IMPORT.G_cshi_intra_day_flag := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2107: CE_AUTO_BANK_IMPORT.G_cshi_subsidiary_flag := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2108: CE_AUTO_BANK_IMPORT.G_cshi_control_total_dr := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2109: CE_AUTO_BANK_IMPORT.G_cshi_control_total_cr := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2110: CE_AUTO_BANK_IMPORT.G_cshi_control_dr_line_count := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2111: CE_AUTO_BANK_IMPORT.G_cshi_control_cr_line_count := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2112: CE_AUTO_BANK_IMPORT.G_cshi_control_line_count := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2113: CE_AUTO_BANK_IMPORT.G_cshi_attribute_category := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2114: CE_AUTO_BANK_IMPORT.G_cshi_attribute1 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2115: CE_AUTO_BANK_IMPORT.G_cshi_attribute2 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2116: CE_AUTO_BANK_IMPORT.G_cshi_attribute3 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2117: CE_AUTO_BANK_IMPORT.G_cshi_attribute4 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2118: CE_AUTO_BANK_IMPORT.G_cshi_attribute5 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2119: CE_AUTO_BANK_IMPORT.G_cshi_attribute6 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2120: CE_AUTO_BANK_IMPORT.G_cshi_attribute7 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2121: CE_AUTO_BANK_IMPORT.G_cshi_attribute8 := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2122: CE_AUTO_BANK_IMPORT.G_cshi_attribute9 := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2123: CE_AUTO_BANK_IMPORT.G_cshi_attribute10 := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2124: CE_AUTO_BANK_IMPORT.G_cshi_attribute11 := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2125: CE_AUTO_BANK_IMPORT.G_cshi_attribute12 := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2126: CE_AUTO_BANK_IMPORT.G_cshi_attribute13 := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2134: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2127: CE_AUTO_BANK_IMPORT.G_cshi_attribute14 := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2134: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2135: r_statement_number := null;
2128: CE_AUTO_BANK_IMPORT.G_cshi_attribute15 := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2134: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2135: r_statement_number := null;
2136: aba_bank_account_name := null;
2129: CE_AUTO_BANK_IMPORT.G_cshi_statement_date := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2134: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2135: r_statement_number := null;
2136: aba_bank_account_name := null;
2137: aba_bank_currency := null;
2130: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2131: CE_AUTO_BANK_IMPORT.G_cshi_bank_name := null;
2132: CE_AUTO_BANK_IMPORT.G_cshi_bank_branch_name := null;
2133: CE_AUTO_BANK_IMPORT.G_cshi_currency_code := null;
2134: --CE_AUTO_BANK_IMPORT.G_cshi_org_id := null;
2135: r_statement_number := null;
2136: aba_bank_account_name := null;
2137: aba_bank_currency := null;
2138: aba_bank_check_digits := null;
2154: IF lines_cursor%ISOPEN THEN
2155: close lines_cursor;
2156: END IF;
2157: IF l_DEBUG in ('Y', 'C') THEN
2158: cep_standard.debug('EXCEPTION: CE_AUTO_BANK_IMPORT.import_process');
2159: END IF;
2160: RAISE;
2161: END import_process;
2162:
2159: END IF;
2160: RAISE;
2161: END import_process;
2162:
2163: END CE_AUTO_BANK_IMPORT;