eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_JE_CREATION dependencies on CE_JE_CREATION

Line 1: PACKAGE BODY CE_JE_CREATION AS

1: PACKAGE BODY CE_JE_CREATION AS
2: /* $Header: cejecrnb.pls 120.27.12020000.2 2012/11/15 12:05:05 vnetan ship $ */
3:
4: --
5: -- Global Variables

Line 162: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id

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

Line 202: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN

198: log('>>Determine_cleared_date');
199: -- 12953296: Begin changes
200: -- 12953296: Current logic should not be used
201: /*
202: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
205: ELSE
206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;

Line 203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;

199: -- 12953296: Begin changes
200: -- 12953296: Current logic should not be used
201: /*
202: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
205: ELSE
206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);

Line 204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);

200: -- 12953296: Current logic should not be used
201: /*
202: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
205: ELSE
206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
208: END IF;

Line 206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;

202: IF CE_JE_CREATION.csl_effective_date IS NOT NULL THEN
203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
205: ELSE
206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
208: END IF;
209:
210: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN

Line 207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);

203: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
204: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
205: ELSE
206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
208: END IF;
209:
210: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN
211: p_result := 'S';

Line 210: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN

206: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
207: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
208: END IF;
209:
210: IF valid_accounting_date(CE_JE_CREATION.cf_cleared_date) THEN
211: p_result := 'S';
212: log('cleared date is in a open or future period');
213: ELSE
214: p_result := 'F';

Line 221: IF CE_JE_CREATION.csl_effective_date IS NOT NULL AND

217: **/
218:
219: -- 12953296: Check if value date is in open period
220: p_result := 'S';
221: IF CE_JE_CREATION.csl_effective_date IS NOT NULL AND
222: valid_accounting_date(CE_JE_CREATION.csl_effective_date)
223: THEN
224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);

Line 222: valid_accounting_date(CE_JE_CREATION.csl_effective_date)

218:
219: -- 12953296: Check if value date is in open period
220: p_result := 'S';
221: IF CE_JE_CREATION.csl_effective_date IS NOT NULL AND
222: valid_accounting_date(CE_JE_CREATION.csl_effective_date)
223: THEN
224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
226:

Line 224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;

220: p_result := 'S';
221: IF CE_JE_CREATION.csl_effective_date IS NOT NULL AND
222: valid_accounting_date(CE_JE_CREATION.csl_effective_date)
223: THEN
224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
226:
227: -- 12953296: Check if transaction date is in open period
228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)

Line 225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);

221: IF CE_JE_CREATION.csl_effective_date IS NOT NULL AND
222: valid_accounting_date(CE_JE_CREATION.csl_effective_date)
223: THEN
224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
226:
227: -- 12953296: Check if transaction date is in open period
228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)
229: THEN

Line 228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)

224: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_effective_date;
225: log('cleared date sl effective date: ' || CE_JE_CREATION.cf_cleared_date);
226:
227: -- 12953296: Check if transaction date is in open period
228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)
229: THEN
230: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
231: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
232:

Line 230: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;

226:
227: -- 12953296: Check if transaction date is in open period
228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)
229: THEN
230: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
231: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
232:
233: -- 12953296: Find the next open period after the trx date
234: ELSE

Line 231: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);

227: -- 12953296: Check if transaction date is in open period
228: ELSIF valid_accounting_date(CE_JE_CREATION.csl_trx_date)
229: THEN
230: CE_JE_CREATION.cf_cleared_date := CE_JE_CREATION.csl_trx_date;
231: log('cleared date sl trx date: ' || CE_JE_CREATION.cf_cleared_date);
232:
233: -- 12953296: Find the next open period after the trx date
234: ELSE
235: SELECT MIN(glp.start_date)

Line 236: INTO CE_JE_CREATION.cf_cleared_date

232:
233: -- 12953296: Find the next open period after the trx date
234: ELSE
235: SELECT MIN(glp.start_date)
236: INTO CE_JE_CREATION.cf_cleared_date
237: FROM gl_period_statuses glp,
238: ce_system_parameters SYS
239: WHERE glp.set_of_books_id = sys.set_of_books_id
240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /*13114107 fixed*/

Line 240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /13114107 fixed/

236: INTO CE_JE_CREATION.cf_cleared_date
237: FROM gl_period_statuses glp,
238: ce_system_parameters SYS
239: WHERE glp.set_of_books_id = sys.set_of_books_id
240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /*13114107 fixed*/
241: AND glp.closing_status IN ('O','F')
242: AND glp.application_id = 101
243: AND glp.adjustment_period_flag = 'N'
244: AND glp.start_date > NVL(CE_JE_CREATION.csl_effective_date,

Line 244: AND glp.start_date > NVL(CE_JE_CREATION.csl_effective_date,

240: AND sys.legal_entity_id = CE_JE_CREATION.ba_legal_entity_id /*13114107 fixed*/
241: AND glp.closing_status IN ('O','F')
242: AND glp.application_id = 101
243: AND glp.adjustment_period_flag = 'N'
244: AND glp.start_date > NVL(CE_JE_CREATION.csl_effective_date,
245: CE_JE_CREATION.csl_trx_date);
246:
247: IF CE_JE_CREATION.cf_cleared_date IS NOT NULL
248: THEN

Line 245: CE_JE_CREATION.csl_trx_date);

241: AND glp.closing_status IN ('O','F')
242: AND glp.application_id = 101
243: AND glp.adjustment_period_flag = 'N'
244: AND glp.start_date > NVL(CE_JE_CREATION.csl_effective_date,
245: CE_JE_CREATION.csl_trx_date);
246:
247: IF CE_JE_CREATION.cf_cleared_date IS NOT NULL
248: THEN
249: log('cleared date available period: ' || CE_JE_CREATION.cf_cleared_date);

Line 247: IF CE_JE_CREATION.cf_cleared_date IS NOT NULL

243: AND glp.adjustment_period_flag = 'N'
244: AND glp.start_date > NVL(CE_JE_CREATION.csl_effective_date,
245: CE_JE_CREATION.csl_trx_date);
246:
247: IF CE_JE_CREATION.cf_cleared_date IS NOT NULL
248: THEN
249: log('cleared date available period: ' || CE_JE_CREATION.cf_cleared_date);
250: ELSE
251: p_result := 'F';

Line 249: log('cleared date available period: ' || CE_JE_CREATION.cf_cleared_date);

245: CE_JE_CREATION.csl_trx_date);
246:
247: IF CE_JE_CREATION.cf_cleared_date IS NOT NULL
248: THEN
249: log('cleared date available period: ' || CE_JE_CREATION.cf_cleared_date);
250: ELSE
251: p_result := 'F';
252: log('There is no open or future GL period available for clearing this transaction.');
253: END IF;

Line 314: CE_JE_CREATION.cf_ledger_id := NULL;

310: | 16-SEP-2004 Shaik Vali Created |
311: --------------------------------------------------------------------- */
312: PROCEDURE Initialize_CF_data IS
313: BEGIN
314: CE_JE_CREATION.cf_ledger_id := NULL;
315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;

Line 315: CE_JE_CREATION.cf_legal_entity_id := NULL;

311: --------------------------------------------------------------------- */
312: PROCEDURE Initialize_CF_data IS
313: BEGIN
314: CE_JE_CREATION.cf_ledger_id := NULL;
315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;

Line 316: CE_JE_CREATION.cf_bank_account_id := NULL;

312: PROCEDURE Initialize_CF_data IS
313: BEGIN
314: CE_JE_CREATION.cf_ledger_id := NULL;
315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;

Line 317: CE_JE_CREATION.cf_direction := NULL;

313: BEGIN
314: CE_JE_CREATION.cf_ledger_id := NULL;
315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;

Line 318: CE_JE_CREATION.cf_currency_code := NULL;

314: CE_JE_CREATION.cf_ledger_id := NULL;
315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;

Line 319: CE_JE_CREATION.cf_cashflow_date := NULL;

315: CE_JE_CREATION.cf_legal_entity_id := NULL;
316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;

Line 320: CE_JE_CREATION.cf_cashflow_amount := NULL;

316: CE_JE_CREATION.cf_bank_account_id := NULL;
317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;

Line 321: CE_JE_CREATION.cf_description := NULL;

317: CE_JE_CREATION.cf_direction := NULL;
318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;

Line 322: CE_JE_CREATION.cf_trxn_reference_number := NULL;

318: CE_JE_CREATION.cf_currency_code := NULL;
319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;

Line 323: CE_JE_CREATION.cf_bank_trxn_number := NULL;

319: CE_JE_CREATION.cf_cashflow_date := NULL;
320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;

Line 324: CE_JE_CREATION.cf_source_trxn_type := NULL;

320: CE_JE_CREATION.cf_cashflow_amount := NULL;
321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;

Line 325: CE_JE_CREATION.cf_statement_line_id := NULL;

321: CE_JE_CREATION.cf_description := NULL;
322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;

Line 326: CE_JE_CREATION.cf_actual_value_date := NULL;

322: CE_JE_CREATION.cf_trxn_reference_number := NULL;
323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;

Line 327: CE_JE_CREATION.cf_offset_ccid := NULL;

323: CE_JE_CREATION.cf_bank_trxn_number := NULL;
324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;

Line 328: CE_JE_CREATION.cf_status_code := NULL;

324: CE_JE_CREATION.cf_source_trxn_type := NULL;
325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;

Line 329: CE_JE_CREATION.cf_cleared_date := NULL;

325: CE_JE_CREATION.cf_statement_line_id := NULL;
326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;

Line 330: CE_JE_CREATION.cf_cleared_amount := NULL;

326: CE_JE_CREATION.cf_actual_value_date := NULL;
327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;

Line 331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;

327: CE_JE_CREATION.cf_offset_ccid := NULL;
328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;

Line 332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;

328: CE_JE_CREATION.cf_status_code := NULL;
329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;

Line 333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;

329: CE_JE_CREATION.cf_cleared_date := NULL;
330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;

Line 334: CE_JE_CREATION.cf_base_amount := NULL;

330: CE_JE_CREATION.cf_cleared_amount := NULL;
331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;
338: CE_JE_CREATION.cf_customer_text := NULL;

Line 335: CE_JE_CREATION.cf_reference_text := NULL;

331: CE_JE_CREATION.cf_cleared_exchange_rate := NULL;
332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;
338: CE_JE_CREATION.cf_customer_text := NULL;
339:

Line 336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;

332: CE_JE_CREATION.cf_cleared_exchange_date := NULL;
333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;
338: CE_JE_CREATION.cf_customer_text := NULL;
339:
340: END Initialize_CF_data;

Line 337: CE_JE_CREATION.cf_bank_account_text := NULL;

333: CE_JE_CREATION.cf_cleared_exchange_rate_type := NULL;
334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;
338: CE_JE_CREATION.cf_customer_text := NULL;
339:
340: END Initialize_CF_data;
341:

Line 338: CE_JE_CREATION.cf_customer_text := NULL;

334: CE_JE_CREATION.cf_base_amount := NULL;
335: CE_JE_CREATION.cf_reference_text := NULL;
336: CE_JE_CREATION.cf_source_trxn_subtype_code_id := NULL;
337: CE_JE_CREATION.cf_bank_account_text := NULL;
338: CE_JE_CREATION.cf_customer_text := NULL;
339:
340: END Initialize_CF_data;
341:
342:

Line 358: IF (CE_JE_CREATION.sys_currency_code = CE_JE_CREATION.ba_currency_code) THEN

354: l_type VARCHAR2(30);
355: BEGIN
356: log('>> Currency_type');
357:
358: IF (CE_JE_CREATION.sys_currency_code = CE_JE_CREATION.ba_currency_code) THEN
359: IF (CE_JE_CREATION.ba_currency_code = NVL(CE_JE_CREATION.csl_currency_code, CE_JE_CREATION.csh_currency_code)) THEN
360: l_type := 'DOMESTIC';
361: ELSE
362: l_type := 'INTERNATIONAL';

Line 359: IF (CE_JE_CREATION.ba_currency_code = NVL(CE_JE_CREATION.csl_currency_code, CE_JE_CREATION.csh_currency_code)) THEN

355: BEGIN
356: log('>> Currency_type');
357:
358: IF (CE_JE_CREATION.sys_currency_code = CE_JE_CREATION.ba_currency_code) THEN
359: IF (CE_JE_CREATION.ba_currency_code = NVL(CE_JE_CREATION.csl_currency_code, CE_JE_CREATION.csh_currency_code)) THEN
360: l_type := 'DOMESTIC';
361: ELSE
362: l_type := 'INTERNATIONAL';
363: END IF;

Line 426: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN

422:
423: p_result := 'S';
424:
425: IF (Currency_type = 'FOREIGN') THEN
426: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
427: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN

Line 427: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;

423: p_result := 'S';
424:
425: IF (Currency_type = 'FOREIGN') THEN
426: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
427: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
431: -- currency_type when the exchange rate was given manually.

Line 428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;

424:
425: IF (Currency_type = 'FOREIGN') THEN
426: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
427: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
431: -- currency_type when the exchange rate was given manually.
432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;

Line 429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;

425: IF (Currency_type = 'FOREIGN') THEN
426: IF CE_JE_CREATION.csl_exchange_rate is NOT NULL THEN
427: CE_JE_CREATION.cf_cleared_exchange_rate := CE_JE_CREATION.csl_exchange_rate;
428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
431: -- currency_type when the exchange rate was given manually.
432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
433: ELSE

Line 432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;

428: CE_JE_CREATION.cf_cleared_exchange_date := CE_JE_CREATION.csl_exchange_rate_date;
429: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.csl_exchange_rate_type;
430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
431: -- currency_type when the exchange rate was given manually.
432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
433: ELSE
434: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
435: log('sys xchange_rate_date='||l_xchange_rate_date);
436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;

Line 434: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;

430: -- Bug 6980331: Cashflow amount was not being set for FOREIGN
431: -- currency_type when the exchange rate was given manually.
432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
433: ELSE
434: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
435: log('sys xchange_rate_date='||l_xchange_rate_date);
436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
437: IF (l_xchange_rate_date = 'CFD') THEN
438: CE_JE_CREATION.cf_cleared_exchange_date :=

Line 436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;

432: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
433: ELSE
434: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
435: log('sys xchange_rate_date='||l_xchange_rate_date);
436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
437: IF (l_xchange_rate_date = 'CFD') THEN
438: CE_JE_CREATION.cf_cleared_exchange_date :=
439: CE_JE_CREATION.csl_trx_date;
440: ELSIF (l_xchange_rate_date = 'BSG') THEN

Line 438: CE_JE_CREATION.cf_cleared_exchange_date :=

434: l_xchange_rate_date := CE_JE_CREATION.sys_exchange_rate_date;
435: log('sys xchange_rate_date='||l_xchange_rate_date);
436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
437: IF (l_xchange_rate_date = 'CFD') THEN
438: CE_JE_CREATION.cf_cleared_exchange_date :=
439: CE_JE_CREATION.csl_trx_date;
440: ELSIF (l_xchange_rate_date = 'BSG') THEN
441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;

Line 439: CE_JE_CREATION.csl_trx_date;

435: log('sys xchange_rate_date='||l_xchange_rate_date);
436: CE_JE_CREATION.cf_cleared_exchange_rate_type := CE_JE_CREATION.sys_exchange_rate_type;
437: IF (l_xchange_rate_date = 'CFD') THEN
438: CE_JE_CREATION.cf_cleared_exchange_date :=
439: CE_JE_CREATION.csl_trx_date;
440: ELSIF (l_xchange_rate_date = 'BSG') THEN
441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;
443: ELSIF (l_xchange_rate_date = 'CLD') THEN

Line 441: CE_JE_CREATION.cf_cleared_exchange_date :=

437: IF (l_xchange_rate_date = 'CFD') THEN
438: CE_JE_CREATION.cf_cleared_exchange_date :=
439: CE_JE_CREATION.csl_trx_date;
440: ELSIF (l_xchange_rate_date = 'BSG') THEN
441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;
443: ELSIF (l_xchange_rate_date = 'CLD') THEN
444: CE_JE_CREATION.cf_cleared_exchange_date :=
445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been

Line 442: CE_JE_CREATION.cf_cleared_date;

438: CE_JE_CREATION.cf_cleared_exchange_date :=
439: CE_JE_CREATION.csl_trx_date;
440: ELSIF (l_xchange_rate_date = 'BSG') THEN
441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;
443: ELSIF (l_xchange_rate_date = 'CLD') THEN
444: CE_JE_CREATION.cf_cleared_exchange_date :=
445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
446: -- determined at this point.

Line 444: CE_JE_CREATION.cf_cleared_exchange_date :=

440: ELSIF (l_xchange_rate_date = 'BSG') THEN
441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;
443: ELSIF (l_xchange_rate_date = 'CLD') THEN
444: CE_JE_CREATION.cf_cleared_exchange_date :=
445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
446: -- determined at this point.
447: ELSIF (l_xchange_rate_date = 'BSD') THEN
448: CE_JE_CREATION.cf_cleared_exchange_date :=

Line 445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been

441: CE_JE_CREATION.cf_cleared_exchange_date :=
442: CE_JE_CREATION.cf_cleared_date;
443: ELSIF (l_xchange_rate_date = 'CLD') THEN
444: CE_JE_CREATION.cf_cleared_exchange_date :=
445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
446: -- determined at this point.
447: ELSIF (l_xchange_rate_date = 'BSD') THEN
448: CE_JE_CREATION.cf_cleared_exchange_date :=
449: CE_JE_CREATION.csh_statement_date;

Line 448: CE_JE_CREATION.cf_cleared_exchange_date :=

444: CE_JE_CREATION.cf_cleared_exchange_date :=
445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
446: -- determined at this point.
447: ELSIF (l_xchange_rate_date = 'BSD') THEN
448: CE_JE_CREATION.cf_cleared_exchange_date :=
449: CE_JE_CREATION.csh_statement_date;
450: ELSE
451: -- error: exchange date cannot be determined
452: p_result := 'F';

Line 449: CE_JE_CREATION.csh_statement_date;

445: CE_JE_CREATION.cf_cleared_date; -- CE_JE_CREATION.cf_cleared_date has already been
446: -- determined at this point.
447: ELSIF (l_xchange_rate_date = 'BSD') THEN
448: CE_JE_CREATION.cf_cleared_exchange_date :=
449: CE_JE_CREATION.csh_statement_date;
450: ELSE
451: -- error: exchange date cannot be determined
452: p_result := 'F';
453: END IF;

Line 458: log('ba_curr='||ce_je_Creation.ba_currency_code);

454:
455: IF (p_result <> 'F') THEN
456: log('calling gl_currency_api');
457: log('>>Determine_exchange_info');
458: log('ba_curr='||ce_je_Creation.ba_currency_code);
459: log('sys_curr='||ce_je_creation.sys_currency_code);
460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);

Line 459: log('sys_curr='||ce_je_creation.sys_currency_code);

455: IF (p_result <> 'F') THEN
456: log('calling gl_currency_api');
457: log('>>Determine_exchange_info');
458: log('ba_curr='||ce_je_Creation.ba_currency_code);
459: log('sys_curr='||ce_je_creation.sys_currency_code);
460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:

Line 460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);

456: log('calling gl_currency_api');
457: log('>>Determine_exchange_info');
458: log('ba_curr='||ce_je_Creation.ba_currency_code);
459: log('sys_curr='||ce_je_creation.sys_currency_code);
460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=

Line 461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);

457: log('>>Determine_exchange_info');
458: log('ba_curr='||ce_je_Creation.ba_currency_code);
459: log('sys_curr='||ce_je_creation.sys_currency_code);
460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,

Line 462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);

458: log('ba_curr='||ce_je_Creation.ba_currency_code);
459: log('sys_curr='||ce_je_creation.sys_currency_code);
460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,

Line 464: CE_JE_CREATION.cf_cleared_exchange_rate :=

460: log('cf_clared_ex_date='||ce_je_creation.cf_cleared_exchange_date);
461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);

Line 465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,

461: log('stmt_line_id='||ce_je_creation.csl_statement_line_id);
462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);
469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;

Line 466: CE_JE_CREATION.sys_currency_code,

462: log('cf_cleared_ex_type='||ce_je_creation.cf_cleared_exchange_rate_type);
463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);
469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
470: END IF;

Line 467: CE_JE_CREATION.cf_cleared_exchange_date,

463:
464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);
469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
470: END IF;
471: END IF;

Line 468: CE_JE_CREATION.cf_cleared_exchange_rate_type);

464: CE_JE_CREATION.cf_cleared_exchange_rate :=
465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);
469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
470: END IF;
471: END IF;
472: ELSE -- domestic and international

Line 469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;

465: gl_currency_api.get_rate(CE_JE_CREATION.ba_currency_code,
466: CE_JE_CREATION.sys_currency_code,
467: CE_JE_CREATION.cf_cleared_exchange_date,
468: CE_JE_CREATION.cf_cleared_exchange_rate_type);
469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
470: END IF;
471: END IF;
472: ELSE -- domestic and international
473: CE_JE_CREATION.cf_cleared_exchange_rate := null;

Line 473: CE_JE_CREATION.cf_cleared_exchange_rate := null;

469: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
470: END IF;
471: END IF;
472: ELSE -- domestic and international
473: CE_JE_CREATION.cf_cleared_exchange_rate := null;
474: CE_JE_CREATION.cf_cleared_exchange_date := null;
475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN

Line 474: CE_JE_CREATION.cf_cleared_exchange_date := null;

470: END IF;
471: END IF;
472: ELSE -- domestic and international
473: CE_JE_CREATION.cf_cleared_exchange_rate := null;
474: CE_JE_CREATION.cf_cleared_exchange_date := null;
475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=

Line 475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;

471: END IF;
472: ELSE -- domestic and international
473: CE_JE_CREATION.cf_cleared_exchange_rate := null;
474: CE_JE_CREATION.cf_cleared_exchange_date := null;
475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=
479: CE_JE_CREATION.csl_original_amount;

Line 478: CE_JE_CREATION.cf_cashflow_amount :=

474: CE_JE_CREATION.cf_cleared_exchange_date := null;
475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=
479: CE_JE_CREATION.csl_original_amount;
480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:

Line 479: CE_JE_CREATION.csl_original_amount;

475: CE_JE_CREATION.cf_cleared_exchange_rate_type := null;
476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=
479: CE_JE_CREATION.csl_original_amount;
480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:
483: --bug5328385

Line 480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then

476: --Bug 5016835
477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=
479: CE_JE_CREATION.csl_original_amount;
480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:
483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN

Line 481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN

477: IF (currency_type = 'INTERNATIONAL') THEN
478: CE_JE_CREATION.cf_cashflow_amount :=
479: CE_JE_CREATION.csl_original_amount;
480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:
483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(

Line 484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN

480: IF (CE_JE_CREATION.cf_Cashflow_amount is null) then
481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:
483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,

Line 485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(

481: IF (CE_JE_CREATION.csl_exchange_rate IS NOT NULL) THEN
482:
483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),

Line 486: CE_JE_CREATION.sys_currency_code,

482:
483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,

Line 487: CE_JE_CREATION.csl_currency_code,

483: --bug5328385
484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);

Line 488: nvl(CE_JE_CREATION.csl_exchange_rate_date,

484: If (CE_JE_CREATION.csl_exchange_rate_type <> 'User') THEN
485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);
492: ELSE

Line 489: CE_JE_CREATION.csl_trx_date),

485: CE_JE_CREATION.cf_cashflow_amount:= gl_currency_api.convert_amount(
486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);
492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,

Line 490: CE_JE_CREATION.csl_exchange_rate_type,

486: CE_JE_CREATION.sys_currency_code,
487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);
492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
494: precision, ext_precision, min_acct_unit);

Line 491: CE_JE_CREATION.csl_amount);

487: CE_JE_CREATION.csl_currency_code,
488: nvl(CE_JE_CREATION.csl_exchange_rate_date,
489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);
492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
494: precision, ext_precision, min_acct_unit);
495: CE_JE_CREATION.cf_cashflow_amount :=

Line 493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,

489: CE_JE_CREATION.csl_trx_date),
490: CE_JE_CREATION.csl_exchange_rate_type,
491: CE_JE_CREATION.csl_amount);
492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
494: precision, ext_precision, min_acct_unit);
495: CE_JE_CREATION.cf_cashflow_amount :=
496: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
497: END IF;

Line 495: CE_JE_CREATION.cf_cashflow_amount :=

491: CE_JE_CREATION.csl_amount);
492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
494: precision, ext_precision, min_acct_unit);
495: CE_JE_CREATION.cf_cashflow_amount :=
496: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
497: END IF;
498: ELSE
499: p_result := 'F';

Line 496: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);

492: ELSE
493: fnd_currency.get_info(CE_JE_CREATION.csl_currency_code,
494: precision, ext_precision, min_acct_unit);
495: CE_JE_CREATION.cf_cashflow_amount :=
496: round(CE_JE_CREATION.csl_amount/CE_JE_CREATION.csl_exchange_rate,precision);
497: END IF;
498: ELSE
499: p_result := 'F';
500: END IF;

Line 503: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;

499: p_result := 'F';
500: END IF;
501: END IF;
502: ELSE
503: CE_JE_CREATION.cf_cashflow_amount := CE_JE_CREATION.csl_amount;
504: END IF;
505: END IF;
506: log('< 507: EXCEPTION

Line 532: CE_JE_CREATION.cf_base_amount :=

528: PROCEDURE Determine_base_amount IS
529: BEGIN
530: log('>>Determine_base_amount');
531: IF Currency_type = 'FOREIGN' THEN
532: CE_JE_CREATION.cf_base_amount :=
533: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
534: ELSE
535: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
536: END IF;

Line 533: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;

529: BEGIN
530: log('>>Determine_base_amount');
531: IF Currency_type = 'FOREIGN' THEN
532: CE_JE_CREATION.cf_base_amount :=
533: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
534: ELSE
535: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
536: END IF;
537: log('>>Determine_base_amount');

Line 535: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;

531: IF Currency_type = 'FOREIGN' THEN
532: CE_JE_CREATION.cf_base_amount :=
533: CE_JE_CREATION.csl_amount / CE_JE_CREATION.cf_cleared_exchange_rate;
534: ELSE
535: CE_JE_CREATION.cf_base_amount := CE_JE_CREATION.csl_amount;
536: END IF;
537: log('>>Determine_base_amount');
538: END Determine_base_amount;
539:

Line 554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;

550: --------------------------------------------------------------------- */
551: PROCEDURE Populate_CF_data IS
552: BEGIN
553: log('>> Populate_CF_data');
554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN

Line 555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;

551: PROCEDURE Populate_CF_data IS
552: BEGIN
553: log('>> Populate_CF_data');
554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';

Line 556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;

552: BEGIN
553: log('>> Populate_CF_data');
554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or

Line 557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or

553: log('>> Populate_CF_data');
554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN

Line 558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN

554: CE_JE_CREATION.cf_ledger_id := CE_JE_CREATION.sys_sob_id;
555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';

Line 559: CE_JE_CREATION.cf_direction := 'RECEIPT';

555: CE_JE_CREATION.cf_legal_entity_id := CE_JE_CREATION.ba_legal_entity_id;
556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';
563: END IF;

Line 560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or

556: CE_JE_CREATION.cf_bank_account_id := CE_JE_CREATION.csh_bank_account_id;
557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';
563: END IF;
564: IF currency_type = 'INTERNATIONAL' THEN

Line 561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN

557: IF (CE_JE_CREATION.csl_trx_type = 'CREDIT') or
558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';
563: END IF;
564: IF currency_type = 'INTERNATIONAL' THEN
565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;

Line 562: CE_JE_CREATION.cf_direction := 'PAYMENT';

558: (CE_JE_CREATION.csl_trx_type = 'MISC_CREDIT') THEN
559: CE_JE_CREATION.cf_direction := 'RECEIPT';
560: ELSIF (CE_JE_CREATION.csl_trx_type = 'DEBIT') or
561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';
563: END IF;
564: IF currency_type = 'INTERNATIONAL' THEN
565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
566: ELSE

Line 565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;

561: (CE_JE_CREATION.csl_trx_type = 'MISC_DEBIT') THEN
562: CE_JE_CREATION.cf_direction := 'PAYMENT';
563: END IF;
564: IF currency_type = 'INTERNATIONAL' THEN
565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
566: ELSE
567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;

Line 567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;

563: END IF;
564: IF currency_type = 'INTERNATIONAL' THEN
565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
566: ELSE
567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;

Line 569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;

565: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csl_currency_code;
566: ELSE
567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;

Line 570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;

566: ELSE
567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,

Line 571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;

567: CE_JE_CREATION.cf_currency_code := CE_JE_CREATION.csh_currency_code;
568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);

Line 572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';

568: END IF;
569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;

Line 573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;

569: CE_JE_CREATION.cf_cashflow_date := CE_JE_CREATION.csl_trx_date;
570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';

Line 574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,

570: CE_JE_CREATION.cf_description := CE_JE_CREATION.csl_trx_text;
571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;

Line 575: CE_JE_CREATION.csl_trx_date);

571: CE_JE_CREATION.cf_bank_trxn_number := CE_JE_CREATION.csl_bank_trx_number;
572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;

Line 576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;

572: CE_JE_CREATION.cf_source_trxn_type := 'STMT';
573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;

Line 577: CE_JE_CREATION.cf_status_code := 'CLEARED';

573: CE_JE_CREATION.cf_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;

Line 578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;

574: CE_JE_CREATION.cf_actual_value_date := NVL(CE_JE_CREATION.csl_effective_date,
575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;

Line 579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;

575: CE_JE_CREATION.csl_trx_date);
576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
583:

Line 580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;

576: CE_JE_CREATION.cf_offset_ccid := CE_JE_CREATION.jem_gl_account_ccid;
577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
583:
584: log('<< Populate_CF_data');

Line 581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;

577: CE_JE_CREATION.cf_status_code := 'CLEARED';
578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
583:
584: log('<< Populate_CF_data');
585: EXCEPTION

Line 582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;

578: CE_JE_CREATION.cf_cleared_amount := CE_JE_CREATION.csl_amount;
579: CE_JE_CREATION.cf_source_trxn_subtype_code_id := CE_JE_CREATION.jem_trxn_subtype_code_id;
580: CE_JE_CREATION.cf_reference_text := CE_JE_CREATION.jem_reference_txt;
581: CE_JE_CREATION.cf_bank_account_text := CE_JE_CREATION.csl_bank_account_text;
582: CE_JE_CREATION.cf_customer_text := CE_JE_CREATION.csl_customer_text;
583:
584: log('<< Populate_CF_data');
585: EXCEPTION
586: WHEN OTHERS THEN

Line 609: CE_JE_CREATION.cf_ledger_id,

605: log('>> Populate_CF_table');
606: CE_CASHFLOWS_PKG.insert_row (
607: x_rowid,
608: x_cashflow_id,
609: CE_JE_CREATION.cf_ledger_id,
610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,

Line 610: CE_JE_CREATION.cf_legal_entity_id,

606: CE_CASHFLOWS_PKG.insert_row (
607: x_rowid,
608: x_cashflow_id,
609: CE_JE_CREATION.cf_ledger_id,
610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,

Line 611: CE_JE_CREATION.cf_bank_account_id,

607: x_rowid,
608: x_cashflow_id,
609: CE_JE_CREATION.cf_ledger_id,
610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,

Line 612: CE_JE_CREATION.cf_direction,

608: x_cashflow_id,
609: CE_JE_CREATION.cf_ledger_id,
610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,

Line 613: CE_JE_CREATION.cf_currency_code,

609: CE_JE_CREATION.cf_ledger_id,
610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,
617: CE_JE_CREATION.cf_description,

Line 614: CE_JE_CREATION.cf_cashflow_date,

610: CE_JE_CREATION.cf_legal_entity_id,
611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,
617: CE_JE_CREATION.cf_description,
618: null, -- cashflow_exchange_rate

Line 615: CE_JE_CREATION.cf_cashflow_amount,

611: CE_JE_CREATION.cf_bank_account_id,
612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,
617: CE_JE_CREATION.cf_description,
618: null, -- cashflow_exchange_rate
619: null, -- cashflow_exchange_date

Line 616: CE_JE_CREATION.cf_base_amount,

612: CE_JE_CREATION.cf_direction,
613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,
617: CE_JE_CREATION.cf_description,
618: null, -- cashflow_exchange_rate
619: null, -- cashflow_exchange_date
620: null, -- cashflow_exchange_rate_type

Line 617: CE_JE_CREATION.cf_description,

613: CE_JE_CREATION.cf_currency_code,
614: CE_JE_CREATION.cf_cashflow_date,
615: CE_JE_CREATION.cf_cashflow_amount,
616: CE_JE_CREATION.cf_base_amount,
617: CE_JE_CREATION.cf_description,
618: null, -- cashflow_exchange_rate
619: null, -- cashflow_exchange_date
620: null, -- cashflow_exchange_rate_type
621: CE_JE_CREATION.cf_trxn_reference_number,

Line 621: CE_JE_CREATION.cf_trxn_reference_number,

617: CE_JE_CREATION.cf_description,
618: null, -- cashflow_exchange_rate
619: null, -- cashflow_exchange_date
620: null, -- cashflow_exchange_rate_type
621: CE_JE_CREATION.cf_trxn_reference_number,
622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,

Line 622: CE_JE_CREATION.cf_bank_trxn_number,

618: null, -- cashflow_exchange_rate
619: null, -- cashflow_exchange_date
620: null, -- cashflow_exchange_rate_type
621: CE_JE_CREATION.cf_trxn_reference_number,
622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,

Line 623: CE_JE_CREATION.cf_source_trxn_type,

619: null, -- cashflow_exchange_date
620: null, -- cashflow_exchange_rate_type
621: CE_JE_CREATION.cf_trxn_reference_number,
622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id

Line 624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,

620: null, -- cashflow_exchange_rate_type
621: CE_JE_CREATION.cf_trxn_reference_number,
622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id

Line 625: CE_JE_CREATION.cf_statement_line_id,

621: CE_JE_CREATION.cf_trxn_reference_number,
622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,

Line 626: CE_JE_CREATION.cf_actual_value_date,

622: CE_JE_CREATION.cf_bank_trxn_number,
623: CE_JE_CREATION.cf_source_trxn_type,
624: CE_JE_CREATION.cf_source_trxn_subtype_code_id,
625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,

Line 629: CE_JE_CREATION.cf_offset_ccid,

625: CE_JE_CREATION.cf_statement_line_id,
626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,

Line 630: CE_JE_CREATION.cf_status_code,

626: CE_JE_CREATION.cf_actual_value_date,
627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,

Line 631: CE_JE_CREATION.cf_cleared_date,

627: null, -- counterparty_party_id
628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,
635: CE_JE_CREATION.cf_cleared_exchange_rate_type,

Line 632: CE_JE_CREATION.cf_cleared_amount,

628: null, -- counterparty_bank_account_id
629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,
635: CE_JE_CREATION.cf_cleared_exchange_rate_type,
636: null, -- clearing_charges_amount

Line 633: CE_JE_CREATION.cf_cleared_exchange_rate,

629: CE_JE_CREATION.cf_offset_ccid,
630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,
635: CE_JE_CREATION.cf_cleared_exchange_rate_type,
636: null, -- clearing_charges_amount
637: null, -- clearing_error_amount

Line 634: CE_JE_CREATION.cf_cleared_exchange_date,

630: CE_JE_CREATION.cf_status_code,
631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,
635: CE_JE_CREATION.cf_cleared_exchange_rate_type,
636: null, -- clearing_charges_amount
637: null, -- clearing_error_amount
638: null, -- cleared_by_flag

Line 635: CE_JE_CREATION.cf_cleared_exchange_rate_type,

631: CE_JE_CREATION.cf_cleared_date,
632: CE_JE_CREATION.cf_cleared_amount,
633: CE_JE_CREATION.cf_cleared_exchange_rate,
634: CE_JE_CREATION.cf_cleared_exchange_date,
635: CE_JE_CREATION.cf_cleared_exchange_rate_type,
636: null, -- clearing_charges_amount
637: null, -- clearing_error_amount
638: null, -- cleared_by_flag
639: CE_JE_CREATION.cf_reference_text,

Line 639: CE_JE_CREATION.cf_reference_text,

635: CE_JE_CREATION.cf_cleared_exchange_rate_type,
636: null, -- clearing_charges_amount
637: null, -- clearing_error_amount
638: null, -- cleared_by_flag
639: CE_JE_CREATION.cf_reference_text,
640: CE_JE_CREATION.cf_bank_account_text,
641: CE_JE_CREATION.cf_customer_text,
642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,

Line 640: CE_JE_CREATION.cf_bank_account_text,

636: null, -- clearing_charges_amount
637: null, -- clearing_error_amount
638: null, -- cleared_by_flag
639: CE_JE_CREATION.cf_reference_text,
640: CE_JE_CREATION.cf_bank_account_text,
641: CE_JE_CREATION.cf_customer_text,
642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,
644: NVL(FND_GLOBAL.user_id,-1),

Line 641: CE_JE_CREATION.cf_customer_text,

637: null, -- clearing_error_amount
638: null, -- cleared_by_flag
639: CE_JE_CREATION.cf_reference_text,
640: CE_JE_CREATION.cf_bank_account_text,
641: CE_JE_CREATION.cf_customer_text,
642: NVL(FND_GLOBAL.user_id,-1),
643: sysdate,
644: NVL(FND_GLOBAL.user_id,-1),
645: sysdate,

Line 675: WHERE rowid = CE_JE_CREATION.csl_rowid

671: SELECT 1
672: INTO l_dummy
673: FROM
674: ce_statement_lines
675: WHERE rowid = CE_JE_CREATION.csl_rowid
676: FOR UPDATE OF je_status_flag NOWAIT;
677:
678: RETURN true;
679: log('<

Line 735: Validate_GL_account(CE_JE_CREATION.jem_gl_account_ccid,l_result);

731: Determine_exchange_info(l_result);
732: IF(l_result = 'S') THEN
733: Validate_Multi_Currency(l_result);
734: IF (l_result = 'S') THEN
735: Validate_GL_account(CE_JE_CREATION.jem_gl_account_ccid,l_result);
736: IF(l_result = 'S') THEN
737: Determine_base_amount;
738: --
739: -- validations are done. now

Line 745: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

741: -- the stmt line.
742: Populate_CF_data;
743: Populate_CF_table(l_cashflow_id);
744: -- insert cashflow_id into statement_line table
745: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
746: l_cashflow_id,'S');
747: -- create accounting event
748: CE_XLA_ACCT_EVENTS_PKG.create_event(l_cashflow_id,
749: 'CE_STMT_RECORDED',

Line 753: CE_JE_CREATION_ERRORS_PKG.insert_row(

749: 'CE_STMT_RECORDED',
750: null);
751: /* Bug 4997215 -- populated error messages table even for
752: successes with a dummy error message.*/
753: CE_JE_CREATION_ERRORS_PKG.insert_row(
754: CE_JE_CREATION.csh_statement_header_id,
755: CE_JE_CREATION.csl_statement_line_id,
756: 'DUMMY',
757: NVL(FND_GLOBAL.user_id,-1),

Line 754: CE_JE_CREATION.csh_statement_header_id,

750: null);
751: /* Bug 4997215 -- populated error messages table even for
752: successes with a dummy error message.*/
753: CE_JE_CREATION_ERRORS_PKG.insert_row(
754: CE_JE_CREATION.csh_statement_header_id,
755: CE_JE_CREATION.csl_statement_line_id,
756: 'DUMMY',
757: NVL(FND_GLOBAL.user_id,-1),
758: sysdate,

Line 755: CE_JE_CREATION.csl_statement_line_id,

751: /* Bug 4997215 -- populated error messages table even for
752: successes with a dummy error message.*/
753: CE_JE_CREATION_ERRORS_PKG.insert_row(
754: CE_JE_CREATION.csh_statement_header_id,
755: CE_JE_CREATION.csl_statement_line_id,
756: 'DUMMY',
757: NVL(FND_GLOBAL.user_id,-1),
758: sysdate,
759: sysdate,

Line 765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

761: NVL(FND_GLOBAL.user_id,-1),
762: g_request_id);
763:
764: ELSE -- Invalid gl account
765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
766: null,'E');
767: CE_JE_CREATION_ERRORS_PKG.insert_row(
768: CE_JE_CREATION.csh_statement_header_id,
769: CE_JE_CREATION.csl_statement_line_id,

Line 767: CE_JE_CREATION_ERRORS_PKG.insert_row(

763:
764: ELSE -- Invalid gl account
765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
766: null,'E');
767: CE_JE_CREATION_ERRORS_PKG.insert_row(
768: CE_JE_CREATION.csh_statement_header_id,
769: CE_JE_CREATION.csl_statement_line_id,
770: 'CE_INVALID_GL_ACCOUNT',
771: NVL(FND_GLOBAL.user_id,-1),

Line 768: CE_JE_CREATION.csh_statement_header_id,

764: ELSE -- Invalid gl account
765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
766: null,'E');
767: CE_JE_CREATION_ERRORS_PKG.insert_row(
768: CE_JE_CREATION.csh_statement_header_id,
769: CE_JE_CREATION.csl_statement_line_id,
770: 'CE_INVALID_GL_ACCOUNT',
771: NVL(FND_GLOBAL.user_id,-1),
772: sysdate,

Line 769: CE_JE_CREATION.csl_statement_line_id,

765: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
766: null,'E');
767: CE_JE_CREATION_ERRORS_PKG.insert_row(
768: CE_JE_CREATION.csh_statement_header_id,
769: CE_JE_CREATION.csl_statement_line_id,
770: 'CE_INVALID_GL_ACCOUNT',
771: NVL(FND_GLOBAL.user_id,-1),
772: sysdate,
773: sysdate,

Line 780: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

776: g_request_id);
777: log('invalid gl account');
778: END IF;
779: ELSE --bank account not multi currency enabled
780: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
781: null,'E');
782: CE_JE_CREATION_ERRORS_PKG.insert_row(
783: CE_JE_CREATION.csh_statement_header_id,
784: CE_JE_CREATION.csl_statement_line_id,

Line 782: CE_JE_CREATION_ERRORS_PKG.insert_row(

778: END IF;
779: ELSE --bank account not multi currency enabled
780: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
781: null,'E');
782: CE_JE_CREATION_ERRORS_PKG.insert_row(
783: CE_JE_CREATION.csh_statement_header_id,
784: CE_JE_CREATION.csl_statement_line_id,
785: 'CE_NOT_MULTI_CURR',
786: NVL(FND_GLOBAL.user_id,-1),

Line 783: CE_JE_CREATION.csh_statement_header_id,

779: ELSE --bank account not multi currency enabled
780: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
781: null,'E');
782: CE_JE_CREATION_ERRORS_PKG.insert_row(
783: CE_JE_CREATION.csh_statement_header_id,
784: CE_JE_CREATION.csl_statement_line_id,
785: 'CE_NOT_MULTI_CURR',
786: NVL(FND_GLOBAL.user_id,-1),
787: sysdate,

Line 784: CE_JE_CREATION.csl_statement_line_id,

780: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
781: null,'E');
782: CE_JE_CREATION_ERRORS_PKG.insert_row(
783: CE_JE_CREATION.csh_statement_header_id,
784: CE_JE_CREATION.csl_statement_line_id,
785: 'CE_NOT_MULTI_CURR',
786: NVL(FND_GLOBAL.user_id,-1),
787: sysdate,
788: sysdate,

Line 794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

790: NVL(FND_GLOBAL.user_id,-1),
791: g_request_id);
792: END IF;
793: ELSE -- exchange info cannot be determined
794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
795: null,'E');
796: CE_JE_CREATION_ERRORS_PKG.insert_row(
797: CE_JE_CREATION.csh_statement_header_id,
798: CE_JE_CREATION.csl_statement_line_id,

Line 796: CE_JE_CREATION_ERRORS_PKG.insert_row(

792: END IF;
793: ELSE -- exchange info cannot be determined
794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
795: null,'E');
796: CE_JE_CREATION_ERRORS_PKG.insert_row(
797: CE_JE_CREATION.csh_statement_header_id,
798: CE_JE_CREATION.csl_statement_line_id,
799: 'CE_MISSING_USER_RATE',
800: NVL(FND_GLOBAL.user_id,-1),

Line 797: CE_JE_CREATION.csh_statement_header_id,

793: ELSE -- exchange info cannot be determined
794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
795: null,'E');
796: CE_JE_CREATION_ERRORS_PKG.insert_row(
797: CE_JE_CREATION.csh_statement_header_id,
798: CE_JE_CREATION.csl_statement_line_id,
799: 'CE_MISSING_USER_RATE',
800: NVL(FND_GLOBAL.user_id,-1),
801: sysdate,

Line 798: CE_JE_CREATION.csl_statement_line_id,

794: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
795: null,'E');
796: CE_JE_CREATION_ERRORS_PKG.insert_row(
797: CE_JE_CREATION.csh_statement_header_id,
798: CE_JE_CREATION.csl_statement_line_id,
799: 'CE_MISSING_USER_RATE',
800: NVL(FND_GLOBAL.user_id,-1),
801: sysdate,
802: sysdate,

Line 809: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,

805: g_request_id);
806: log('Exchange info cannot be determined.');
807: END IF;
808: ELSE -- invalid cleared date
809: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
810: null,'E');
811: CE_JE_CREATION_ERRORS_PKG.insert_row(
812: CE_JE_CREATION.csh_statement_header_id,
813: CE_JE_CREATION.csl_statement_line_id,

Line 811: CE_JE_CREATION_ERRORS_PKG.insert_row(

807: END IF;
808: ELSE -- invalid cleared date
809: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
810: null,'E');
811: CE_JE_CREATION_ERRORS_PKG.insert_row(
812: CE_JE_CREATION.csh_statement_header_id,
813: CE_JE_CREATION.csl_statement_line_id,
814: 'CE_INVALID_CLEARED_DATE',
815: NVL(FND_GLOBAL.user_id,-1),

Line 812: CE_JE_CREATION.csh_statement_header_id,

808: ELSE -- invalid cleared date
809: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
810: null,'E');
811: CE_JE_CREATION_ERRORS_PKG.insert_row(
812: CE_JE_CREATION.csh_statement_header_id,
813: CE_JE_CREATION.csl_statement_line_id,
814: 'CE_INVALID_CLEARED_DATE',
815: NVL(FND_GLOBAL.user_id,-1),
816: sysdate,

Line 813: CE_JE_CREATION.csl_statement_line_id,

809: Update_statement_line(CE_JE_CREATION.csl_statement_line_id,
810: null,'E');
811: CE_JE_CREATION_ERRORS_PKG.insert_row(
812: CE_JE_CREATION.csh_statement_header_id,
813: CE_JE_CREATION.csl_statement_line_id,
814: 'CE_INVALID_CLEARED_DATE',
815: NVL(FND_GLOBAL.user_id,-1),
816: sysdate,
817: sysdate,

Line 881: CE_JE_CREATION.ba_legal_entity_id;

877: OPEN bank_branch_cursor(g_p_bank_branch_id,g_p_bank_account_id);
878: LOOP
879: FETCH bank_branch_cursor
880: INTO l_bank_account_id,
881: CE_JE_CREATION.ba_legal_entity_id;
882: EXIT WHEN bank_branch_cursor%NOTFOUND OR
883: bank_branch_cursor%NOTFOUND IS NULL;
884: BEGIN
885: SELECT sob.currency_code,

Line 891: CE_JE_CREATION.sys_currency_code,

887: sys.cashflow_exchange_rate_type,
888: --xle.ledger_id
889: sys.set_of_books_id
890: INTO
891: CE_JE_CREATION.sys_currency_code,
892: CE_JE_CREATION.sys_exchange_rate_date,
893: CE_JE_CREATION.sys_exchange_rate_type,
894: CE_JE_CREATION.sys_sob_id
895: FROM

Line 892: CE_JE_CREATION.sys_exchange_rate_date,

888: --xle.ledger_id
889: sys.set_of_books_id
890: INTO
891: CE_JE_CREATION.sys_currency_code,
892: CE_JE_CREATION.sys_exchange_rate_date,
893: CE_JE_CREATION.sys_exchange_rate_type,
894: CE_JE_CREATION.sys_sob_id
895: FROM
896: ce_system_parameters sys, -- change to base table per BH's request

Line 893: CE_JE_CREATION.sys_exchange_rate_type,

889: sys.set_of_books_id
890: INTO
891: CE_JE_CREATION.sys_currency_code,
892: CE_JE_CREATION.sys_exchange_rate_date,
893: CE_JE_CREATION.sys_exchange_rate_type,
894: CE_JE_CREATION.sys_sob_id
895: FROM
896: ce_system_parameters sys, -- change to base table per BH's request
897: gl_sets_of_books sob,

Line 894: CE_JE_CREATION.sys_sob_id

890: INTO
891: CE_JE_CREATION.sys_currency_code,
892: CE_JE_CREATION.sys_exchange_rate_date,
893: CE_JE_CREATION.sys_exchange_rate_type,
894: CE_JE_CREATION.sys_sob_id
895: FROM
896: ce_system_parameters sys, -- change to base table per BH's request
897: gl_sets_of_books sob,
898: ce_bank_accounts ba

Line 931: CE_JE_CREATION.csl_rowid,

927: --
928: OPEN statement_lines_cursor(l_statement_header_id);
929: LOOP
930: FETCH statement_lines_cursor INTO
931: CE_JE_CREATION.csl_rowid,
932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,

Line 932: CE_JE_CREATION.csl_statement_line_id,

928: OPEN statement_lines_cursor(l_statement_header_id);
929: LOOP
930: FETCH statement_lines_cursor INTO
931: CE_JE_CREATION.csl_rowid,
932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,

Line 933: CE_JE_CREATION.csl_trx_code_id,

929: LOOP
930: FETCH statement_lines_cursor INTO
931: CE_JE_CREATION.csl_rowid,
932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,

Line 934: CE_JE_CREATION.csl_amount,

930: FETCH statement_lines_cursor INTO
931: CE_JE_CREATION.csl_rowid,
932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,

Line 935: CE_JE_CREATION.csl_status,

931: CE_JE_CREATION.csl_rowid,
932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,

Line 936: CE_JE_CREATION.csl_currency_code,

932: CE_JE_CREATION.csl_statement_line_id,
933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,

Line 937: CE_JE_CREATION.csh_currency_code,

933: CE_JE_CREATION.csl_trx_code_id,
934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,

Line 938: CE_JE_CREATION.csh_statement_date,

934: CE_JE_CREATION.csl_amount,
935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,

Line 939: CE_JE_CREATION.csh_statement_gl_date,

935: CE_JE_CREATION.csl_status,
936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,

Line 940: CE_JE_CREATION.ba_currency_code,

936: CE_JE_CREATION.csl_currency_code,
937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,

Line 941: CE_JE_CREATION.csl_effective_date,

937: CE_JE_CREATION.csh_currency_code,
938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,

Line 942: CE_JE_CREATION.csl_trx_date,

938: CE_JE_CREATION.csh_statement_date,
939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,

Line 943: CE_JE_CREATION.csl_trx_type,

939: CE_JE_CREATION.csh_statement_gl_date,
940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,

Line 944: CE_JE_CREATION.csl_original_amount,

940: CE_JE_CREATION.ba_currency_code,
941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,

Line 945: CE_JE_CREATION.csl_exchange_rate_type,

941: CE_JE_CREATION.csl_effective_date,
942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,

Line 946: CE_JE_CREATION.csl_exchange_rate,

942: CE_JE_CREATION.csl_trx_date,
943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,

Line 947: CE_JE_CREATION.csl_exchange_rate_date,

943: CE_JE_CREATION.csl_trx_type,
944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,

Line 948: --CE_JE_CREATION.csl_je_status_flag,

944: CE_JE_CREATION.csl_original_amount,
945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,

Line 949: CE_JE_CREATION.csl_trx_text,

945: CE_JE_CREATION.csl_exchange_rate_type,
946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,

Line 950: CE_JE_CREATION.csh_statement_header_id,

946: CE_JE_CREATION.csl_exchange_rate,
947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,

Line 951: CE_JE_CREATION.csh_bank_account_id,

947: CE_JE_CREATION.csl_exchange_rate_date,
948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,

Line 952: CE_JE_CREATION.jem_gl_account_ccid,

948: --CE_JE_CREATION.csl_je_status_flag,
949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,

Line 953: CE_JE_CREATION.jem_search_string_txt,

949: CE_JE_CREATION.csl_trx_text,
950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,

Line 954: CE_JE_CREATION.jem_reference_txt,

950: CE_JE_CREATION.csh_statement_header_id,
951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,

Line 955: --CE_JE_CREATION.csh_bank_account_ccid,

951: CE_JE_CREATION.csh_bank_account_id,
952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,

Line 956: CE_JE_CREATION.csl_bank_trx_number,

952: CE_JE_CREATION.jem_gl_account_ccid,
953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,
960: g_multi_currency,

Line 957: CE_JE_CREATION.csl_bank_account_text,

953: CE_JE_CREATION.jem_search_string_txt,
954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,
960: g_multi_currency,
961: CE_JE_CREATION.jem_trxn_subtype_code_id;

Line 958: CE_JE_CREATION.csl_customer_text,

954: CE_JE_CREATION.jem_reference_txt,
955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,
960: g_multi_currency,
961: CE_JE_CREATION.jem_trxn_subtype_code_id;
962: EXIT WHEN statement_lines_cursor%NOTFOUND or

Line 959: CE_JE_CREATION.csl_cashflow_id,

955: --CE_JE_CREATION.csh_bank_account_ccid,
956: CE_JE_CREATION.csl_bank_trx_number,
957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,
960: g_multi_currency,
961: CE_JE_CREATION.jem_trxn_subtype_code_id;
962: EXIT WHEN statement_lines_cursor%NOTFOUND or
963: statement_lines_cursor%NOTFOUND IS NULL;

Line 961: CE_JE_CREATION.jem_trxn_subtype_code_id;

957: CE_JE_CREATION.csl_bank_account_text,
958: CE_JE_CREATION.csl_customer_text,
959: CE_JE_CREATION.csl_cashflow_id,
960: g_multi_currency,
961: CE_JE_CREATION.jem_trxn_subtype_code_id;
962: EXIT WHEN statement_lines_cursor%NOTFOUND or
963: statement_lines_cursor%NOTFOUND IS NULL;
964:
965:

Line 966: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN

962: EXIT WHEN statement_lines_cursor%NOTFOUND or
963: statement_lines_cursor%NOTFOUND IS NULL;
964:
965:
966: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
967:
968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,

Line 968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN

964:
965:
966: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
967:
968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,
971: CE_JE_CREATION.csl_statement_line_id,
972: 'CE_NO_BA_LE_IN_SYS',

Line 969: CE_JE_CREATION_ERRORS_PKG.insert_row(

965:
966: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
967:
968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,
971: CE_JE_CREATION.csl_statement_line_id,
972: 'CE_NO_BA_LE_IN_SYS',
973: NVL(FND_GLOBAL.user_id,-1),

Line 970: CE_JE_CREATION.csh_statement_header_id,

966: IF CE_JE_CREATION.csl_cashflow_id IS NULL THEN
967:
968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,
971: CE_JE_CREATION.csl_statement_line_id,
972: 'CE_NO_BA_LE_IN_SYS',
973: NVL(FND_GLOBAL.user_id,-1),
974: sysdate,

Line 971: CE_JE_CREATION.csl_statement_line_id,

967:
968: IF CE_JE_CREATION.sys_sob_id IS NULL THEN
969: CE_JE_CREATION_ERRORS_PKG.insert_row(
970: CE_JE_CREATION.csh_statement_header_id,
971: CE_JE_CREATION.csl_statement_line_id,
972: 'CE_NO_BA_LE_IN_SYS',
973: NVL(FND_GLOBAL.user_id,-1),
974: sysdate,
975: sysdate,

Line 987: IF l_last_statement_line_id <> CE_JE_CREATION.csl_statement_line_id THEN

983: -- if it matches more than one JE mapping. its
984: -- difficult and performance intensive if we put
985: -- this logic in the sql stmt
986: --
987: IF l_last_statement_line_id <> CE_JE_CREATION.csl_statement_line_id THEN
988: IF(lock_statement_line) THEN
989: Process_statement_line;
990: ELSE
991: CE_JE_CREATION_ERRORS_PKG.insert_row(

Line 991: CE_JE_CREATION_ERRORS_PKG.insert_row(

987: IF l_last_statement_line_id <> CE_JE_CREATION.csl_statement_line_id THEN
988: IF(lock_statement_line) THEN
989: Process_statement_line;
990: ELSE
991: CE_JE_CREATION_ERRORS_PKG.insert_row(
992: CE_JE_CREATION.csh_statement_header_id,
993: CE_JE_CREATION.csl_statement_line_id,
994: 'CE_LINE_LOCKED',
995: NVL(FND_GLOBAL.user_id,-1),

Line 992: CE_JE_CREATION.csh_statement_header_id,

988: IF(lock_statement_line) THEN
989: Process_statement_line;
990: ELSE
991: CE_JE_CREATION_ERRORS_PKG.insert_row(
992: CE_JE_CREATION.csh_statement_header_id,
993: CE_JE_CREATION.csl_statement_line_id,
994: 'CE_LINE_LOCKED',
995: NVL(FND_GLOBAL.user_id,-1),
996: sysdate,

Line 993: CE_JE_CREATION.csl_statement_line_id,

989: Process_statement_line;
990: ELSE
991: CE_JE_CREATION_ERRORS_PKG.insert_row(
992: CE_JE_CREATION.csh_statement_header_id,
993: CE_JE_CREATION.csl_statement_line_id,
994: 'CE_LINE_LOCKED',
995: NVL(FND_GLOBAL.user_id,-1),
996: sysdate,
997: sysdate,

Line 1002: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;

998: NVL(FND_GLOBAL.user_id,-1),
999: NVL(FND_GLOBAL.user_id,-1),
1000: g_request_id);
1001: END IF;
1002: l_last_statement_line_id := CE_JE_CREATION.csl_statement_line_id;
1003: END IF;
1004: END IF;
1005: END LOOP; -- statement_lines_cursor
1006: CLOSE statement_lines_cursor;

Line 1035: END CE_JE_CREATION;

1031: RAISE;
1032: END create_journal;
1033:
1034:
1035: END CE_JE_CREATION;