[Home] [Help]
299: FND_MESSAGE.set_name('JA', 'JA_CN_PERIOD_OPEN');
300: FND_MESSAGE.SET_TOKEN('PERIOD_FROM', p_start_period, TRUE);
301: FND_MESSAGE.SET_TOKEN('PERIOD_TO', p_end_period, TRUE);
302: l_message := FND_MESSAGE.get();
303: FND_FILE.put_line(FND_FILE.LOG, l_message);
304:
305: IF (l_exception_level >= l_runtime_level) THEN
306: FND_LOG.STRING(l_exception_level,
307: l_module_name,
477: --no data found with the requested parameters
478: IF (c_in_ja_cn_journal_lines%ROWCOUNT = 0) THEN
479: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
480: l_message := FND_MESSAGE.get();
481: FND_FILE.put_line(FND_FILE.LOG, l_message);
482: IF (l_exception_level >= l_runtime_level) THEN
483: FND_LOG.STRING(l_exception_level, l_module_name, l_message);
484: END IF;
485: retcode := 1;
513: l_current_start_date);
514:
515: END IF;
516:
517: --FND_FILE.PUT_LINE(FND_FILE.LOG, l_current_start_date);
518:
519: OPEN c_in_ja_cn_subsidiary_gbl_tmp;
520: LOOP
521: FETCH c_in_ja_cn_subsidiary_gbl_tmp
551: /*IF (l_exception_level >= l_runtime_level)
552: THEN
553: fnd_log.STRING(fnd_log.level_statement, l_module_name, l_sql_stmt);
554: END IF;*/
555: FND_FILE.PUT_LINE(FND_FILE.LOG, l_sql_stmt);
556: EXECUTE IMMEDIATE REPLACE(l_sql_stmt,
557: '@AND_CONDITION',
558: 'AND accounted_dr IS NOT NULL')
559: USING l_current_start_date, l_current_period, l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value, p_ledger_id, p_legal_entity_id;
603: l_journal_lines_gbl_tmp_row.entered_dr := 0;
604: l_journal_lines_gbl_tmp_row.entered_cr := 0;
605: END IF;
606:
607: FND_FILE.put_line(FND_FILE.output,
608: '"' || to_char(l_journal_lines_gbl_tmp_row.default_effective_date,
609: 'YYYYMMDD') --journal date
610: || '"' || FND_GLOBAL.Local_Chr(9) || '"' ||
611: l_journal_lines_gbl_tmp_row.je_category --category