DBA Data[Home] [Help]

APPS.FND_DEBUG_UTIL dependencies on FND_LOG

Line 225: where transaction_id = fnd_log.g_transaction_context_id

221:
222: -- update fnd_debug_rule_executions table with request_id
223: update fnd_debug_rule_executions
224: set log_request_id = req_id
225: where transaction_id = fnd_log.g_transaction_context_id
226: and debug_option_name = 'PLSQL_PROFILER';
227:
228: exception
229: when others then

Line 235: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

231: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
232: fnd_message.set_token ('REASON', sqlerrm, FALSE);
233: fnd_message.set_token ('ROUTINE',
234: 'FND_DEBUG_UTIL.STOP_PLSQL_PROFILER', FALSE);
235: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
236: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
237: 'fnd.plsql.FND_DEBUG_UTIL.STOP_PLSQL_PROFILER.others',
238: FALSE);
239: end if;

Line 236: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

232: fnd_message.set_token ('REASON', sqlerrm, FALSE);
233: fnd_message.set_token ('ROUTINE',
234: 'FND_DEBUG_UTIL.STOP_PLSQL_PROFILER', FALSE);
235: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
236: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
237: 'fnd.plsql.FND_DEBUG_UTIL.STOP_PLSQL_PROFILER.others',
238: FALSE);
239: end if;
240:

Line 253: if ( FND_LOG.G_CURRENT_RUNTIME_LEVEL > log_level ) then

249: begin
250: -- set the logging level based on current runtime level.
251: -- we will allow from EXCEPTION to STATEMENT but not from
252: -- STATEMENT to EXCEPTION, etc.
253: if ( FND_LOG.G_CURRENT_RUNTIME_LEVEL > log_level ) then
254:
255: fnd_profile.put('AFLOG_ENABLED', 'Y');
256: fnd_profile.put('AFLOG_MODULE', '%');
257: fnd_profile.put('AFLOG_LEVEL', to_char(log_level));

Line 259: fnd_log_repository.init;

255: fnd_profile.put('AFLOG_ENABLED', 'Y');
256: fnd_profile.put('AFLOG_MODULE', '%');
257: fnd_profile.put('AFLOG_LEVEL', to_char(log_level));
258: fnd_profile.put('AFLOG_FILENAME', '');
259: fnd_log_repository.init;
260:
261: end if;
262:
263: -- ignore all exceptions

Line 271: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

267: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
268: fnd_message.set_token ('REASON', sqlerrm, FALSE);
269: fnd_message.set_token ('ROUTINE',
270: 'FND_DEBUG_UTIL.enable_logging', FALSE);
271: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
273: 'fnd.plsql.FND_DEBUG_UTIL.ENABLE_LOGGING.others', FALSE);
274: end if;
275: end;

Line 272: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

268: fnd_message.set_token ('REASON', sqlerrm, FALSE);
269: fnd_message.set_token ('ROUTINE',
270: 'FND_DEBUG_UTIL.enable_logging', FALSE);
271: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
272: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
273: 'fnd.plsql.FND_DEBUG_UTIL.ENABLE_LOGGING.others', FALSE);
274: end if;
275: end;
276: