DBA Data[Home] [Help]

APPS.FII_AR_TRX_DIST_F_C dependencies on FND_PROFILE

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

1: Package Body FII_AR_TRX_DIST_F_C AS
2: /* $Header: FIIAR06B.pls 120.8 2006/01/18 11:32:42 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_row_count NUMBER:=0;
8: g_push_from_date DATE := NULL;

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

1266:
1267: l_stmt := 'ALTER SESSION SET GLOBAL_NAMES = FALSE' ;
1268: execute immediate l_stmt;
1269:
1270: /* IF (fnd_profile.value('EDW_TRACE')='Y') THEN
1271: dbms_session.set_sql_trace(TRUE);
1272: END IF; */ -- Commented for bug 3304365
1273:
1274: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN

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

1270: /* IF (fnd_profile.value('EDW_TRACE')='Y') THEN
1271: dbms_session.set_sql_trace(TRUE);
1272: END IF; */ -- Commented for bug 3304365
1273:
1274: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
1275: edw_log.g_debug := TRUE;
1276: ENd IF;
1277:
1278: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');

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

1274: IF (fnd_profile.value('EDW_DEBUG') = 'Y') THEN
1275: edw_log.g_debug := TRUE;
1276: ENd IF;
1277:
1278: l_dir:=fnd_profile.value('EDW_LOGFILE_DIR');
1279: if l_dir is null then
1280: l_dir:='/sqlcom/log';
1281: end if;
1282: if g_debug_flag = 'Y' then

Line 1422: IF NVL(FND_PROFILE.value('FII_ACCT_OR_INV_DATE'),'N') = 'Y' THEN

1418:
1419: -----------------------------------------------------------------
1420: -- See whether to use accounting date or invoice date
1421: -----------------------------------------------------------------
1422: IF NVL(FND_PROFILE.value('FII_ACCT_OR_INV_DATE'),'N') = 'Y' THEN
1423: g_acct_or_inv_date := 1;
1424: ELSE
1425: g_acct_or_inv_date := 0;
1426: END IF;