155: for the current session. From the SQL*Prompt, you could do this by
156: calling:
157:
158: FND_GLOBAL.APPS_INITIALIZE(fnd_user_id, fnd_resp_id, fnd_appl_id);
159: fnd_profile.put('AFLOG_ENABLED', 'Y');
160: fnd_profile.put('AFLOG_MODULE', '%');
161: fnd_profile.put('AFLOG_LEVEL','1');
162: fnd_profile.put('AFLOG_FILENAME', '');
163: fnd_log_repository.init;
156: calling:
157:
158: FND_GLOBAL.APPS_INITIALIZE(fnd_user_id, fnd_resp_id, fnd_appl_id);
159: fnd_profile.put('AFLOG_ENABLED', 'Y');
160: fnd_profile.put('AFLOG_MODULE', '%');
161: fnd_profile.put('AFLOG_LEVEL','1');
162: fnd_profile.put('AFLOG_FILENAME', '');
163: fnd_log_repository.init;
164:
157:
158: FND_GLOBAL.APPS_INITIALIZE(fnd_user_id, fnd_resp_id, fnd_appl_id);
159: fnd_profile.put('AFLOG_ENABLED', 'Y');
160: fnd_profile.put('AFLOG_MODULE', '%');
161: fnd_profile.put('AFLOG_LEVEL','1');
162: fnd_profile.put('AFLOG_FILENAME', '');
163: fnd_log_repository.init;
164:
165: Do not ship any code with these calls! Shipping code that internally
158: FND_GLOBAL.APPS_INITIALIZE(fnd_user_id, fnd_resp_id, fnd_appl_id);
159: fnd_profile.put('AFLOG_ENABLED', 'Y');
160: fnd_profile.put('AFLOG_MODULE', '%');
161: fnd_profile.put('AFLOG_LEVEL','1');
162: fnd_profile.put('AFLOG_FILENAME', '');
163: fnd_log_repository.init;
164:
165: Do not ship any code with these calls! Shipping code that internally
166: hard codes Log Properties is a severe P1 bug.
324: -- values in this package to enable logging for the current responsibility
325: -- for the session.
326: --
327: -- This should only be used while trying to debug a problem, as a
328: -- substitute for setting the FND profile options.
329: --
330: --Parameters:
331: --IN:
332: --p_module
350: )
351: IS
352: BEGIN
353:
354: -- Set the FND profile option values.
355: FND_PROFILE.put('AFLOG_ENABLED','Y');
356: FND_PROFILE.put('AFLOG_MODULE',p_module);
357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
351: IS
352: BEGIN
353:
354: -- Set the FND profile option values.
355: FND_PROFILE.put('AFLOG_ENABLED','Y');
356: FND_PROFILE.put('AFLOG_MODULE',p_module);
357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
359:
352: BEGIN
353:
354: -- Set the FND profile option values.
355: FND_PROFILE.put('AFLOG_ENABLED','Y');
356: FND_PROFILE.put('AFLOG_MODULE',p_module);
357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
359:
360: -- Refresh the FND cache.
353:
354: -- Set the FND profile option values.
355: FND_PROFILE.put('AFLOG_ENABLED','Y');
356: FND_PROFILE.put('AFLOG_MODULE',p_module);
357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
359:
360: -- Refresh the FND cache.
361: FND_LOG_REPOSITORY.init();
354: -- Set the FND profile option values.
355: FND_PROFILE.put('AFLOG_ENABLED','Y');
356: FND_PROFILE.put('AFLOG_MODULE',p_module);
357: FND_PROFILE.put('AFLOG_LEVEL',TO_CHAR(p_level));
358: FND_PROFILE.put('AFLOG_FILENAME','');
359:
360: -- Refresh the FND cache.
361: FND_LOG_REPOSITORY.init();
362:
389: IS
390: l_current_log_level NUMBER;
391: BEGIN
392:
393: IF (FND_PROFILE.VALUE('AFLOG_ENABLED') = 'Y') THEN
394: l_current_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
395: d_stmt := (l_current_log_level <= FND_LOG.LEVEL_STATEMENT);
396: d_proc := (l_current_log_level <= FND_LOG.LEVEL_PROCEDURE);
397: d_event := (l_current_log_level <= FND_LOG.LEVEL_EVENT);