226: and debug_option_name = 'PLSQL_PROFILER';
227:
228: exception
229: when others then
230: fnd_message.set_name ('FND', 'SQL-Generic error');
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);
227:
228: exception
229: when others then
230: fnd_message.set_name ('FND', 'SQL-Generic error');
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
228: exception
229: when others then
230: fnd_message.set_name ('FND', 'SQL-Generic error');
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,
229: when others then
230: fnd_message.set_name ('FND', 'SQL-Generic error');
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',
262:
263: -- ignore all exceptions
264: exception
265: when others then
266: fnd_message.set_name ('FND', 'SQL-Generic error');
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);
263: -- ignore all exceptions
264: exception
265: when others then
266: fnd_message.set_name ('FND', 'SQL-Generic error');
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
264: exception
265: when others then
266: fnd_message.set_name ('FND', 'SQL-Generic error');
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,
265: when others then
266: fnd_message.set_name ('FND', 'SQL-Generic error');
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);