eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_TERMS_UTIL_PVT

Line 2387: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_XPRT_SECTION_S);

2383: x_qa_result_tbl(l_qa_tbl_index).title := l_template_name;
2384: x_qa_result_tbl(l_qa_tbl_index).section_name := l_section_name;
2385: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_INVALID_XPRT_SECTION;
2386: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_INVALID_XPRT_SECTION;
2387: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_XPRT_SECTION_S);
2388: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_def_template_sev;
2389: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_def_template_desc;
2390: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2391: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_INVALID_XPRT_SECTION);

Line 2391: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_INVALID_XPRT_SECTION);

2387: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_XPRT_SECTION_S);
2388: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_def_template_sev;
2389: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_def_template_desc;
2390: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2391: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_INVALID_XPRT_SECTION);
2392: END IF; -- rules not active found
2393: CLOSE cst_tmpl_def_section;
2394:
2395: --

Line 2437: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_RULE_STATUS_S);

2433: x_qa_result_tbl(l_qa_tbl_index).title := l_template_name;
2434: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
2435: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_TEMPLATE_RULE_STATUS;
2436: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_TEMPLATE_RULE_STATUS;
2437: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_RULE_STATUS_S);
2438: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_template_rule_status_sev;
2439: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_template_rule_status_desc;
2440: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2441: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 2441: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

2437: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_RULE_STATUS_S);
2438: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_template_rule_status_sev;
2439: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_template_rule_status_desc;
2440: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2441: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
2442: G_OKC_TEMPLATE_RULE_STATUS);
2443:
2444:
2445: END IF; -- rules not active found

Line 2467: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_NO_RULES_S);

2463: x_qa_result_tbl(l_qa_tbl_index).title := l_template_name;
2464: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
2465: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_TEMPLATE_NO_RULES;
2466: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_TEMPLATE_NO_RULES;
2467: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_NO_RULES_S);
2468: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_template_no_rule_sev;
2469: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_template_no_rule_desc;
2470: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2471: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 2471: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

2467: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_TEMPLATE_NO_RULES_S);
2468: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_template_no_rule_sev;
2469: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_template_no_rule_desc;
2470: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
2471: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
2472: G_OKC_TEMPLATE_NO_RULES);
2473:
2474:
2475: END IF; -- rules not active found

Line 3515: OKC_TERMS_UTIL_PVT.Get_latest_art_version_id(

3511: -- Report Expired clauses too in QA
3512: --
3513:
3514: l_article_version_id :=
3515: OKC_TERMS_UTIL_PVT.Get_latest_art_version_id(
3516: l_expert_articles_tbl(l_article_tbl_index)
3517: , p_document_type
3518: , p_document_id );
3519:

Line 3567: l_article_name := OKC_TERMS_UTIL_PVT.get_article_name( l_expert_articles_tbl(l_article_tbl_index), l_article_version_id);

3563: --
3564: IF (UPPER(l_prov_allowed) = 'Y' OR (UPPER(l_prov_allowed) <> 'Y' AND UPPER(l_provision) = 'N'))
3565: THEN
3566:
3567: l_article_name := OKC_TERMS_UTIL_PVT.get_article_name( l_expert_articles_tbl(l_article_tbl_index), l_article_version_id);
3568: l_qa_tbl_index := x_qa_result_tbl.COUNT + 1;
3569: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
3570: x_qa_result_tbl(l_qa_tbl_index).article_id := l_expert_articles_tbl(l_article_tbl_index);
3571: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;

Line 3577: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_NEW_EXPERT_ART_S);

3573: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
3574: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_NEW_EXPERT_ART;
3575: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_NEW_EXPERT_ART;
3576: x_qa_result_tbl(l_qa_tbl_index).suggestion :=
3577: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_NEW_EXPERT_ART_S);
3578: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_new_expert_article_sev;
3579: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_new_expert_article_desc;
3580: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
3581: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 3581: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

3577: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_NEW_EXPERT_ART_S);
3578: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_new_expert_article_sev;
3579: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_new_expert_article_desc;
3580: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
3581: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
3582: G_OKC_NEW_EXPERT_ART_D,
3583: 'ARTICLE',
3584: l_article_name);
3585: END IF; -- Provision allowed check

Line 3647: l_article_version_id := OKC_TERMS_UTIL_PVT.Get_latest_art_version_id( l_article_id

3643: l_article_id := l_articles_not_in_cz_tbl(l_article_tbl_index);
3644:
3645: l_article_version_id := NULL;
3646: l_article_name := NULL;
3647: l_article_version_id := OKC_TERMS_UTIL_PVT.Get_latest_art_version_id( l_article_id
3648: , p_document_type
3649: , p_document_id );
3650: l_article_name := OKC_TERMS_UTIL_PVT.get_article_name( l_article_id
3651: , l_article_version_id);

Line 3650: l_article_name := OKC_TERMS_UTIL_PVT.get_article_name( l_article_id

3646: l_article_name := NULL;
3647: l_article_version_id := OKC_TERMS_UTIL_PVT.Get_latest_art_version_id( l_article_id
3648: , p_document_type
3649: , p_document_id );
3650: l_article_name := OKC_TERMS_UTIL_PVT.get_article_name( l_article_id
3651: , l_article_version_id);
3652:
3653: l_qa_tbl_index := x_qa_result_tbl.COUNT + 1;
3654:

Line 3662: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_OLD_EXPERT_ART_S);

3658: x_qa_result_tbl(l_qa_tbl_index).title := l_article_name;
3659: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
3660: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_OLD_EXPERT_ART;
3661: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_OLD_EXPERT_ART;
3662: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_OLD_EXPERT_ART_S);
3663: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_old_expert_article_sev;
3664: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_old_expert_article_desc;
3665: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
3666: OKC_TERMS_UTIL_PVT.Get_Message('OKC', -- app name

Line 3666: OKC_TERMS_UTIL_PVT.Get_Message('OKC', -- app name

3662: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_OLD_EXPERT_ART_S);
3663: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_old_expert_article_sev;
3664: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_old_expert_article_desc;
3665: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
3666: OKC_TERMS_UTIL_PVT.Get_Message('OKC', -- app name
3667: G_OKC_OLD_EXPERT_ART_D, -- message name
3668: 'ARTICLE', -- token 1
3669: l_article_name); -- token1 value
3670:

Line 4683: -- l_article_version_id := OKC_TERMS_UTIL_PVT.Get_latest_tmpl_art_version_id(p_article_id, p_effectivity_date);

4679: Open get_doc_article_ver_id(p_document_id, p_document_type, p_article_id);
4680: fetch get_doc_article_ver_id into l_article_id, l_article_version_id, l_doc_lib;
4681: IF get_doc_article_ver_id%NOTFOUND THEN
4682: -- l_article_id := p_article_id;
4683: -- l_article_version_id := OKC_TERMS_UTIL_PVT.Get_latest_tmpl_art_version_id(p_article_id, p_effectivity_date);
4684: -- l_doc_lib := 'L';
4685: Open l_approved_ver_csr(p_article_id, p_effectivity_date);
4686: fetch l_approved_ver_csr into l_article_id, l_article_version_id, l_doc_lib;
4687: if l_approved_ver_csr%NOTFOUND THEN

Line 9425: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9421:
9422: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9423: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9424: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9425: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9426: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9427: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9428: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9429: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

Line 9429: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

9425: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9426: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9427: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9428: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9429: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9430: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_w;
9431: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9432: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9433: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);

Line 9433: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);

9429: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9430: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_w;
9431: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9432: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9433: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);
9434: RETURN;
9435: END IF; */
9436:
9437:

Line 9453: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9449:
9450: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9451: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9452: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9453: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9454: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9455: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9456: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9457: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

Line 9457: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

9453: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9454: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9455: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9456: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9457: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9458: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9459: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9460: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9461: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9461: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9457: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9458: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9459: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9460: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9461: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9462: G_OKC_EXPERT_NOT_APPLIED_D);
9463: RETURN;
9464: END IF;
9465:

Line 9486: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9482:
9483: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9484: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9485: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9486: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9487: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9488: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_PARTIALLY_RUN;
9489: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_PARTIALLY_RUN;
9490: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);

Line 9490: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);

9486: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9487: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9488: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_PARTIALLY_RUN;
9489: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_PARTIALLY_RUN;
9490: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);
9491: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_partially_run_sev;
9492: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_partially_run_desc;
9493: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9494: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9494: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9490: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);
9491: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_partially_run_sev;
9492: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_partially_run_desc;
9493: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9494: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9495: G_OKC_EXPERT_PARTIALLY_RUN_D);
9496: RETURN;
9497:
9498: END IF;

Line 9695: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9691:
9692: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9693: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9694: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9695: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9696: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9697: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9698: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9699: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

Line 9699: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

9695: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9696: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9697: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9698: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9699: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9700: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_w;
9701: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9702: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9703: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);

Line 9703: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);

9699: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9700: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_w;
9701: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9702: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9703: OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_EXPERT_NOT_APPLIED_D);
9704: RETURN;
9705:
9706: END IF;
9707: --

Line 9722: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9718:
9719: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9720: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9721: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9722: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9723: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9724: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9725: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9726: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

Line 9726: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

9722: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9723: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9724: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9725: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9726: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9727: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9728: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9729: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9730: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9730: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9726: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9727: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9728: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9729: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9730: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9731: G_OKC_EXPERT_NOT_APPLIED_D);
9732: RETURN;
9733: END IF; -- config_header_id is null or config_rev_nbr is null
9734:

Line 9825: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9821:
9822: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9823: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9824: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9825: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9826: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9827: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_PARTIALLY_RUN;
9828: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_PARTIALLY_RUN;
9829: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);

Line 9829: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);

9825: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9826: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9827: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_PARTIALLY_RUN;
9828: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_PARTIALLY_RUN;
9829: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);
9830: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_partially_run_sev;
9831: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_partially_run_desc;
9832: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9833: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9833: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9829: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_PARTIALLY_RUN_S);
9830: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_partially_run_sev;
9831: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_partially_run_desc;
9832: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9833: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9834: G_OKC_EXPERT_PARTIALLY_RUN_D);
9835: -- delete config before return
9836: -- delete config before return
9837: --

Line 9874: OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_CONTRACT_EXPERT);

9870: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9871: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9872: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9873: x_qa_result_tbl(l_qa_tbl_index).title :=
9874: OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_CONTRACT_EXPERT);
9875: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9876: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_INCOMPLT_CONFIG;
9877: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_INCOMPLT_CONFIG;
9878: x_qa_result_tbl(l_qa_tbl_index).suggestion :=

Line 9879: OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INCOMPLT_CONFIG_S);

9875: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9876: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_INCOMPLT_CONFIG;
9877: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_INCOMPLT_CONFIG;
9878: x_qa_result_tbl(l_qa_tbl_index).suggestion :=
9879: OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INCOMPLT_CONFIG_S);
9880: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_incomplt_config_sev;
9881: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_incomplt_config_desc;
9882: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9883: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9883: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9879: OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INCOMPLT_CONFIG_S);
9880: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_incomplt_config_sev;
9881: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_incomplt_config_desc;
9882: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9883: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9884: G_OKC_INCOMPLT_CONFIG_D);
9885:
9886: -- delete config before return
9887: --

Line 9922: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9918:
9919: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9920: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9921: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9922: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9923: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9924: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_INVALID_CONFIG;
9925: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_INVALID_CONFIG;
9926: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_CONFIG_S);

Line 9926: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_CONFIG_S);

9922: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9923: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9924: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_INVALID_CONFIG;
9925: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_INVALID_CONFIG;
9926: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_CONFIG_S);
9927: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_invalid_config_sev;
9928: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_invalid_config_desc;
9929: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9930: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9930: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9926: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_INVALID_CONFIG_S);
9927: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_invalid_config_sev;
9928: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_invalid_config_desc;
9929: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9930: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9931: G_OKC_INVALID_CONFIG_D);
9932: -- delete config before return
9933: --
9934: -- Delete BV Configuration from CZ.

Line 9967: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);

9963:
9964: x_qa_result_tbl(l_qa_tbl_index).error_record_type := G_EXPERT_QA_TYPE;
9965: x_qa_result_tbl(l_qa_tbl_index).article_id := NULL;
9966: x_qa_result_tbl(l_qa_tbl_index).deliverable_id := NULL;
9967: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9968: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9969: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9970: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9971: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

Line 9971: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);

9967: x_qa_result_tbl(l_qa_tbl_index).title := OKC_TERMS_UTIL_PVT.Get_Message('OKC', G_OKC_CONTRACT_EXPERT);
9968: x_qa_result_tbl(l_qa_tbl_index).section_name := NULL;
9969: x_qa_result_tbl(l_qa_tbl_index).qa_code := G_CHECK_EXPERT_NOT_APPLIED;
9970: x_qa_result_tbl(l_qa_tbl_index).message_name := G_OKC_EXPERT_NOT_APPLIED;
9971: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9972: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9973: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9974: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9975: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

Line 9975: OKC_TERMS_UTIL_PVT.Get_Message('OKC',

9971: x_qa_result_tbl(l_qa_tbl_index).suggestion := OKC_TERMS_UTIL_PVT.Get_Message('OKC',G_OKC_EXPERT_NOT_APPLIED_S);
9972: x_qa_result_tbl(l_qa_tbl_index).error_severity := l_expert_not_applied_sev_e;
9973: x_qa_result_tbl(l_qa_tbl_index).problem_short_desc := l_expert_not_applied_desc;
9974: x_qa_result_tbl(l_qa_tbl_index).problem_details :=
9975: OKC_TERMS_UTIL_PVT.Get_Message('OKC',
9976: 'OKC_EXPRT_NOT_RUN');
9977:
9978: -- delete config before return
9979: --