APPS.OKS_QA_DATA_INTEGRITY dependencies on FND_PROFILE

Line 1860: --(FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed) THEN

1856: FETCH l_org_csr INTO l_org_id;
1857: CLOSE l_org_csr;
1858:
1859: IF l_cle_rec.lse_id IN (1, 12, 19, 46) AND
1860: --(FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed) THEN
1861: (FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'DRT', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed(l_org_id)) THEN
1862:
1863: l_check_salesperson_contact := 'T';
1864:

Line 1861: (FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'DRT', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed(l_org_id)) THEN

1857: CLOSE l_org_csr;
1858:
1859: IF l_cle_rec.lse_id IN (1, 12, 19, 46) AND
1860: --(FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed) THEN
1861: (FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'DRT', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed(l_org_id)) THEN
1862:
1863: l_check_salesperson_contact := 'T';
1864:
1865: OPEN l_salescredit_csr(l_cle_rec.id);

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

2545: END LOOP; -- End loop get service line id
2546: CLOSE l_csr_get_service_line_id; */
2547:
2548: /****
2549: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES'
2550: THEN
2551: FOR l_get_top_line_rec IN l_get_top_line_csr
2552: LOOP
2553:

Line 2613: END IF; -- IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES'

2609: END LOOP; --FOR l_get_top_line_rec in l_get_top_line_csr
2610:
2611:
2612:
2613: END IF; -- IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES'
2614: ****/
2615:
2616:
2617: --bug 5442886

Line 2630: IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES' THEN

2626: FOR i IN l_sub_line_id_tbl.FIRST..l_sub_line_id_tbl.LAST LOOP
2627:
2628: --Modified for Bug#6317316 harlaksh. Price_unit check is not necessary.
2629: /* commenting out the first IF condition keeping only else condition part.
2630: IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES' THEN
2631:
2632: IF (l_price_unit_tbl(i) IS NULL OR l_uom_code_tbl(i) IS NULL)
2633: THEN
2634: -- store SQL error message on message stack

Line 4946: l_authorize_payment := nvl(fnd_profile.VALUE('OKS_CREDIT_PROCESSING_QA_LEVEL'), '0');

4942:
4943:
4944:
4945: -- If OKS: Credit Card Validation Level profile does not hold value 'Authorize Payment', skip check
4946: l_authorize_payment := nvl(fnd_profile.VALUE('OKS_CREDIT_PROCESSING_QA_LEVEL'), '0');
4947:
4948: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4949: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_authorize_payment: '|| l_authorize_payment);
4950: END IF;

Line 4965: l_order_value := TO_NUMBER(NVL(fnd_profile.VALUE('OKS_CREDIT_AUTHORIZE_MINIMUM_AMOUNT'), fnd_number.canonical_to_number('0.01'))); --(absolute zero not permitted by iPayment)

4961:
4962:
4963: -- Bug 5106500 --
4964: -- Get amount to be authorized
4965: l_order_value := TO_NUMBER(NVL(fnd_profile.VALUE('OKS_CREDIT_AUTHORIZE_MINIMUM_AMOUNT'), fnd_number.canonical_to_number('0.01'))); --(absolute zero not permitted by iPayment)
4966: -- Bug 5106500 --
4967: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4968: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_order_value: '|| to_char(l_order_value));
4969: END IF;