DBA Data[Home] [Help]

APPS.FND_FILE dependencies on FND_LOG

Line 87: ** log_simple_msg - Logs a message to FND_LOG_MESSAGES based on current runtime level

83:
84: end get_exception;
85:
86: /*
87: ** log_simple_msg - Logs a message to FND_LOG_MESSAGES based on current runtime level
88: **
89: */
90: procedure log_simple_msg (level in number, fn in varchar2, msg in varchar2) is
91:

Line 94: if (level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

90: procedure log_simple_msg (level in number, fn in varchar2, msg in varchar2) is
91:
92: BEGIN
93:
94: if (level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
95: FND_LOG.STRING(level,'fnd.plsql.fnd_file.'||fn, 'sid:'||userenv('SESSIONID')||': '||msg);
96: end if;
97:
98: end;

Line 95: FND_LOG.STRING(level,'fnd.plsql.fnd_file.'||fn, 'sid:'||userenv('SESSIONID')||': '||msg);

91:
92: BEGIN
93:
94: if (level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
95: FND_LOG.STRING(level,'fnd.plsql.fnd_file.'||fn, 'sid:'||userenv('SESSIONID')||': '||msg);
96: end if;
97:
98: end;
99:

Line 169: log_simple_msg(fnd_log.level_statement, 'open_files', 'open OUT_FNAME ='|| OUT_FNAME);

165: begin
166:
167: if OUT_OPEN = FALSE then
168: temp_file := OUT_FNAME;
169: log_simple_msg(fnd_log.level_statement, 'open_files', 'open OUT_FNAME ='|| OUT_FNAME);
170: F_OUT := openit(OUT_FNAME);
171: OUT_OPEN := TRUE;
172: end if;
173:

Line 176: log_simple_msg(fnd_log.level_statement, 'open_files', 'open LOG_FNAME ='|| LOG_FNAME);

172: end if;
173:
174: if LOG_OPEN = FALSE then
175: temp_file := LOG_FNAME;
176: log_simple_msg(fnd_log.level_statement, 'open_files', 'open LOG_FNAME ='|| LOG_FNAME);
177: F_LOG := openit(LOG_FNAME);
178: LOG_OPEN := TRUE;
179: end if;
180:

Line 240: log_simple_msg (fnd_log.level_statement, 'put_names_os',

236: if UTL_FILE_DELAY > 0 then
237: if IS_OPEN('LOG') = 0 then
238: TEMP_UTL := TEMP_DIR || '/' || LOG_FNAME;
239: if ( fnd_conc_private_utils.check_temp_file_use(temp_utl,NULL,'F') <> 1) then
240: log_simple_msg (fnd_log.level_statement, 'put_names_os',
241: 'call record_temp_file_use for: '|| TEMP_UTL);
242: fnd_conc_private_utils.record_temp_file_use(TEMP_UTL, NULL, 'F', NULL);
243: end if;
244: end if;

Line 249: log_simple_msg (fnd_log.level_statement, 'put_names_os',

245:
246: if IS_OPEN('OUT') = 0 then
247: TEMP_UTL := TEMP_DIR || '/' || OUT_FNAME;
248: if (fnd_conc_private_utils.check_temp_file_use(temp_utl,NULL,'F') <> 1) then
249: log_simple_msg (fnd_log.level_statement, 'put_names_os',
250: 'call record_temp_file_use for: '|| TEMP_UTL);
251: fnd_conc_private_utils.record_temp_file_use(TEMP_UTL, NULL, 'F', NULL);
252: end if;
253: end if;

Line 312: log_simple_msg(fnd_log.level_event, 'write_buff.' || WTYPE, BUFF);

308:
309: utl_file.fflush(log_f);
310:
311: if WHICH = FND_FILE.LOG then
312: log_simple_msg(fnd_log.level_event, 'write_buff.' || WTYPE, BUFF);
313: end if;
314:
315: end if;
316:

Line 357: log_simple_msg(fnd_log.level_event, FUNC, BUFF);

353:
354: utl_file.fflush(log_f);
355:
356: if which = FND_FILE.LOG then
357: log_simple_msg(fnd_log.level_event, FUNC, BUFF);
358: end if;
359:
360: exception
361: when UTL_FILE.INVALID_FILEHANDLE then

Line 571: log_simple_msg(fnd_log.level_statement, 'close',

567: log_recorded := TRUE;
568: end if;
569:
570: if log_recorded then
571: log_simple_msg(fnd_log.level_statement, 'close',
572: 'temp file: '|| temp_utl ||' recorded');
573: fnd_conc_private_utils.erase_temp_file_use(temp_utl,NULL,'F');
574: else
575: log_simple_msg(fnd_log.level_statement, 'close',

Line 575: log_simple_msg(fnd_log.level_statement, 'close',

571: log_simple_msg(fnd_log.level_statement, 'close',
572: 'temp file: '|| temp_utl ||' recorded');
573: fnd_conc_private_utils.erase_temp_file_use(temp_utl,NULL,'F');
574: else
575: log_simple_msg(fnd_log.level_statement, 'close',
576: 'temp file: '|| temp_utl ||' not recorded');
577: end if;
578:
579: temp_utl := TEMP_DIR || '/' || OUT_FNAME;

Line 584: log_simple_msg(fnd_log.level_statement, 'close',

580: if (fnd_conc_private_utils.check_temp_file_use(temp_utl,NULL,'F') = 1) then
581: out_recorded := TRUE;
582: end if;
583: if out_recorded then
584: log_simple_msg(fnd_log.level_statement, 'close',
585: 'temp file: '|| temp_utl ||' recorded');
586: fnd_conc_private_utils.erase_temp_file_use(temp_utl,NULL,'F');
587: else
588: log_simple_msg(fnd_log.level_statement, 'close',

Line 588: log_simple_msg(fnd_log.level_statement, 'close',

584: log_simple_msg(fnd_log.level_statement, 'close',
585: 'temp file: '|| temp_utl ||' recorded');
586: fnd_conc_private_utils.erase_temp_file_use(temp_utl,NULL,'F');
587: else
588: log_simple_msg(fnd_log.level_statement, 'close',
589: 'temp file: '|| temp_utl ||' not recorded');
590: end if;
591:
592: if (log_recorded or out_recorded) then

Line 596: log_simple_msg(fnd_log.level_statement, 'close',

592: if (log_recorded or out_recorded) then
593: dbms_lock.sleep(UTL_FILE_DELAY);
594: begin
595: utl_file.fgetattr(TEMP_DIR, LOG_FNAME, file_exists, file_length, block_size);
596: log_simple_msg(fnd_log.level_statement, 'close',
597: 'utl_file.getattr (after '||to_char(UTL_FILE_DELAY)||' secs) log file: '||LOG_FNAME ||
598: ' is length: '||file_length||' and block_size: '||block_size);
599: exception
600: when others then

Line 606: log_simple_msg(fnd_log.level_statement,'close',

602: get_exception(SQLCODE, SQLERRM, 'close', LOG_FNAME));
603: end;
604: begin
605: utl_file.fgetattr(TEMP_DIR, OUT_FNAME, file_exists, file_length, block_size);
606: log_simple_msg(fnd_log.level_statement,'close',
607: 'utl_file.getattr (after '||to_char(UTL_FILE_DELAY)||' secs) out file: '||OUT_FNAME ||
608: ' is length: '||file_length||' and block_size: '||block_size);
609: exception
610: when others then

Line 676: log_simple_msg(fnd_log.level_statement, 'init', 'UTL_FILE_DELAY ='|| UTL_FILE_DELAY);

672: end if;
673:
674: if FND_PROFILE.defined('CONC_UTL_FILE_DELAY') then
675: fnd_profile.get('CONC_UTL_FILE_DELAY', UTL_FILE_DELAY);
676: log_simple_msg(fnd_log.level_statement, 'init', 'UTL_FILE_DELAY ='|| UTL_FILE_DELAY);
677: end if;
678:
679: end fnd_file;