APPS.OKL_INS_QUOTE_PVT dependencies on FND_PROFILE

Line 4990: l_max_deal := fnd_profile.value('OKLINMAXDEALSIZE');

4986: CLOSE okl_k_capital_amt_csr;
4987:
4988:
4989: -- Get System Profile value of maximum deal amount....
4990: l_max_deal := fnd_profile.value('OKLINMAXDEALSIZE');
4991: IF ((l_max_deal IS NULL ) OR (l_max_deal = OKC_API.G_MISS_NUM )) THEN
4992: x_return_status := OKC_API.G_RET_STS_ERROR;
4993: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,G_SYS_PROFILE_NAME,'OKLINMAXDEALSIZE' );
4994: x_message := OKL_INS_QUOTE_PVT.G_NO_INS ;

Line 5039: l_max_term := fnd_profile.value('OKLINMAXTERMFORINS');

5035: END IF;
5036: CLOSE okl_k_deal_size_csr;
5037:
5038: -- get max deal term for insurance providing
5039: l_max_term := fnd_profile.value('OKLINMAXTERMFORINS');
5040: IF ((l_max_term IS NULL ) OR (l_max_term = OKC_API.G_MISS_NUM )) THEN
5041: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,G_SYS_PROFILE_NAME,'OKLINMAXTERMFORINS' );
5042: x_return_status := OKC_API.G_RET_STS_ERROR;
5043: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 5046: l_min_term := fnd_profile.value('OKLINMINTERMFORINS');

5042: x_return_status := OKC_API.G_RET_STS_ERROR;
5043: RAISE OKC_API.G_EXCEPTION_ERROR;
5044: END IF ;
5045: -- get min deal term for insurance providing
5046: l_min_term := fnd_profile.value('OKLINMINTERMFORINS');
5047: IF ((l_min_term IS NULL ) OR (l_min_term = OKC_API.G_MISS_NUM )) THEN
5048: OKC_API.set_message(G_APP_NAME, G_NO_SYSTEM_PROFILE,
5049: G_SYS_PROFILE_NAME,'OKLINMINTERMFORINS' );
5050: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 6112: l_afterlease_criteria := fnd_profile.value('OKLINDAYSFORACTIVATION');

6108: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'--Request: '|| FND_GLOBAL.CONC_REQUEST_ID|| ' ---------Date: '||TO_CHAR(SYSDATE)||' ---');
6109: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'-------------------------------------------------------------');
6110:
6111: -- Get values from system profile
6112: l_afterlease_criteria := fnd_profile.value('OKLINDAYSFORACTIVATION');
6113: -- Bug 3742614 changed the profile name and output message
6114: l_percentage_criteria := fnd_profile.value('OKLINPERCENTFORACTIVATION');
6115: -- Check for NULL values and return if either of these is null
6116: IF l_afterlease_criteria = Okc_Api.G_MISS_NUM OR l_afterlease_criteria IS NULL THEN

Line 6114: l_percentage_criteria := fnd_profile.value('OKLINPERCENTFORACTIVATION');

6110:
6111: -- Get values from system profile
6112: l_afterlease_criteria := fnd_profile.value('OKLINDAYSFORACTIVATION');
6113: -- Bug 3742614 changed the profile name and output message
6114: l_percentage_criteria := fnd_profile.value('OKLINPERCENTFORACTIVATION');
6115: -- Check for NULL values and return if either of these is null
6116: IF l_afterlease_criteria = Okc_Api.G_MISS_NUM OR l_afterlease_criteria IS NULL THEN
6117: Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'SYSTEM PROFILE FOR OKLINDAYSFORACTIVATION IS NOT defined');
6118: RETURN;

Line 6514: l_percentage := fnd_profile.value('OKLINPERCENTTOTALPAYMENT');

6510: END IF;
6511:
6512:
6513: -- gboomina starts Bug#4661337 Changed OKLINPERCENTTOTOTALPAYMENT tO OKLINPERCENTTOTALPAYMENT
6514: l_percentage := fnd_profile.value('OKLINPERCENTTOTALPAYMENT');
6515: -- gboomina ends Bug#4661337
6516: IF((l_percentage IS NULL ) OR (l_percentage = OKC_API.G_MISS_NUM )) THEN
6517: l_percentage := 1;
6518: ELSE