APPS.FII_EUL_UTILS dependencies on FND_PROFILE

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

1: PACKAGE BODY FII_EUL_UTILS AS
2: /* $Header: FIIEUL1B.pls 120.2 2004/01/14 07:07:47 sgautam noship $ */
3:
4: g_debug_flag VARCHAR2(1) := NVL(FND_PROFILE.value('EDW_DEBUG'), 'N');
5: g_errbuf VARCHAR2(2000) := NULL;
6: g_retcode VARCHAR2(200) := NULL;
7: g_eulOwner VARCHAR2(30) := NULL;
8: g_fiiSchema VARCHAR2(30) := 'FII';

Line 107: /* IF (fnd_profile.value('EDW_TRACE')='Y') THEN

103: PROCEDURE CHILD_SETUP(p_object_name VARCHAR2) IS
104: l_dir VARCHAR2(400);
105: BEGIN
106:
107: /* IF (fnd_profile.value('EDW_TRACE')='Y') THEN
108: dbms_session.set_sql_trace(TRUE);
109: ELSE
110: dbms_session.set_sql_trace(FALSE);
111: END IF; */ -- Commented for bug 3304365

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

109: ELSE
110: dbms_session.set_sql_trace(FALSE);
111: END IF; */ -- Commented for bug 3304365
112:
113: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
114: edw_log.g_debug := TRUE;
115: END IF;
116:
117: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

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

113: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
114: edw_log.g_debug := TRUE;
115: END IF;
116:
117: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
118: if l_dir is null then
119: l_dir:='/sqlcom/log';
120: end if;
121: if g_debug_flag = 'Y' then