[Home] [Help]
6: ------------------------------------------------------------------------------
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_XPRT_UTIL_PVT';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9:
10: g_concat_art_no VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_CONCAT_ART_NO'),'N');
11:
12: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
13: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
14: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
518:
519: --
520: -- Check if CE Profile is Enabled.
521: --
522: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_expert_flag );
523:
524: IF NVL(l_expert_flag,'N') = 'N' THEN
525: -- Not Expert enabled
526: RETURN l_expert_flag;
2319:
2320: --
2321: -- Check if CE Profile is Enabled.
2322: --
2323: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_ce_enabled);
2324:
2325: IF NVL(l_ce_enabled,'N') = 'N' THEN
2326: -- Not Expert enabled, skip QA
2327: RETURN;
2657: l_xml_init_msg := '
2658:
2659: l_msg_behavior := 'brief';
2660: l_database_id := FND_WEB_CONFIG.database_id;
2661: l_session_id := FND_PROFILE.value('DB_SESSION_ID');
2662:
2663: OPEN csr_config_effective_date;
2664: FETCH csr_config_effective_date INTO l_config_effective_date;
2665: CLOSE csr_config_effective_date;
3349: END IF;
3350:
3351: x_return_status := G_RET_STS_SUCCESS;
3352:
3353: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') <> 'Y' THEN --only if configurator is used
3354: IF (p_config_header_id IS NULL OR p_config_rev_nbr IS NULL)
3355: THEN
3356: x_msg_data := 'OKC_EXPRT_NULL_PARAM';
3357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3445: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
3446: RAISE FND_API.G_EXC_ERROR ;
3447: END IF;
3448:
3449: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
3450: --
3451: -- Select Articles from rules engine
3452: --
3453: OPEN c_expert_articles_from_ruleng;
3606: -- cz configuration.
3607: --
3608: l_article_id := NULL;
3609:
3610: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
3611: OPEN l_articles_only_in_doc_ruleng(p_document_type,
3612: p_document_id);
3613:
3614: --
3936: FETCH l_get_prov_csr INTO l_prov_allowed;
3937: CLOSE l_get_prov_csr;
3938:
3939: -- Select articles from okc rules engine temp tables
3940: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
3941: --select articles
3942: IF l_prov_allowed = 'Y' THEN
3943: OPEN c_all_expert_articles;
3944: FETCH c_all_expert_articles BULK COLLECT INTO x_expert_articles_tbl;
6889:
6890: --
6891: -- Check if CE Profile is Enabled.
6892: --
6893: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_ce_profile_option_enabled );
6894:
6895: IF NVL(l_ce_profile_option_enabled,'N') = 'N' THEN
6896: -- Not Expert enabled
6897: x_enable_expert_button := FND_API.G_FALSE;
6907: FETCH csr_config_header_id INTO l_config_header_id, l_ce_finish_flag;
6908: CLOSE csr_config_header_id;
6909:
6910:
6911: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
6912: --checking whther the document have any expert responses
6913: BEGIN
6914: SELECT 'Y' INTO l_has_responses FROM dual
6915: WHERE EXISTS (SELECT 1 FROM okc_xprt_doc_ques_response WHERE doc_id = p_document_id AND doc_type = p_document_type AND response IS NOT NULL);
7173: IF FND_API.to_Boolean( p_init_msg_list ) THEN
7174: FND_MSG_PUB.initialize;
7175: END IF;
7176:
7177: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'N' THEN --only if it is configurator
7178: IF (p_config_header_id IS NULL OR p_config_rev_nbr IS NULL)
7179: THEN
7180: x_msg_data := 'OKC_EXPRT_NULL_PARAM';
7181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7200: FETCH l_get_prov_csr INTO l_prov_allowed;
7201: CLOSE l_get_prov_csr;
7202:
7203: -- Select articles and deviations from okc rules engine temp tables
7204: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
7205: --select articles
7206: IF l_prov_allowed = 'Y' THEN
7207: OPEN c_all_expert_articles;
7208: FETCH c_all_expert_articles BULK COLLECT INTO x_expert_clauses_tbl;
9191:
9192: --
9193: -- Check if CE Profile is Enabled.
9194: --
9195: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_ce_enabled);
9196:
9197: IF NVL(l_ce_enabled,'N') = 'N' THEN
9198: -- Not Expert enabled, skip BV
9199: x_msg_data := G_OKC_EXPRT_PROFILE_DISABLED;
9382: G_MODULE||l_api_name,
9383: 'l_template_ce_enabled : '||l_template_ce_enabled);
9384: END IF;
9385:
9386: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
9387:
9388: --checking whther the document have any expert responses
9389: BEGIN
9390: SELECT 'Y' INTO l_has_responses FROM dual
10785: END IF;
10786: CLOSE doc_template_dtls_csr ;
10787:
10788: -- Bug# 6329925. Check if CE Profile is Enabled
10789: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_ce_enabled);
10790:
10791: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
10792: IF NVL(l_ce_enabled,'N') = 'N' OR l_contract_source <> 'STRUCTURED' OR NVL(l_expert_enabled, 'N') <> 'Y' OR OKC_XPRT_RULES_ENGINE_PVT.has_all_questions_answered(p_document_id, p_document_type) = 'Y' THEN
10793: l_return_val := 'N';
10787:
10788: -- Bug# 6329925. Check if CE Profile is Enabled
10789: FND_PROFILE.GET(name=> 'OKC_K_EXPERT_ENABLED', val => l_ce_enabled);
10790:
10791: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
10792: IF NVL(l_ce_enabled,'N') = 'N' OR l_contract_source <> 'STRUCTURED' OR NVL(l_expert_enabled, 'N') <> 'Y' OR OKC_XPRT_RULES_ENGINE_PVT.has_all_questions_answered(p_document_id, p_document_type) = 'Y' THEN
10793: l_return_val := 'N';
10794:
10795: /* Expert is not run completely */