APPS.EDW_LOG dependencies on FND_PROFILE

Line 20: if edw_debug is set to no, but the fnd profile AFLOG_ENABLED is 'Y' and

16: BEGIN
17: /*
18: logic used is :
19: if edw_debug is set to yes, we need detailed file logging.
20: if edw_debug is set to no, but the fnd profile AFLOG_ENABLED is 'Y' and
21: AFLOG_LEVEL is at statement level, then also we need g_debug to be true.
22: when a user says that AFLOG_LEVEL is at statement level, they are expecting
23: detailed logging.
24: scenario:

Line 31: IF (fnd_profile.value('EDW_DEBUG') = 'Y') or FND_LOG.G_CURRENT_RUNTIME_LEVEL=FND_LOG.LEVEL_STATEMENT then

27: we need to have two separate entities, edw_debug and then fnd since we
28: want to keep separate the file logging and the fnd logging
29: */
30: --do not directly access AFLOG_ENABLED and AFLOG_LEVEL
31: IF (fnd_profile.value('EDW_DEBUG') = 'Y') or FND_LOG.G_CURRENT_RUNTIME_LEVEL=FND_LOG.LEVEL_STATEMENT then
32: g_debug := true;
33: ELSE
34: g_debug := false;
35: END IF;