APPS.OKS_QA_DATA_INTEGRITY dependencies on FND_PROFILE

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

1925: FETCH l_org_csr INTO l_org_id;
1926: CLOSE l_org_csr;
1927:
1928: IF l_cle_rec.lse_id IN (1, 12, 19, 46) AND
1929: --(FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed) THEN
1930: (FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'DRT', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed(l_org_id)) THEN
1931:
1932: l_check_salesperson_contact := 'T';
1933:

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

1926: CLOSE l_org_csr;
1927:
1928: IF l_cle_rec.lse_id IN (1, 12, 19, 46) AND
1929: --(FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed) THEN
1930: (FND_PROFILE.VALUE('OKS_ENABLE_SALES_CREDIT') IN ('YES', 'DRT', 'R') OR OKS_BILL_UTIL_PUB.Is_Sc_Allowed(l_org_id)) THEN
1931:
1932: l_check_salesperson_contact := 'T';
1933:
1934: OPEN l_salescredit_csr(l_cle_rec.id);

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

2614: END LOOP; -- End loop get service line id
2615: CLOSE l_csr_get_service_line_id; */
2616:
2617: /****
2618: IF NVL(fnd_profile.VALUE('OKS_USE_QP_FOR_MANUAL_ADJ'), 'NO') = 'YES'
2619: THEN
2620: FOR l_get_top_line_rec IN l_get_top_line_csr
2621: LOOP
2622:

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

2678: END LOOP; --FOR l_get_top_line_rec in l_get_top_line_csr
2679:
2680:
2681:
2682: END IF; -- IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES'
2683: ****/
2684:
2685:
2686: --bug 5442886

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

2695: FOR i IN l_sub_line_id_tbl.FIRST..l_sub_line_id_tbl.LAST LOOP
2696:
2697: --Modified for Bug#6317316 harlaksh. Price_unit check is not necessary.
2698: /* commenting out the first IF condition keeping only else condition part.
2699: IF NVL(fnd_profile.value('OKS_USE_QP_FOR_MANUAL_ADJ'),'NO') = 'YES' THEN
2700:
2701: IF (l_price_unit_tbl(i) IS NULL OR l_uom_code_tbl(i) IS NULL)
2702: THEN
2703: -- store SQL error message on message stack

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

5089:
5090:
5091:
5092: -- If OKS: Credit Card Validation Level profile does not hold value 'Authorize Payment', skip check
5093: l_authorize_payment := nvl(fnd_profile.VALUE('OKS_CREDIT_PROCESSING_QA_LEVEL'), '0');
5094:
5095: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5096: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_authorize_payment: '|| l_authorize_payment);
5097: END IF;

Line 5112: 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)

5108:
5109:
5110: -- Bug 5106500 --
5111: -- Get amount to be authorized
5112: 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)
5113: -- Bug 5106500 --
5114: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5115: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_order_value: '|| to_char(l_order_value));
5116: END IF;