APPS.FII_AP_DISCOUNTS_SUM_C dependencies on FND_PROFILE

Line 4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');

1: Package Body FII_AP_DISCOUNTS_SUM_C AS
2: /* $Header: FIIAP14B.pls 120.1 2005/06/13 11:14:23 sgautam noship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');
5: g_fii_schema VARCHAR2(30);
6: g_tablespace VARCHAR2(30);
7:
8: g_errbuf VARCHAR2(2000) := NULL;

Line 151: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN

147: l_stmt := ' ALTER SESSION SET global_names = false';
148: EXECUTE IMMEDIATE l_stmt;
149:
150: -- DEBUG
151: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
152: edw_log.g_debug := TRUE;
153: END IF;
154:
155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

Line 155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

151: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
152: edw_log.g_debug := TRUE;
153: END IF;
154:
155: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
156: if l_dir is null then
157: l_dir:='/sqlcom/log';
158: end if;
159: if g_debug_flag = 'Y' then