1: PACKAGE BODY CE_JE_CREATION AS
2: /* $Header: cejecrnb.pls 120.24.12010000.2 2008/08/10 14:27:49 csutaria ship $ */
3:
4: --
5: -- Global Variables
158: INTO l_count
159: FROM gl_period_statuses glp,
160: ce_system_parameters sys
161: WHERE glp.set_of_books_id = sys.set_of_books_id
162: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id
163: AND glp.closing_status in ('O','F')
164: AND glp.application_id = 101
165: AND glp.adjustment_period_flag = 'N'
166: AND to_char(p_accounting_date,'YYYY/MM/DD') BETWEEN
190: --------------------------------------------------------------------- */
191: PROCEDURE Determine_cleared_date (p_result IN OUT NOCOPY VARCHAR2) IS
192: BEGIN
193: log('>>Determine_cleared_date');
194: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
195: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
196: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
197: ELSE
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
191: PROCEDURE Determine_cleared_date (p_result IN OUT NOCOPY VARCHAR2) IS
192: BEGIN
193: log('>>Determine_cleared_date');
194: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
195: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
196: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
197: ELSE
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
199: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
192: BEGIN
193: log('>>Determine_cleared_date');
194: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
195: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
196: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
197: ELSE
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
199: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
200: END IF;
194: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
195: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
196: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
197: ELSE
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
199: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
200: END IF;
201:
202: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN
195: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
196: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
197: ELSE
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
199: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
200: END IF;
201:
202: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN
203: p_result := 'S';
198: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
199: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
200: END IF;
201:
202: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN
203: p_result := 'S';
204: log('cleared date is in a open or future period');
205: ELSE
206: p_result := 'F';
263: | 16-SEP-2004 Shaik Vali Created |
264: --------------------------------------------------------------------- */
265: PROCEDURE Initialize_CF_data IS
266: BEGIN
267: CE_JE_CREATION.cf_ledger_id := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
264: --------------------------------------------------------------------- */
265: PROCEDURE Initialize_CF_data IS
266: BEGIN
267: CE_JE_CREATION.cf_ledger_id := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
265: PROCEDURE Initialize_CF_data IS
266: BEGIN
267: CE_JE_CREATION.cf_ledger_id := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
266: BEGIN
267: CE_JE_CREATION.cf_ledger_id := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
267: CE_JE_CREATION.cf_ledger_id := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
268: CE_JE_CREATION.cf_legal_entity_id := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
269: CE_JE_CREATION.cf_bank_account_id := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
270: CE_JE_CREATION.cf_direction := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
271: CE_JE_CREATION.cf_currency_code := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
272: CE_JE_CREATION.cf_cashflow_date := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
273: CE_JE_CREATION.cf_cashflow_amount := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
274: CE_JE_CREATION.cf_description := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
275: CE_JE_CREATION.cf_trxn_reference_number := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
276: CE_JE_CREATION.cf_bank_trxn_number := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
277: CE_JE_CREATION.cf_source_trxn_type := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
278: CE_JE_CREATION.cf_statement_line_id := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
279: CE_JE_CREATION.cf_actual_value_date := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
280: CE_JE_CREATION.cf_offset_ccid := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
281: CE_JE_CREATION.cf_status_code := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
282: CE_JE_CREATION.cf_cleared_date := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
283: CE_JE_CREATION.cf_cleared_amount := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
291: CE_JE_CREATION.cf_customer_text := NULL;
284: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
291: CE_JE_CREATION.cf_customer_text := NULL;
292:
285: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
291: CE_JE_CREATION.cf_customer_text := NULL;
292:
293: END Initialize_CF_data;
286: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
291: CE_JE_CREATION.cf_customer_text := NULL;
292:
293: END Initialize_CF_data;
294:
287: CE_JE_CREATION.cf_base_amount := NULL;
288: CE_JE_CREATION.cf_reference_text := NULL;
289: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
290: CE_JE_CREATION.cf_bank_account_text := NULL;
291: CE_JE_CREATION.cf_customer_text := NULL;
292:
293: END Initialize_CF_data;
294:
295:
307: l_type VARCHAR2(30);
308: BEGIN
309: log('>> Currency_type');
310:
311: IF (CE_JE_CREATION.sys_currency_code = CE_JE_CREATION.ba_currency_code) THEN
312: IF (CE_JE_CREATION.ba_currency_code = NVL(CE_JE_CREATION.csl_currency_code, CE_JE_CREATION.csh_currency_code)) THEN
313: l_type := 'DOMESTIC';
314: ELSE
315: l_type := 'INTERNATIONAL';
308: BEGIN
309: log('>> Currency_type');
310:
311: IF (CE_JE_CREATION.sys_currency_code = CE_JE_CREATION.ba_currency_code) THEN
312: IF (CE_JE_CREATION.ba_currency_code = NVL(CE_JE_CREATION.csl_currency_code, CE_JE_CREATION.csh_currency_code)) THEN
313: l_type := 'DOMESTIC';
314: ELSE
315: l_type := 'INTERNATIONAL';
316: END IF;
375:
376: p_result := 'S';
377:
378: IF (Currency_type = 'FOREIGN') THEN
379: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
380: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
381: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
382: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
376: p_result := 'S';
377:
378: IF (Currency_type = 'FOREIGN') THEN
379: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
380: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
381: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
382: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
384: -- currency_type when the exchange rate was given manually.
377:
378: IF (Currency_type = 'FOREIGN') THEN
379: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
380: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
381: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
382: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
384: -- currency_type when the exchange rate was given manually.
385: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
378: IF (Currency_type = 'FOREIGN') THEN
379: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
380: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
381: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
382: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
384: -- currency_type when the exchange rate was given manually.
385: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
386: ELSE
381: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
382: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
384: -- currency_type when the exchange rate was given manually.
385: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
386: ELSE
387: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
388: log('sys xchange_rate_date='||l_xchange_rate_date);
389: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
383: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
384: -- currency_type when the exchange rate was given manually.
385: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
386: ELSE
387: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
388: log('sys xchange_rate_date='||l_xchange_rate_date);
389: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
390: IF (l_xchange_rate_date = 'CFD') THEN
391: CE_JE_CREATION.cf_cleared_exchange_date :=
385: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
386: ELSE
387: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
388: log('sys xchange_rate_date='||l_xchange_rate_date);
389: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
390: IF (l_xchange_rate_date = 'CFD') THEN
391: CE_JE_CREATION.cf_cleared_exchange_date :=
392: CE_JE_CREATION.csl_trx_date;
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
387: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
388: log('sys xchange_rate_date='||l_xchange_rate_date);
389: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
390: IF (l_xchange_rate_date = 'CFD') THEN
391: CE_JE_CREATION.cf_cleared_exchange_date :=
392: CE_JE_CREATION.csl_trx_date;
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
388: log('sys xchange_rate_date='||l_xchange_rate_date);
389: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
390: IF (l_xchange_rate_date = 'CFD') THEN
391: CE_JE_CREATION.cf_cleared_exchange_date :=
392: CE_JE_CREATION.csl_trx_date;
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
396: ELSIF (l_xchange_rate_date = 'CLD') THEN
390: IF (l_xchange_rate_date = 'CFD') THEN
391: CE_JE_CREATION.cf_cleared_exchange_date :=
392: CE_JE_CREATION.csl_trx_date;
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
396: ELSIF (l_xchange_rate_date = 'CLD') THEN
397: CE_JE_CREATION.cf_cleared_exchange_date :=
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
391: CE_JE_CREATION.cf_cleared_exchange_date :=
392: CE_JE_CREATION.csl_trx_date;
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
396: ELSIF (l_xchange_rate_date = 'CLD') THEN
397: CE_JE_CREATION.cf_cleared_exchange_date :=
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
399: -- determined at this point.
393: ELSIF (l_xchange_rate_date = 'BSG') THEN
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
396: ELSIF (l_xchange_rate_date = 'CLD') THEN
397: CE_JE_CREATION.cf_cleared_exchange_date :=
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
399: -- determined at this point.
400: ELSIF (l_xchange_rate_date = 'BSD') THEN
401: CE_JE_CREATION.cf_cleared_exchange_date :=
394: CE_JE_CREATION.cf_cleared_exchange_date :=
395: CE_JE_CREATION.cf_cleared_date;
396: ELSIF (l_xchange_rate_date = 'CLD') THEN
397: CE_JE_CREATION.cf_cleared_exchange_date :=
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
399: -- determined at this point.
400: ELSIF (l_xchange_rate_date = 'BSD') THEN
401: CE_JE_CREATION.cf_cleared_exchange_date :=
402: CE_JE_CREATION.csh_statement_date;
397: CE_JE_CREATION.cf_cleared_exchange_date :=
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
399: -- determined at this point.
400: ELSIF (l_xchange_rate_date = 'BSD') THEN
401: CE_JE_CREATION.cf_cleared_exchange_date :=
402: CE_JE_CREATION.csh_statement_date;
403: ELSE
404: -- error: exchange date cannot be determined
405: p_result := 'F';
398: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
399: -- determined at this point.
400: ELSIF (l_xchange_rate_date = 'BSD') THEN
401: CE_JE_CREATION.cf_cleared_exchange_date :=
402: CE_JE_CREATION.csh_statement_date;
403: ELSE
404: -- error: exchange date cannot be determined
405: p_result := 'F';
406: END IF;
407:
408: IF (p_result <> 'F') THEN
409: log('calling gl_currency_api');
410: log('>>Determine_exchange_info');
411: log('ba_curr='||ce_je_Creation.ba_currency_code);
412: log('sys_curr='||ce_je_creation.sys_currency_code);
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
408: IF (p_result <> 'F') THEN
409: log('calling gl_currency_api');
410: log('>>Determine_exchange_info');
411: log('ba_curr='||ce_je_Creation.ba_currency_code);
412: log('sys_curr='||ce_je_creation.sys_currency_code);
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
409: log('calling gl_currency_api');
410: log('>>Determine_exchange_info');
411: log('ba_curr='||ce_je_Creation.ba_currency_code);
412: log('sys_curr='||ce_je_creation.sys_currency_code);
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
410: log('>>Determine_exchange_info');
411: log('ba_curr='||ce_je_Creation.ba_currency_code);
412: log('sys_curr='||ce_je_creation.sys_currency_code);
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
411: log('ba_curr='||ce_je_Creation.ba_currency_code);
412: log('sys_curr='||ce_je_creation.sys_currency_code);
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
413: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
414: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
415: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
423: END IF;
416:
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
423: END IF;
424: END IF;
417: CE_JE_CREATION.cf_cleared_exchange_rate :=
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
423: END IF;
424: END IF;
425: ELSE -- domestic and international
418: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
419: CE_JE_CREATION.sys_currency_code,
420: CE_JE_CREATION.cf_cleared_exchange_date,
421: CE_JE_CREATION.cf_cleared_exchange_rate_type);
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
423: END IF;
424: END IF;
425: ELSE -- domestic and international
426: CE_JE_CREATION.cf_cleared_exchange_rate := null;
422: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
423: END IF;
424: END IF;
425: ELSE -- domestic and international
426: CE_JE_CREATION.cf_cleared_exchange_rate := null;
427: CE_JE_CREATION.cf_cleared_exchange_date := null;
428: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
423: END IF;
424: END IF;
425: ELSE -- domestic and international
426: CE_JE_CREATION.cf_cleared_exchange_rate := null;
427: CE_JE_CREATION.cf_cleared_exchange_date := null;
428: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
424: END IF;
425: ELSE -- domestic and international
426: CE_JE_CREATION.cf_cleared_exchange_rate := null;
427: CE_JE_CREATION.cf_cleared_exchange_date := null;
428: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
432: CE_JE_CREATION.csl_original_amount;
427: CE_JE_CREATION.cf_cleared_exchange_date := null;
428: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
432: CE_JE_CREATION.csl_original_amount;
433: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
428: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
432: CE_JE_CREATION.csl_original_amount;
433: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
436: --bug5328385
429: --Bug 5016835
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
432: CE_JE_CREATION.csl_original_amount;
433: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
430: IF (currency_type = 'INTERNATIONAL') THEN
431: CE_JE_CREATION.cf_cashflow_amount :=
432: CE_JE_CREATION.csl_original_amount;
433: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
433: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
434: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
435:
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
435:
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
436: --bug5328385
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
437: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
445: ELSE
438: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
439: CE_JE_CREATION.sys_currency_code,
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
447: precision, ext_precision, min_acct_unit);
440: CE_JE_CREATION.csl_currency_code,
441: nvl(CE_JE_CREATION.csl_exchange_rate_date,
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
447: precision, ext_precision, min_acct_unit);
448: CE_JE_CREATION.cf_cashflow_amount :=
442: CE_JE_CREATION.csl_trx_date),
443: CE_JE_CREATION.csl_exchange_rate_type,
444: CE_JE_CREATION.csl_amount);
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
447: precision, ext_precision, min_acct_unit);
448: CE_JE_CREATION.cf_cashflow_amount :=
449: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
450: END IF;
444: CE_JE_CREATION.csl_amount);
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
447: precision, ext_precision, min_acct_unit);
448: CE_JE_CREATION.cf_cashflow_amount :=
449: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
450: END IF;
451: ELSE
452: p_result := 'F';
445: ELSE
446: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
447: precision, ext_precision, min_acct_unit);
448: CE_JE_CREATION.cf_cashflow_amount :=
449: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
450: END IF;
451: ELSE
452: p_result := 'F';
453: END IF;
452: p_result := 'F';
453: END IF;
454: END IF;
455: ELSE
456: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
457: END IF;
458: END IF;
459: log('<
481: PROCEDURE Determine_base_amount IS
482: BEGIN
483: log('>>Determine_base_amount');
484: IF Currency_type = 'FOREIGN' THEN
485: CE_JE_CREATION.cf_base_amount :=
486: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
487: ELSE
488: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
489: END IF;
482: BEGIN
483: log('>>Determine_base_amount');
484: IF Currency_type = 'FOREIGN' THEN
485: CE_JE_CREATION.cf_base_amount :=
486: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
487: ELSE
488: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
489: END IF;
490: log('>>Determine_base_amount');
484: IF Currency_type = 'FOREIGN' THEN
485: CE_JE_CREATION.cf_base_amount :=
486: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
487: ELSE
488: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
489: END IF;
490: log('>>Determine_base_amount');
491: END Determine_base_amount;
492:
503: --------------------------------------------------------------------- */
504: PROCEDURE Populate_CF_data IS
505: BEGIN
506: log('>> Populate_CF_data');
507: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
504: PROCEDURE Populate_CF_data IS
505: BEGIN
506: log('>> Populate_CF_data');
507: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
505: BEGIN
506: log('>> Populate_CF_data');
507: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
506: log('>> Populate_CF_data');
507: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
507: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
508: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
516: END IF;
509: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
516: END IF;
517: IF currency_type = 'INTERNATIONAL' THEN
510: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
516: END IF;
517: IF currency_type = 'INTERNATIONAL' THEN
518: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
511: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
512: CE_JE_CREATION.cf_direction := 'RECEIPT';
513: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
516: END IF;
517: IF currency_type = 'INTERNATIONAL' THEN
518: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
519: ELSE
514: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
515: CE_JE_CREATION.cf_direction := 'PAYMENT';
516: END IF;
517: IF currency_type = 'INTERNATIONAL' THEN
518: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
519: ELSE
520: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
516: END IF;
517: IF currency_type = 'INTERNATIONAL' THEN
518: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
519: ELSE
520: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
518: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
519: ELSE
520: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
519: ELSE
520: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
520: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
521: END IF;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
522: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
523: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
524: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
525: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
526: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
527: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
535: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
528: CE_JE_CREATION.csl_trx_date);
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
535: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
536:
529: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
535: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
536:
537: log('<< Populate_CF_data');
530: CE_JE_CREATION.cf_status_code := 'CLEARED';
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
535: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
536:
537: log('<< Populate_CF_data');
538: EXCEPTION
531: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
532: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
533: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
534: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
535: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
536:
537: log('<< Populate_CF_data');
538: EXCEPTION
539: WHEN OTHERS THEN
558: log('>> Populate_CF_table');
559: CE_CASHFLOWS_PKG.insert_row (
560: x_rowid,
561: x_cashflow_id,
562: CE_JE_CREATION.cf_ledger_id,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
559: CE_CASHFLOWS_PKG.insert_row (
560: x_rowid,
561: x_cashflow_id,
562: CE_JE_CREATION.cf_ledger_id,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
560: x_rowid,
561: x_cashflow_id,
562: CE_JE_CREATION.cf_ledger_id,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
561: x_cashflow_id,
562: CE_JE_CREATION.cf_ledger_id,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
562: CE_JE_CREATION.cf_ledger_id,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
570: CE_JE_CREATION.cf_description,
563: CE_JE_CREATION.cf_legal_entity_id,
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
570: CE_JE_CREATION.cf_description,
571: null, -- cashflow_exchange_rate
564: CE_JE_CREATION.cf_bank_account_id,
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
570: CE_JE_CREATION.cf_description,
571: null, -- cashflow_exchange_rate
572: null, -- cashflow_exchange_date
565: CE_JE_CREATION.cf_direction,
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
570: CE_JE_CREATION.cf_description,
571: null, -- cashflow_exchange_rate
572: null, -- cashflow_exchange_date
573: null, -- cashflow_exchange_rate_type
566: CE_JE_CREATION.cf_currency_code,
567: CE_JE_CREATION.cf_cashflow_date,
568: CE_JE_CREATION.cf_cashflow_amount,
569: CE_JE_CREATION.cf_base_amount,
570: CE_JE_CREATION.cf_description,
571: null, -- cashflow_exchange_rate
572: null, -- cashflow_exchange_date
573: null, -- cashflow_exchange_rate_type
574: CE_JE_CREATION.cf_trxn_reference_number,
570: CE_JE_CREATION.cf_description,
571: null, -- cashflow_exchange_rate
572: null, -- cashflow_exchange_date
573: null, -- cashflow_exchange_rate_type
574: CE_JE_CREATION.cf_trxn_reference_number,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
571: null, -- cashflow_exchange_rate
572: null, -- cashflow_exchange_date
573: null, -- cashflow_exchange_rate_type
574: CE_JE_CREATION.cf_trxn_reference_number,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
572: null, -- cashflow_exchange_date
573: null, -- cashflow_exchange_rate_type
574: CE_JE_CREATION.cf_trxn_reference_number,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
573: null, -- cashflow_exchange_rate_type
574: CE_JE_CREATION.cf_trxn_reference_number,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
574: CE_JE_CREATION.cf_trxn_reference_number,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
575: CE_JE_CREATION.cf_bank_trxn_number,
576: CE_JE_CREATION.cf_source_trxn_type,
577: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
578: CE_JE_CREATION.cf_statement_line_id,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
579: CE_JE_CREATION.cf_actual_value_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
580: null, -- counterparty_party_id
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
581: null, -- counterparty_bank_account_id
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
589: null, -- clearing_charges_amount
582: CE_JE_CREATION.cf_offset_ccid,
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
589: null, -- clearing_charges_amount
590: null, -- clearing_error_amount
583: CE_JE_CREATION.cf_status_code,
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
589: null, -- clearing_charges_amount
590: null, -- clearing_error_amount
591: null, -- cleared_by_flag
584: CE_JE_CREATION.cf_cleared_date,
585: CE_JE_CREATION.cf_cleared_amount,
586: CE_JE_CREATION.cf_cleared_exchange_rate,
587: CE_JE_CREATION.cf_cleared_exchange_date,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
589: null, -- clearing_charges_amount
590: null, -- clearing_error_amount
591: null, -- cleared_by_flag
592: CE_JE_CREATION.cf_reference_text,
588: CE_JE_CREATION.cf_cleared_exchange_rate_type,
589: null, -- clearing_charges_amount
590: null, -- clearing_error_amount
591: null, -- cleared_by_flag
592: CE_JE_CREATION.cf_reference_text,
593: CE_JE_CREATION.cf_bank_account_text,
594: CE_JE_CREATION.cf_customer_text,
595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
589: null, -- clearing_charges_amount
590: null, -- clearing_error_amount
591: null, -- cleared_by_flag
592: CE_JE_CREATION.cf_reference_text,
593: CE_JE_CREATION.cf_bank_account_text,
594: CE_JE_CREATION.cf_customer_text,
595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
597: NVL(FND_GLOBAL.user_id,-1),
590: null, -- clearing_error_amount
591: null, -- cleared_by_flag
592: CE_JE_CREATION.cf_reference_text,
593: CE_JE_CREATION.cf_bank_account_text,
594: CE_JE_CREATION.cf_customer_text,
595: NVL(FND_GLOBAL.user_id,-1),
596: sysdate,
597: NVL(FND_GLOBAL.user_id,-1),
598: sysdate,
624: SELECT 1
625: INTO l_dummy
626: FROM
627: ce_statement_lines
628: WHERE rowid = CE_JE_CREATION.csl_rowid
629: FOR UPDATE OF je_status_flag NOWAIT;
630:
631: RETURN true;
632: log('<
684: Determine_exchange_info(l_result);
685: IF(l_result = 'S') THEN
686: Validate_Multi_Currency(l_result);
687: IF (l_result = 'S') THEN
688: Validate_GL_account(CE_JE_CREATION.jem_gl_account_ccid,l_result);
689: IF(l_result = 'S') THEN
690: Determine_base_amount;
691: --
692: -- validations are done. now
694: -- the stmt line.
695: Populate_CF_data;
696: Populate_CF_table(l_cashflow_id);
697: -- insert cashflow_id into statement_line table
698: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
699: l_cashflow_id,'S');
700: -- create accounting event
701: CE_XLA_ACCT_EVENTS_PKG.create_event(l_cashflow_id,
702: 'CE_STMT_RECORDED',
702: 'CE_STMT_RECORDED',
703: null);
704: /* Bug 4997215 -- populated error messages table even for
705: successes with a dummy error message.*/
706: CE_JE_CREATION_ERRORS_PKG.insert_row(
707: CE_JE_CREATION.csh_statement_header_id,
708: CE_JE_CREATION.csl_statement_line_id,
709: 'DUMMY',
710: NVL(FND_GLOBAL.user_id,-1),
703: null);
704: /* Bug 4997215 -- populated error messages table even for
705: successes with a dummy error message.*/
706: CE_JE_CREATION_ERRORS_PKG.insert_row(
707: CE_JE_CREATION.csh_statement_header_id,
708: CE_JE_CREATION.csl_statement_line_id,
709: 'DUMMY',
710: NVL(FND_GLOBAL.user_id,-1),
711: sysdate,
704: /* Bug 4997215 -- populated error messages table even for
705: successes with a dummy error message.*/
706: CE_JE_CREATION_ERRORS_PKG.insert_row(
707: CE_JE_CREATION.csh_statement_header_id,
708: CE_JE_CREATION.csl_statement_line_id,
709: 'DUMMY',
710: NVL(FND_GLOBAL.user_id,-1),
711: sysdate,
712: sysdate,
714: NVL(FND_GLOBAL.user_id,-1),
715: g_request_id);
716:
717: ELSE -- Invalid gl account
718: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
719: null,'E');
720: CE_JE_CREATION_ERRORS_PKG.insert_row(
721: CE_JE_CREATION.csh_statement_header_id,
722: CE_JE_CREATION.csl_statement_line_id,
716:
717: ELSE -- Invalid gl account
718: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
719: null,'E');
720: CE_JE_CREATION_ERRORS_PKG.insert_row(
721: CE_JE_CREATION.csh_statement_header_id,
722: CE_JE_CREATION.csl_statement_line_id,
723: 'CE_INVALID_GL_ACCOUNT',
724: NVL(FND_GLOBAL.user_id,-1),
717: ELSE -- Invalid gl account
718: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
719: null,'E');
720: CE_JE_CREATION_ERRORS_PKG.insert_row(
721: CE_JE_CREATION.csh_statement_header_id,
722: CE_JE_CREATION.csl_statement_line_id,
723: 'CE_INVALID_GL_ACCOUNT',
724: NVL(FND_GLOBAL.user_id,-1),
725: sysdate,
718: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
719: null,'E');
720: CE_JE_CREATION_ERRORS_PKG.insert_row(
721: CE_JE_CREATION.csh_statement_header_id,
722: CE_JE_CREATION.csl_statement_line_id,
723: 'CE_INVALID_GL_ACCOUNT',
724: NVL(FND_GLOBAL.user_id,-1),
725: sysdate,
726: sysdate,
729: g_request_id);
730: log('invalid gl account');
731: END IF;
732: ELSE --bank account not multi currency enabled
733: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
734: null,'E');
735: CE_JE_CREATION_ERRORS_PKG.insert_row(
736: CE_JE_CREATION.csh_statement_header_id,
737: CE_JE_CREATION.csl_statement_line_id,
731: END IF;
732: ELSE --bank account not multi currency enabled
733: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
734: null,'E');
735: CE_JE_CREATION_ERRORS_PKG.insert_row(
736: CE_JE_CREATION.csh_statement_header_id,
737: CE_JE_CREATION.csl_statement_line_id,
738: 'CE_NOT_MULTI_CURR',
739: NVL(FND_GLOBAL.user_id,-1),
732: ELSE --bank account not multi currency enabled
733: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
734: null,'E');
735: CE_JE_CREATION_ERRORS_PKG.insert_row(
736: CE_JE_CREATION.csh_statement_header_id,
737: CE_JE_CREATION.csl_statement_line_id,
738: 'CE_NOT_MULTI_CURR',
739: NVL(FND_GLOBAL.user_id,-1),
740: sysdate,
733: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
734: null,'E');
735: CE_JE_CREATION_ERRORS_PKG.insert_row(
736: CE_JE_CREATION.csh_statement_header_id,
737: CE_JE_CREATION.csl_statement_line_id,
738: 'CE_NOT_MULTI_CURR',
739: NVL(FND_GLOBAL.user_id,-1),
740: sysdate,
741: sysdate,
743: NVL(FND_GLOBAL.user_id,-1),
744: g_request_id);
745: END IF;
746: ELSE -- exchange info cannot be determined
747: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
748: null,'E');
749: CE_JE_CREATION_ERRORS_PKG.insert_row(
750: CE_JE_CREATION.csh_statement_header_id,
751: CE_JE_CREATION.csl_statement_line_id,
745: END IF;
746: ELSE -- exchange info cannot be determined
747: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
748: null,'E');
749: CE_JE_CREATION_ERRORS_PKG.insert_row(
750: CE_JE_CREATION.csh_statement_header_id,
751: CE_JE_CREATION.csl_statement_line_id,
752: 'CE_MISSING_USER_RATE',
753: NVL(FND_GLOBAL.user_id,-1),
746: ELSE -- exchange info cannot be determined
747: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
748: null,'E');
749: CE_JE_CREATION_ERRORS_PKG.insert_row(
750: CE_JE_CREATION.csh_statement_header_id,
751: CE_JE_CREATION.csl_statement_line_id,
752: 'CE_MISSING_USER_RATE',
753: NVL(FND_GLOBAL.user_id,-1),
754: sysdate,
747: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
748: null,'E');
749: CE_JE_CREATION_ERRORS_PKG.insert_row(
750: CE_JE_CREATION.csh_statement_header_id,
751: CE_JE_CREATION.csl_statement_line_id,
752: 'CE_MISSING_USER_RATE',
753: NVL(FND_GLOBAL.user_id,-1),
754: sysdate,
755: sysdate,
758: g_request_id);
759: log('Exchange info cannot be determined.');
760: END IF;
761: ELSE -- invalid cleared date
762: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
763: null,'E');
764: CE_JE_CREATION_ERRORS_PKG.insert_row(
765: CE_JE_CREATION.csh_statement_header_id,
766: CE_JE_CREATION.csl_statement_line_id,
760: END IF;
761: ELSE -- invalid cleared date
762: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
763: null,'E');
764: CE_JE_CREATION_ERRORS_PKG.insert_row(
765: CE_JE_CREATION.csh_statement_header_id,
766: CE_JE_CREATION.csl_statement_line_id,
767: 'CE_INVALID_CLEARED_DATE',
768: NVL(FND_GLOBAL.user_id,-1),
761: ELSE -- invalid cleared date
762: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
763: null,'E');
764: CE_JE_CREATION_ERRORS_PKG.insert_row(
765: CE_JE_CREATION.csh_statement_header_id,
766: CE_JE_CREATION.csl_statement_line_id,
767: 'CE_INVALID_CLEARED_DATE',
768: NVL(FND_GLOBAL.user_id,-1),
769: sysdate,
762: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
763: null,'E');
764: CE_JE_CREATION_ERRORS_PKG.insert_row(
765: CE_JE_CREATION.csh_statement_header_id,
766: CE_JE_CREATION.csl_statement_line_id,
767: 'CE_INVALID_CLEARED_DATE',
768: NVL(FND_GLOBAL.user_id,-1),
769: sysdate,
770: sysdate,
830: OPEN bank_branch_cursor(g_p_bank_branch_id,g_p_bank_account_id);
831: LOOP
832: FETCH bank_branch_cursor
833: INTO l_bank_account_id,
834: CE_JE_CREATION.ba_legal_entity_id;
835: EXIT WHEN bank_branch_cursor%NOTFOUND OR
836: bank_branch_cursor%NOTFOUND IS NULL;
837: BEGIN
838: SELECT sob.currency_code,
840: sys.cashflow_exchange_rate_type,
841: --xle.ledger_id
842: sys.set_of_books_id
843: INTO
844: CE_JE_CREATION.sys_currency_code,
845: CE_JE_CREATION.sys_exchange_rate_date,
846: CE_JE_CREATION.sys_exchange_rate_type,
847: CE_JE_CREATION.sys_sob_id
848: FROM
841: --xle.ledger_id
842: sys.set_of_books_id
843: INTO
844: CE_JE_CREATION.sys_currency_code,
845: CE_JE_CREATION.sys_exchange_rate_date,
846: CE_JE_CREATION.sys_exchange_rate_type,
847: CE_JE_CREATION.sys_sob_id
848: FROM
849: ce_system_parameters sys, -- change to base table per BH's request
842: sys.set_of_books_id
843: INTO
844: CE_JE_CREATION.sys_currency_code,
845: CE_JE_CREATION.sys_exchange_rate_date,
846: CE_JE_CREATION.sys_exchange_rate_type,
847: CE_JE_CREATION.sys_sob_id
848: FROM
849: ce_system_parameters sys, -- change to base table per BH's request
850: gl_sets_of_books sob,
843: INTO
844: CE_JE_CREATION.sys_currency_code,
845: CE_JE_CREATION.sys_exchange_rate_date,
846: CE_JE_CREATION.sys_exchange_rate_type,
847: CE_JE_CREATION.sys_sob_id
848: FROM
849: ce_system_parameters sys, -- change to base table per BH's request
850: gl_sets_of_books sob,
851: ce_bank_accounts ba
880: --
881: OPEN statement_lines_cursor(l_statement_header_id);
882: LOOP
883: FETCH statement_lines_cursor INTO
884: CE_JE_CREATION.csl_rowid,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
881: OPEN statement_lines_cursor(l_statement_header_id);
882: LOOP
883: FETCH statement_lines_cursor INTO
884: CE_JE_CREATION.csl_rowid,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
882: LOOP
883: FETCH statement_lines_cursor INTO
884: CE_JE_CREATION.csl_rowid,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
883: FETCH statement_lines_cursor INTO
884: CE_JE_CREATION.csl_rowid,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
884: CE_JE_CREATION.csl_rowid,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
885: CE_JE_CREATION.csl_statement_line_id,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
886: CE_JE_CREATION.csl_trx_code_id,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
887: CE_JE_CREATION.csl_amount,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
888: CE_JE_CREATION.csl_status,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
889: CE_JE_CREATION.csl_currency_code,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
890: CE_JE_CREATION.csh_currency_code,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
891: CE_JE_CREATION.csh_statement_date,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
892: CE_JE_CREATION.csh_statement_gl_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
893: CE_JE_CREATION.ba_currency_code,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
894: CE_JE_CREATION.csl_effective_date,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
895: CE_JE_CREATION.csl_trx_date,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
896: CE_JE_CREATION.csl_trx_type,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
897: CE_JE_CREATION.csl_original_amount,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
898: CE_JE_CREATION.csl_exchange_rate_type,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
899: CE_JE_CREATION.csl_exchange_rate,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
900: CE_JE_CREATION.csl_exchange_rate_date,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
901: --CE_JE_CREATION.csl_je_status_flag,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
902: CE_JE_CREATION.csl_trx_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
903: CE_JE_CREATION.csh_statement_header_id,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
904: CE_JE_CREATION.csh_bank_account_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
905: CE_JE_CREATION.jem_gl_account_ccid,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
913: g_multi_currency,
906: CE_JE_CREATION.jem_search_string_txt,
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
913: g_multi_currency,
914: CE_JE_CREATION.jem_trxn_subtype_code_id;
907: CE_JE_CREATION.jem_reference_txt,
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
913: g_multi_currency,
914: CE_JE_CREATION.jem_trxn_subtype_code_id;
915: EXIT WHEN statement_lines_cursor%NOTFOUND or
908: --CE_JE_CREATION.csh_bank_account_ccid,
909: CE_JE_CREATION.csl_bank_trx_number,
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
913: g_multi_currency,
914: CE_JE_CREATION.jem_trxn_subtype_code_id;
915: EXIT WHEN statement_lines_cursor%NOTFOUND or
916: statement_lines_cursor%NOTFOUND IS NULL;
910: CE_JE_CREATION.csl_bank_account_text,
911: CE_JE_CREATION.csl_customer_text,
912: CE_JE_CREATION.csl_cashflow_id,
913: g_multi_currency,
914: CE_JE_CREATION.jem_trxn_subtype_code_id;
915: EXIT WHEN statement_lines_cursor%NOTFOUND or
916: statement_lines_cursor%NOTFOUND IS NULL;
917:
918:
915: EXIT WHEN statement_lines_cursor%NOTFOUND or
916: statement_lines_cursor%NOTFOUND IS NULL;
917:
918:
919: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
920:
921: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
917:
918:
919: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
920:
921: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
924: CE_JE_CREATION.csl_statement_line_id,
925: 'CE_NO_BA_LE_IN_SYS',
918:
919: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
920:
921: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
924: CE_JE_CREATION.csl_statement_line_id,
925: 'CE_NO_BA_LE_IN_SYS',
926: NVL(FND_GLOBAL.user_id,-1),
919: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
920:
921: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
924: CE_JE_CREATION.csl_statement_line_id,
925: 'CE_NO_BA_LE_IN_SYS',
926: NVL(FND_GLOBAL.user_id,-1),
927: sysdate,
920:
921: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
922: CE_JE_CREATION_ERRORS_PKG.insert_row(
923: CE_JE_CREATION.csh_statement_header_id,
924: CE_JE_CREATION.csl_statement_line_id,
925: 'CE_NO_BA_LE_IN_SYS',
926: NVL(FND_GLOBAL.user_id,-1),
927: sysdate,
928: sysdate,
936: -- if it matches more than one JE mapping. its
937: -- difficult and performance intensive if we put
938: -- this logic in the sql stmt
939: --
940: IF l_last_statement_line_id <> CE_JE_CREATION.csl_statement_line_id THEN
941: IF(lock_statement_line) THEN
942: Process_statement_line;
943: ELSE
944: CE_JE_CREATION_ERRORS_PKG.insert_row(
940: IF l_last_statement_line_id <> CE_JE_CREATION.csl_statement_line_id THEN
941: IF(lock_statement_line) THEN
942: Process_statement_line;
943: ELSE
944: CE_JE_CREATION_ERRORS_PKG.insert_row(
945: CE_JE_CREATION.csh_statement_header_id,
946: CE_JE_CREATION.csl_statement_line_id,
947: 'CE_LINE_LOCKED',
948: NVL(FND_GLOBAL.user_id,-1),
941: IF(lock_statement_line) THEN
942: Process_statement_line;
943: ELSE
944: CE_JE_CREATION_ERRORS_PKG.insert_row(
945: CE_JE_CREATION.csh_statement_header_id,
946: CE_JE_CREATION.csl_statement_line_id,
947: 'CE_LINE_LOCKED',
948: NVL(FND_GLOBAL.user_id,-1),
949: sysdate,
942: Process_statement_line;
943: ELSE
944: CE_JE_CREATION_ERRORS_PKG.insert_row(
945: CE_JE_CREATION.csh_statement_header_id,
946: CE_JE_CREATION.csl_statement_line_id,
947: 'CE_LINE_LOCKED',
948: NVL(FND_GLOBAL.user_id,-1),
949: sysdate,
950: sysdate,
951: NVL(FND_GLOBAL.user_id,-1),
952: NVL(FND_GLOBAL.user_id,-1),
953: g_request_id);
954: END IF;
955: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
956: END IF;
957: END IF;
958: END LOOP; -- statement_lines_cursor
959: CLOSE statement_lines_cursor;
984: RAISE;
985: END create_journal;
986:
987:
988: END CE_JE_CREATION;