DBA Data[Home] [Help]

APPS.OKS_AUTH_UTIL_PVT dependencies on FND_PROFILE

Line 4553: IF fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC' THEN

4549: , x_description => l_desc);
4550: IF p_lse_id IN(8, 10, 11, 35) THEN
4551: l_formatted_invoice_text := SUBSTR(p_item_desc || ':' || l_no_of_items || ':' || l_desc || ':' || p_start_date || ':' || p_end_date, 1, 450);
4552: ELSE
4553: IF fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC' THEN
4554: l_desc := l_desc;
4555: ELSE
4556: l_desc := l_name;
4557: END IF;

Line 6842: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')

6838: IF clvl_rec.lse_id IN (8, 10, 11, 12, 35 )
6839: OR (
6840: clvl_rec.lse_id IN (7, 9, 18, 25)
6841: AND
6842: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')
6843:
6844: THEN
6845: -- Bug 5228352 --
6846: -- --------errorout_ad(' before calculating tax ');

Line 6917: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN

6913: -- --------errorout_ad(' after qp int pvt '||l_return_status );
6914:
6915: END IF; /* Calculate tax - update IRT rule for non cov item , cov prod */
6916:
6917: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN
6918:
6919: IF clvl_rec.lse_id IN (7, 9, 18, 25) THEN
6920: -- l_detail_rec.chr_id := l_service_rec.header_id; /** header id **/
6921: -- l_detail_rec.line_id := p_contract_line_id; /** line id **/

Line 6998: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')

6994: -- Bug 5228352 --
6995: IF l_old_lse_id IN (8, 10, 11, 12, 35 )
6996: OR ( l_old_lse_id IN (7, 9, 18, 25)
6997: AND
6998: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')
6999: THEN
7000: -- Bug 5228352 --
7001:
7002: -- --------errorout_ad(' before calculating tax ');

Line 7095: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN

7091:
7092:
7093: /*** Profile option to be checked. If 'Yes' then call pricing engine **/
7094:
7095: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN
7096:
7097: IF l_old_lse_id IN (7, 9, 18, 25) THEN
7098: -- l_detail_rec.chr_id := l_service_red.header_id; /** header id **/
7099: -- l_detail_rec.line_id := l_service_rec.line_id; /** line id **/

Line 7517: l_hz_prof_val := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');

7513:
7514: --npalepu added on 4/26/2006 for bug # 5174716
7515: --setting the profile value HZ_GENERATE_PARTY_SITE_NUMBER to Y if it is set to N
7516: --inorder to auto generate the party_site_number irrespective of the profile value
7517: l_hz_prof_val := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
7518: IF l_hz_prof_val = 'N' THEN
7519: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER','Y');
7520: l_change_prof := 'Y';
7521: END IF;

Line 7519: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER','Y');

7515: --setting the profile value HZ_GENERATE_PARTY_SITE_NUMBER to Y if it is set to N
7516: --inorder to auto generate the party_site_number irrespective of the profile value
7517: l_hz_prof_val := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
7518: IF l_hz_prof_val = 'N' THEN
7519: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER','Y');
7520: l_change_prof := 'Y';
7521: END IF;
7522: --end npalepu
7523:

Line 7535: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER',l_hz_prof_val);

7531: x_msg_data => x_msg_data);
7532:
7533: --npalepu added on 4/26/2006 for bug # 5174716
7534: IF l_change_prof = 'Y' THEN
7535: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER',l_hz_prof_val);
7536: END IF;
7537: --end npalepu
7538:
7539: EXCEPTION