APPS.IBW_BI_VST_CMP_KPI_PVT dependencies on FND_PROFILE

Line 79: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');

75:
76: --FND Logging
77: l_full_path VARCHAR2(50) ;
78: --gaflog_value CONSTANT VARCHAR2(10) ;
79: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');
80: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
81:
82: BEGIN
83:

Line 84: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');

80: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
81:
82: BEGIN
83:
84: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');
85:
86: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
87: fnd_log.string(fnd_log.level_statement,l_full_path,'Visitor Conversion Trend Report BEGIN');
88: END IF;

Line 97: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');

93: l_gp_currency := '''FII_GLOBAL1''' ; --Global Primary Currency
94: l_gs_currency := '''FII_GLOBAL2''' ; --Global Secondary Curr
95:
96: l_full_path := 'ibw.plsql.ibwbvcob.get_visitor_conv_trend_sql';
97: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');
98:
99: --Fetch all the Parameters into the Local Variables.
100:
101:

Line 413: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');

409: --FND Logging
410: l_full_path VARCHAR2(50) ;
411: --gaflog_value CONSTANT VARCHAR2(10);
412:
413: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');
414: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
415:
416: BEGIN
417:

Line 418: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');

414: --Profile is : FND: Debug Log Enabled and FND: Debug Log Level for Log Level
415:
416: BEGIN
417:
418: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');
419:
420: IF gaflog_value ='Y' AND (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
421: fnd_log.string(fnd_log.level_statement,l_full_path,'Visit Trend Report BEGIN');
422: END IF;

Line 430: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');

426: l_gp_currency := '''FII_GLOBAL1''' ; --Global Primary Currency Not required for this report
427: l_gs_currency := '''FII_GLOBAL2''' ; --Global Secondary Curr Not required for this report
428:
429: l_full_path := 'ibw.plsql.ibwbvtrb.get_visit_trend_sql';
430: --gaflog_value := fnd_profile.value('AFLOG_ENABLED');
431: --Fetch all the Parameters into the Local Variables.
432:
433: IF gaflog_value ='Y' AND (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN
434: fnd_log.string(fnd_log.level_procedure,l_full_path,'Before the Call to UTL Package to get parameter values');

Line 712: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');

708: --FND Logging
709: l_full_path VARCHAR2(50) ;
710:
711: --Profile is : FND: Debug Log Enabled
712: gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED');
713:
714:
715: BEGIN
716:

Line 721: 2. gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED') to be removed

717:
718: /*
719: Open issues :
720: 1. fnd_log.string(fnd_log.level_unexpected,l_full_path,l_custom_sql); to be removed
721: 2. gaflog_value CONSTANT VARCHAR2(10) := fnd_profile.value('AFLOG_ENABLED') to be removed
722: 3. Sum of Grand Totals with Division to be handled.
723:
724: */
725:

Line 1060: gaflog_value := fnd_profile.value('AFLOG_ENABLED');

1056: BEGIN
1057:
1058: --Profiles for FND Debugging are : FND: Log Enabled , FND: Log Level
1059: l_full_path := 'ibw.plsql.ibwbvckb.GET_KPI_SQL'; --This would be stored in FND_LOG_MESSAGES.MODULE column
1060: gaflog_value := fnd_profile.value('AFLOG_ENABLED');
1061:
1062: -- initialization
1063:
1064: l_gp_currency := '''FII_GLOBAL1''' ;