APPS.OKC_QP_UPGRADE_PUB dependencies on FND_PROFILE

Line 3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_QP_UPGRADE_PUB AS
2: /* $Header: OKCPQPUB.pls 120.0 2005/05/25 22:36:14 appldev noship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --

Line 85: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN

81: okc_debug.Set_Indentation(l_proc);
82: okc_debug.Log('10: Entering ',2);
83: END IF;
84:
85: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
86: okc_util.init_trace;
87: fnd_file.put_line(FND_FILE.LOG,'Trace Mode is Enabled');
88: END IF;
89:

Line 194: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN

190: okc_debug.Log('500: Calling Stop Trace and Leaving ',2);
191: okc_debug.Log('1000: Leaving ',2);
192: END IF;
193:
194: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
195: -- print debug information
196: fnd_file.put_line(FND_FILE.LOG,' ');
197: fnd_file.put_line(FND_FILE.LOG,' ');
198: fnd_file.put_line(FND_FILE.LOG,' ');

Line 1507: l_prof_val := fnd_profile.value('OKC_ADVANCED_PRICING');

1503: commit;
1504:
1505: -- enable the Profile Option OKC_ADVANCED_PRICING to 'Y'
1506: -- check the current value of OKC_ADVANCED_PRICING
1507: l_prof_val := fnd_profile.value('OKC_ADVANCED_PRICING');
1508:
1509: IF (l_debug = 'Y') THEN
1510: okc_debug.Log('400: Current OKC_ADVANCED_PRICING Profile Value : '||l_prof_val,2);
1511: END IF;

Line 1520: IF fnd_profile.save('OKC_ADVANCED_PRICING', 'Y', 'SITE') THEN

1516: okc_debug.Log('450: Setting OKC_ADVANCED_PRICING to Y ',2);
1517: END IF;
1518:
1519: -- check if profile successfully set to Y
1520: IF fnd_profile.save('OKC_ADVANCED_PRICING', 'Y', 'SITE') THEN
1521: -- commit changes
1522: commit;
1523: IF (l_debug = 'Y') THEN
1524: okc_debug.Log('500: OKC_ADVANCED_PRICING Successfully Set to Y',2);

Line 1857: l_prof_val := fnd_profile.value('OKC_ADVANCED_PRICING');

1853: okc_debug.Log('10: Entering ',2);
1854: END IF;
1855:
1856: -- check the current value of OKC_ADVANCED_PRICING
1857: l_prof_val := fnd_profile.value('OKC_ADVANCED_PRICING');
1858:
1859: IF (l_debug = 'Y') THEN
1860: okc_debug.Log('100: Current OKC_ADVANCED_PRICING Profile Value : '||l_prof_val,2);
1861: END IF;