APPS.OKS_AUTH_UTIL_PVT dependencies on FND_PROFILE

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

5089: , x_description => l_desc);
5090: IF p_lse_id IN(8, 10, 11, 35) THEN
5091: l_formatted_invoice_text := SUBSTR(p_item_desc || ':' || l_no_of_items || ':' || l_desc || ':' || p_start_date || ':' || p_end_date, 1, 450);
5092: ELSE
5093: IF fnd_profile.VALUE('OKS_ITEM_DISPLAY_PREFERENCE') = 'DISPLAY_DESC' THEN
5094: l_desc := l_desc;
5095: ELSE
5096: l_desc := l_name;
5097: END IF;

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

7480: IF clvl_rec.lse_id IN (8, 10, 11, 12, 35 )
7481: OR (
7482: clvl_rec.lse_id IN (7, 9, 18, 25)
7483: AND
7484: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')
7485:
7486: THEN
7487: -- Bug 5228352 --
7488: -- --------errorout_ad(' before calculating tax ');

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

7555: -- --------errorout_ad(' after qp int pvt '||l_return_status );
7556:
7557: END IF; /* Calculate tax - update IRT rule for non cov item , cov prod */
7558:
7559: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN
7560:
7561: IF clvl_rec.lse_id IN (7, 9, 18, 25) THEN
7562: -- l_detail_rec.chr_id := l_service_rec.header_id; /** header id **/
7563: -- l_detail_rec.line_id := p_contract_line_id; /** line id **/

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

7655: -- Bug 5228352 --
7656: IF l_old_lse_id IN (8, 10, 11, 12, 35 )
7657: OR ( l_old_lse_id IN (7, 9, 18, 25)
7658: AND
7659: NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'NO')
7660: THEN
7661: -- Bug 5228352 --
7662:
7663: -- --------errorout_ad(' before calculating tax ');

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

7754:
7755:
7756: /*** Profile option to be checked. If 'Yes' then call pricing engine **/
7757:
7758: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES' THEN
7759:
7760: IF l_old_lse_id IN (7, 9, 18, 25) THEN
7761: -- l_detail_rec.chr_id := l_service_red.header_id; /** header id **/
7762: -- l_detail_rec.line_id := l_service_rec.line_id; /** line id **/

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

8177:
8178: --npalepu added on 4/26/2006 for bug # 5174716
8179: --setting the profile value HZ_GENERATE_PARTY_SITE_NUMBER to Y if it is set to N
8180: --inorder to auto generate the party_site_number irrespective of the profile value
8181: l_hz_prof_val := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
8182: IF l_hz_prof_val = 'N' THEN
8183: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER','Y');
8184: l_change_prof := 'Y';
8185: END IF;

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

8179: --setting the profile value HZ_GENERATE_PARTY_SITE_NUMBER to Y if it is set to N
8180: --inorder to auto generate the party_site_number irrespective of the profile value
8181: l_hz_prof_val := fnd_profile.value('HZ_GENERATE_PARTY_SITE_NUMBER');
8182: IF l_hz_prof_val = 'N' THEN
8183: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER','Y');
8184: l_change_prof := 'Y';
8185: END IF;
8186: --end npalepu
8187:

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

8195: x_msg_data => x_msg_data);
8196:
8197: --npalepu added on 4/26/2006 for bug # 5174716
8198: IF l_change_prof = 'Y' THEN
8199: fnd_profile.put('HZ_GENERATE_PARTY_SITE_NUMBER',l_hz_prof_val);
8200: END IF;
8201: --end npalepu
8202:
8203: EXCEPTION