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_TERMS_QA_PVT dependencies on OKC_TERMS_UTIL_PVT

Line 751: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);

747: END IF;
748:
749: -- current Org Id
750: -- fnd_profile.get('ORG_ID',l_current_org_id);
751: l_current_org_id := OKC_TERMS_UTIL_PVT.get_current_org_id(p_doc_type, p_doc_id);
752:
753: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
754: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'100: l_current_org_id : '||l_current_org_id);
755: END IF;

Line 802: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INCOMPATIBILITY_S);

798: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
799:
800: px_qa_result_tbl(l_indx).qa_code := G_CHECK_INCOMPATIBILITY;
801: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_INCOMPATIBILITY;
802: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INCOMPATIBILITY_S);
803:
804: px_qa_result_tbl(l_indx).error_severity := l_incom_severity;
805: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
806: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY_SH, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));

Line 806: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY_SH, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));

802: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INCOMPATIBILITY_S);
803:
804: px_qa_result_tbl(l_indx).error_severity := l_incom_severity;
805: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
806: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY_SH, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
807: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
808:
809: ELSIF cr.relationship_type=G_ALTERNATE AND l_perform_alternate_qa ='Y' THEN
810: l_indx := px_qa_result_tbl.COUNT + 1;

Line 807: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));

803:
804: px_qa_result_tbl(l_indx).error_severity := l_incom_severity;
805: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
806: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY_SH, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
807: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INCOMPATIBILITY, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
808:
809: ELSIF cr.relationship_type=G_ALTERNATE AND l_perform_alternate_qa ='Y' THEN
810: l_indx := px_qa_result_tbl.COUNT + 1;
811:

Line 820: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ALTERNATE_S);

816: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
817:
818: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ALTERNATE;
819: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ALTERNATE;
820: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ALTERNATE_S);
821: px_qa_result_tbl(l_indx).error_severity := l_alternate_severity;
822: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
823: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE_SH, 'ALTERNATE_ARTICLE', get_article_title(cr.target_cat_id));
824: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));

Line 823: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE_SH, 'ALTERNATE_ARTICLE', get_article_title(cr.target_cat_id));

819: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ALTERNATE;
820: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ALTERNATE_S);
821: px_qa_result_tbl(l_indx).error_severity := l_alternate_severity;
822: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
823: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE_SH, 'ALTERNATE_ARTICLE', get_article_title(cr.target_cat_id));
824: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
825:
826: END IF; -- IF cr.relationship_type=G_INCOMPATIBLE AND
827:

Line 824: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));

820: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ALTERNATE_S);
821: px_qa_result_tbl(l_indx).error_severity := l_alternate_severity;
822: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
823: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE_SH, 'ALTERNATE_ARTICLE', get_article_title(cr.target_cat_id));
824: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ALTERNATE, 'SOURCE_ARTICLE', px_qa_result_tbl(l_indx).title, 'TARGET_ARTICLE', get_article_title(cr.target_cat_id));
825:
826: END IF; -- IF cr.relationship_type=G_INCOMPATIBLE AND
827:
828: END IF; -- IF (p_qa_mode =G_AMEND_QA and cr.amendment_operation_c

Line 850: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC_S);

846: px_qa_result_tbl(l_indx).section_name := Null;
847: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_INC;
848: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_INC;
849: px_qa_result_tbl(l_indx).suggestion :=
850: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC_S);
851: px_qa_result_tbl(l_indx).error_severity := l_incom_severity;
852: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
853: px_qa_result_tbl(l_indx).problem_details_short :=
854: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_INC_SH);

Line 854: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_INC_SH);

850: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC_S);
851: px_qa_result_tbl(l_indx).error_severity := l_incom_severity;
852: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
853: px_qa_result_tbl(l_indx).problem_details_short :=
854: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_INC_SH);
855: px_qa_result_tbl(l_indx).problem_details :=
856: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC,
857: 'RULE', cr.rule_name,
858: 'SOURCE_ARTICLE', get_xprt_article_title(cr.source_article_id),

Line 856: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC,

852: px_qa_result_tbl(l_indx).problem_short_desc := l_incom_desc;
853: px_qa_result_tbl(l_indx).problem_details_short :=
854: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_INC_SH);
855: px_qa_result_tbl(l_indx).problem_details :=
856: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_INC,
857: 'RULE', cr.rule_name,
858: 'SOURCE_ARTICLE', get_xprt_article_title(cr.source_article_id),
859: 'TARGET_ARTICLE', get_xprt_article_title(cr.target_article_id));
860:

Line 874: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT_S);

870: px_qa_result_tbl(l_indx).section_name := Null;
871: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_ALT;
872: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_ALT;
873: px_qa_result_tbl(l_indx).suggestion :=
874: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT_S);
875: px_qa_result_tbl(l_indx).error_severity := l_alternate_severity;
876: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
877: px_qa_result_tbl(l_indx).problem_details_short :=
878: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ALT_SH);

Line 878: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ALT_SH);

874: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT_S);
875: px_qa_result_tbl(l_indx).error_severity := l_alternate_severity;
876: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
877: px_qa_result_tbl(l_indx).problem_details_short :=
878: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ALT_SH);
879: px_qa_result_tbl(l_indx).problem_details :=
880: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT,
881: 'RULE', cr.rule_name,
882: 'SOURCE_ARTICLE', get_xprt_article_title(cr.source_article_id),

Line 880: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT,

876: px_qa_result_tbl(l_indx).problem_short_desc := l_alternate_desc;
877: px_qa_result_tbl(l_indx).problem_details_short :=
878: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ALT_SH);
879: px_qa_result_tbl(l_indx).problem_details :=
880: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ALT,
881: 'RULE', cr.rule_name,
882: 'SOURCE_ARTICLE', get_xprt_article_title(cr.source_article_id),
883: 'TARGET_ARTICLE', get_xprt_article_title(cr.target_article_id));
884: NULL;

Line 1017: l_lock_contract := OKC_TERMS_UTIL_PVT.is_terms_locked(p_doc_type,p_doc_id);

1013: -- validation is not required
1014: RETURN;
1015: END IF;
1016:
1017: l_lock_contract := OKC_TERMS_UTIL_PVT.is_terms_locked(p_doc_type,p_doc_id);
1018: if(l_lock_contract = 'Y') THEN
1019:
1020: l_indx := x_qa_result_tbl.COUNT + 1;
1021:

Line 1030: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LOCK_CONTRACT_S);

1026: x_qa_result_tbl(l_indx).section_name := null;
1027:
1028: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_LOCK_CONTRACT ;
1029: x_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LOCK_CONTRACT ;
1030: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LOCK_CONTRACT_S);
1031: OPEN l_get_lock_error_warn_csr;
1032: FETCH l_get_lock_error_warn_csr into l_lock_severity_flag;
1033: IF (l_get_lock_error_warn_csr%NOTFOUND) THEN
1034: x_qa_result_tbl(l_indx).error_severity := 'E';

Line 1041: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);

1037: x_qa_result_tbl(l_indx).error_severity := l_lock_severity_flag;
1038: x_qa_return_status := l_lock_severity_flag;
1039: END IF;
1040: x_qa_result_tbl(l_indx).problem_short_desc := l_lock_desc;
1041: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);
1042: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);
1043: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1044: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1045: x_qa_result_tbl(l_indx).creation_date := sysdate;

Line 1042: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);

1038: x_qa_return_status := l_lock_severity_flag;
1039: END IF;
1040: x_qa_result_tbl(l_indx).problem_short_desc := l_lock_desc;
1041: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);
1042: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LOCK_CONTRACT_SH);
1043: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1044: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1045: x_qa_result_tbl(l_indx).creation_date := sysdate;
1046:

Line 1192: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_CTRT_ADMIN_S);

1188: x_qa_result_tbl(l_indx).section_name := null;
1189:
1190: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1191: x_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_CTRT_ADMIN_S ;
1192: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_CTRT_ADMIN_S);
1193: OPEN l_get_ctrt_admin_err_wrn_csr;
1194: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1195: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1196: x_qa_result_tbl(l_indx).error_severity := 'W';

Line 1203: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);

1199: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1200: x_qa_return_status := l_ctrt_admin_severity_flag;
1201: END IF;
1202: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1203: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1204: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1205: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1206: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1207: x_qa_result_tbl(l_indx).creation_date := sysdate;

Line 1204: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);

1200: x_qa_return_status := l_ctrt_admin_severity_flag;
1201: END IF;
1202: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1203: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1204: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1205: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1206: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1207: x_qa_result_tbl(l_indx).creation_date := sysdate;
1208:

Line 1224: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_EMP_SUGG);

1220: x_qa_result_tbl(l_indx).section_name := null;
1221:
1222: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1223: x_qa_result_tbl(l_indx).message_name := G_OKC_CTRT_ADMIN_EMP_S ;
1224: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_EMP_SUGG);
1225: OPEN l_get_ctrt_admin_err_wrn_csr;
1226: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1227: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1228: x_qa_result_tbl(l_indx).error_severity := 'W';

Line 1235: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_SH);

1231: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1232: x_qa_return_status := l_ctrt_admin_severity_flag;
1233: END IF;
1234: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1235: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_SH);
1236: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_DT);
1237: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1238: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1239: x_qa_result_tbl(l_indx).creation_date := sysdate;

Line 1236: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_DT);

1232: x_qa_return_status := l_ctrt_admin_severity_flag;
1233: END IF;
1234: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1235: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_SH);
1236: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_DT);
1237: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1238: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1239: x_qa_result_tbl(l_indx).creation_date := sysdate;
1240:

Line 1255: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_VALID_EMP_SUGG);

1251: x_qa_result_tbl(l_indx).section_name := null;
1252:
1253: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1254: x_qa_result_tbl(l_indx).message_name := G_OKC_ADMIN_VALID_EMP_S ;
1255: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_VALID_EMP_SUGG);
1256: OPEN l_get_ctrt_admin_err_wrn_csr;
1257: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1258: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1259: x_qa_result_tbl(l_indx).error_severity := 'W';

Line 1266: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_SH);

1262: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1263: x_qa_return_status := l_ctrt_admin_severity_flag;
1264: END IF;
1265: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1266: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_SH);
1267: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_DT);
1268: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1269: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1270: x_qa_result_tbl(l_indx).creation_date := sysdate;

Line 1267: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_DT);

1263: x_qa_return_status := l_ctrt_admin_severity_flag;
1264: END IF;
1265: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1266: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_SH);
1267: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_DT);
1268: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1269: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1270: x_qa_result_tbl(l_indx).creation_date := sysdate;
1271:

Line 1416: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_DUPLICATE_S);

1412: px_qa_result_tbl(l_indx).title := get_article_title(l_article_tbl(i).id);
1413: px_qa_result_tbl(l_indx).section_name := get_section_title(l_article_tbl(i).scn_id);
1414: px_qa_result_tbl(l_indx).qa_code := G_CHECK_DUPLICATE;
1415: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_DUPLICATE;
1416: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_DUPLICATE_S);
1417:
1418: px_qa_result_tbl(l_indx).error_severity := l_severity;
1419: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1420: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE_SH, 'NUMBER',l_error_count);

Line 1420: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE_SH, 'NUMBER',l_error_count);

1416: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_DUPLICATE_S);
1417:
1418: px_qa_result_tbl(l_indx).error_severity := l_severity;
1419: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1420: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE_SH, 'NUMBER',l_error_count);
1421: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'NUMBER',l_error_count);
1422: END IF; -- IF l_error_count > 1 THEN
1423:
1424: /* expert commented out

Line 1421: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'NUMBER',l_error_count);

1417:
1418: px_qa_result_tbl(l_indx).error_severity := l_severity;
1419: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1420: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE_SH, 'NUMBER',l_error_count);
1421: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_DUPLICATE, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'NUMBER',l_error_count);
1422: END IF; -- IF l_error_count > 1 THEN
1423:
1424: /* expert commented out
1425: IF ((g_expert_enabled = 'Y') and (p_doc_type = 'TEMPLATE')) THEN

Line 1439: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP_S);

1435: px_qa_result_tbl(l_indx).section_name := Null;
1436: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_DUP;
1437: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_DUP;
1438: px_qa_result_tbl(l_indx).suggestion :=
1439: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP_S);
1440: px_qa_result_tbl(l_indx).error_severity := l_severity;
1441: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1442: px_qa_result_tbl(l_indx).problem_details_short :=
1443: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);

Line 1443: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);

1439: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP_S);
1440: px_qa_result_tbl(l_indx).error_severity := l_severity;
1441: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1442: px_qa_result_tbl(l_indx).problem_details_short :=
1443: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);
1444: px_qa_result_tbl(l_indx).problem_details :=
1445: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,
1446: 'RULE', cr.rule_name,
1447: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id));

Line 1445: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,

1441: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1442: px_qa_result_tbl(l_indx).problem_details_short :=
1443: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);
1444: px_qa_result_tbl(l_indx).problem_details :=
1445: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,
1446: 'RULE', cr.rule_name,
1447: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id));
1448: END LOOP;
1449:

Line 1644: and vers.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(

1640: and kart.document_id=p_doc_id
1641: and allwd.template_id=kart.document_id
1642: and kart.sav_sae_id=vers.article_id
1643: -- new logic for determining clause version
1644: and vers.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
1645: kart.sav_sae_id,
1646: g_start_date,
1647: g_end_date,
1648: g_status_code,

Line 1700: OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(

1696: WHERE rule.template_id = p_doc_id
1697: and allwd.template_id=p_doc_id
1698: and vers.article_id = rule.clause_id
1699: and vers.article_version_id =
1700: OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
1701: rule.clause_id,
1702: g_start_date,
1703: g_end_date,
1704: g_status_code,

Line 1769: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_VAR_USAGE_S);

1765: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
1766: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
1767: px_qa_result_tbl(l_indx).qa_code := G_CHECK_VAR_USAGE;
1768: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_VAR_USAGE;
1769: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_VAR_USAGE_S);
1770:
1771: px_qa_result_tbl(l_indx).error_severity := l_severity;
1772: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1773: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE_SH, 'VARIABLE',cr.variable_name,'DOCUMENT_TYPE',cr.doc_type);

Line 1773: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE_SH, 'VARIABLE',cr.variable_name,'DOCUMENT_TYPE',cr.doc_type);

1769: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_VAR_USAGE_S);
1770:
1771: px_qa_result_tbl(l_indx).error_severity := l_severity;
1772: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1773: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE_SH, 'VARIABLE',cr.variable_name,'DOCUMENT_TYPE',cr.doc_type);
1774: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE, 'VARIABLE', cr.variable_name, 'DOCUMENT_TYPE',cr.doc_type);
1775: END IF; -- IF ( ( p_qa_mode =G_AMEND_QA
1776:
1777: END LOOP; -- FOR cr IN l_check_usage_csr LOOP

Line 1774: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE, 'VARIABLE', cr.variable_name, 'DOCUMENT_TYPE',cr.doc_type);

1770:
1771: px_qa_result_tbl(l_indx).error_severity := l_severity;
1772: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1773: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE_SH, 'VARIABLE',cr.variable_name,'DOCUMENT_TYPE',cr.doc_type);
1774: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_VAR_USAGE, 'VARIABLE', cr.variable_name, 'DOCUMENT_TYPE',cr.doc_type);
1775: END IF; -- IF ( ( p_qa_mode =G_AMEND_QA
1776:
1777: END LOOP; -- FOR cr IN l_check_usage_csr LOOP
1778:

Line 1794: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_S);

1790:
1791: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_VAR_DOC;
1792: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_VAR_DOC;
1793: px_qa_result_tbl(l_indx).suggestion :=
1794: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_S);
1795: px_qa_result_tbl(l_indx).error_severity := l_severity;
1796: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1797: px_qa_result_tbl(l_indx).problem_details_short :=
1798: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);

Line 1798: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);

1794: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_S);
1795: px_qa_result_tbl(l_indx).error_severity := l_severity;
1796: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1797: px_qa_result_tbl(l_indx).problem_details_short :=
1798: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);
1799: px_qa_result_tbl(l_indx).problem_details :=
1800: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,
1801: 'RULE', cr.rule_name,
1802: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id),

Line 1800: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,

1796: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1797: px_qa_result_tbl(l_indx).problem_details_short :=
1798: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);
1799: px_qa_result_tbl(l_indx).problem_details :=
1800: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,
1801: 'RULE', cr.rule_name,
1802: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id),
1803: 'DOCUMENT_TYPE', cr.doc_type);
1804: END LOOP;

Line 1937: OKC_TERMS_UTIL_PVT.get_udv_with_proc_value (

1933: IF l_previous_var_code <> csr_udv_with_procs_rec.variable_code THEN
1934:
1935: l_variable_value := NULL;
1936:
1937: OKC_TERMS_UTIL_PVT.get_udv_with_proc_value (
1938: p_document_type => p_doc_type,
1939: p_document_id => p_doc_id,
1940: p_variable_code => csr_udv_with_procs_rec.variable_code,
1941: p_output_error => FND_API.G_FALSE,

Line 1960: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);

1956: px_qa_result_tbl(l_indx).deliverable_id := NULL;
1957: px_qa_result_tbl(l_indx).title := get_article_title(csr_udv_with_procs_rec.id);
1958: px_qa_result_tbl(l_indx).qa_code := G_CHECK_INT_VAR_VALUE;
1959: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_INT_VAR_VALUE;
1960: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);
1961: px_qa_result_tbl(l_indx).section_name := get_section_title(csr_udv_with_procs_rec.scn_id);
1962:
1963: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1964: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;

Line 1965: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', csr_udv_with_procs_rec.variable_name);

1961: px_qa_result_tbl(l_indx).section_name := get_section_title(csr_udv_with_procs_rec.scn_id);
1962:
1963: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1964: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
1965: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', csr_udv_with_procs_rec.variable_name);
1966: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', csr_udv_with_procs_rec.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
1967:
1968: END IF;
1969:

Line 1966: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', csr_udv_with_procs_rec.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);

1962:
1963: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1964: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
1965: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', csr_udv_with_procs_rec.variable_name);
1966: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', csr_udv_with_procs_rec.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
1967:
1968: END IF;
1969:
1970: l_previous_var_code := csr_udv_with_procs_rec.variable_code;

Line 2113: OKC_TERMS_UTIL_PVT.Get_System_Variables (

2109: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2110: RAISE FND_API.G_EXC_ERROR ;
2111: END IF;
2112: IF l_perform_sys_qa ='Y' THEN
2113: OKC_TERMS_UTIL_PVT.Get_System_Variables (
2114: p_api_version => 1,
2115: x_return_status => x_return_status,
2116: x_msg_data => l_msg_data,
2117: x_msg_count => l_msg_count,

Line 2166: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EXT_VAR_VALUE_S);

2162: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2163: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2164: px_qa_result_tbl(l_indx).qa_code := G_CHECK_EXT_VAR_VALUE;
2165: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EXT_VAR_VALUE;
2166: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EXT_VAR_VALUE_S);
2167:
2168: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2169: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2170: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);

Line 2170: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);

2166: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EXT_VAR_VALUE_S);
2167:
2168: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2169: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2170: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);
2171: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
2172:
2173: ELSIF cr.variable_type='U' AND cr.external_yn='N' AND l_perform_int_qa='Y'
2174: AND cr.variable_value IS NULL AND cr.variable_value_id IS NULL THEN

Line 2171: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);

2167:
2168: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2169: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2170: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);
2171: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EXT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
2172:
2173: ELSIF cr.variable_type='U' AND cr.external_yn='N' AND l_perform_int_qa='Y'
2174: AND cr.variable_value IS NULL AND cr.variable_value_id IS NULL THEN
2175:

Line 2184: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);

2180: px_qa_result_tbl(l_indx).deliverable_id := Null;
2181: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2182: px_qa_result_tbl(l_indx).qa_code := G_CHECK_INT_VAR_VALUE;
2183: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_INT_VAR_VALUE;
2184: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);
2185: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2186:
2187: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2188: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;

Line 2189: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);

2185: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2186:
2187: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2188: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
2189: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);
2190: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
2191:
2192: ELSIF cr.variable_type='S' AND l_perform_sys_qa='Y' THEN
2193:

Line 2190: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);

2186:
2187: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2188: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
2189: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE_SH, 'VARIABLE', cr.variable_name);
2190: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_INT_VAR_VALUE, 'VARIABLE', cr.variable_name,'ARTICLE',px_qa_result_tbl(l_indx).title);
2191:
2192: ELSIF cr.variable_type='S' AND l_perform_sys_qa='Y' THEN
2193:
2194: IF l_var_value_tbl.COUNT > 0 THEN

Line 2206: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNRES_SYS_VAR_S);

2202: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2203: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2204: px_qa_result_tbl(l_indx).qa_code := G_CHECK_UNRESOLVED_SYS_VAR;
2205: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNRES_SYS_VAR;
2206: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNRES_SYS_VAR_S);
2207:
2208: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2209: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2210: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR_SH, 'VARIABLE',cr.variable_name);

Line 2210: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR_SH, 'VARIABLE',cr.variable_name);

2206: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNRES_SYS_VAR_S);
2207:
2208: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2209: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2210: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR_SH, 'VARIABLE',cr.variable_name);
2211: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'VARIABLE',cr.variable_name);
2212: END IF; -- IF l_var_value_tbl(i).variable_code
2213: END LOOP; -- FOR i IN l_var_value_tbl.FIRST..
2214: END IF; -- IF l_var_value_tbl.COUNT > 0 THEN

Line 2211: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'VARIABLE',cr.variable_name);

2207:
2208: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2209: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2210: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR_SH, 'VARIABLE',cr.variable_name);
2211: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNRES_SYS_VAR, 'ARTICLE', px_qa_result_tbl(l_indx).title, 'VARIABLE',cr.variable_name);
2212: END IF; -- IF l_var_value_tbl(i).variable_code
2213: END LOOP; -- FOR i IN l_var_value_tbl.FIRST..
2214: END IF; -- IF l_var_value_tbl.COUNT > 0 THEN
2215:

Line 2323: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);

2319: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2320: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2321: px_qa_result_tbl(l_indx).qa_code := G_CHECK_UNASSIGNED_ART;
2322: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNASSIGNED_ART;
2323: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2324: px_qa_result_tbl(l_indx).error_severity := l_severity;
2325: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2326: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2327: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART, 'ARTICLE', px_qa_result_tbl(l_indx).title);

Line 2326: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);

2322: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNASSIGNED_ART;
2323: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2324: px_qa_result_tbl(l_indx).error_severity := l_severity;
2325: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2326: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2327: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART, 'ARTICLE', px_qa_result_tbl(l_indx).title);
2328:
2329: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2330: END IF; -- IF l_perform_unas_art_qa='Y' THEN

Line 2327: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART, 'ARTICLE', px_qa_result_tbl(l_indx).title);

2323: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2324: px_qa_result_tbl(l_indx).error_severity := l_severity;
2325: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2326: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2327: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART, 'ARTICLE', px_qa_result_tbl(l_indx).title);
2328:
2329: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2330: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2331:

Line 2433: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);

2429: px_qa_result_tbl(l_indx).title := get_section_title(cr.id);
2430: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2431: px_qa_result_tbl(l_indx).qa_code := G_CHECK_EMPTY_SECTION;
2432: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EMPTY_SECTION;
2433: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2434: px_qa_result_tbl(l_indx).error_severity := l_severity;
2435: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2436: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2437: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION, 'SECTION', px_qa_result_tbl(l_indx).title);

Line 2436: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);

2432: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EMPTY_SECTION;
2433: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2434: px_qa_result_tbl(l_indx).error_severity := l_severity;
2435: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2436: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2437: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION, 'SECTION', px_qa_result_tbl(l_indx).title);
2438:
2439: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2440: END IF; -- IF l_perform_empty_scn_QA='Y' THEN

Line 2437: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION, 'SECTION', px_qa_result_tbl(l_indx).title);

2433: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2434: px_qa_result_tbl(l_indx).error_severity := l_severity;
2435: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2436: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2437: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION, 'SECTION', px_qa_result_tbl(l_indx).title);
2438:
2439: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2440: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2441:

Line 2542: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);

2538: px_qa_result_tbl(l_indx).title := get_section_title(l_section_tbl(i).id);
2539: px_qa_result_tbl(l_indx).section_name := get_section_title(l_section_tbl(i).scn_id);
2540: px_qa_result_tbl(l_indx).qa_code := G_CHECK_SCN_AMEND_NO_TEXT;
2541: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_SCN_AMEND_NO_TEXT;
2542: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2543: px_qa_result_tbl(l_indx).error_severity := l_severity;
2544: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2545: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_SCN_AMEND_NO_TEXT_SH);
2546: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_SCN_AMEND_NO_TEXT, 'SECTION', px_qa_result_tbl(l_indx).title);

Line 2545: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_SCN_AMEND_NO_TEXT_SH);

2541: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_SCN_AMEND_NO_TEXT;
2542: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2543: px_qa_result_tbl(l_indx).error_severity := l_severity;
2544: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2545: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_SCN_AMEND_NO_TEXT_SH);
2546: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_SCN_AMEND_NO_TEXT, 'SECTION', px_qa_result_tbl(l_indx).title);
2547: END IF; -- IF l_section_tbl(i).amendment_operation_code
2548:
2549: END LOOP;-- FOR i IN l_section_tbl.FIRST..l_section_tbl.LAST

Line 2546: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_SCN_AMEND_NO_TEXT, 'SECTION', px_qa_result_tbl(l_indx).title);

2542: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2543: px_qa_result_tbl(l_indx).error_severity := l_severity;
2544: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2545: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_SCN_AMEND_NO_TEXT_SH);
2546: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_SCN_AMEND_NO_TEXT, 'SECTION', px_qa_result_tbl(l_indx).title);
2547: END IF; -- IF l_section_tbl(i).amendment_operation_code
2548:
2549: END LOOP;-- FOR i IN l_section_tbl.FIRST..l_section_tbl.LAST
2550: END IF; -- IF l_section_tbl.count>0 THEN

Line 2646: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);

2642: px_qa_result_tbl(l_indx).title := get_article_title(l_article_tbl(i).id);
2643: px_qa_result_tbl(l_indx).section_name := get_section_title(l_article_tbl(i).scn_id);
2644: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_AMEND_NO_TEXT;
2645: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_AMEND_NO_TEXT;
2646: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2647: px_qa_result_tbl(l_indx).error_severity := l_severity;
2648: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2649: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_ART_AMEND_NO_TEXT_SH);
2650: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_AMEND_NO_TEXT, 'ARTICLE', px_qa_result_tbl(l_indx).title);

Line 2649: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_ART_AMEND_NO_TEXT_SH);

2645: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_AMEND_NO_TEXT;
2646: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2647: px_qa_result_tbl(l_indx).error_severity := l_severity;
2648: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2649: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_ART_AMEND_NO_TEXT_SH);
2650: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_AMEND_NO_TEXT, 'ARTICLE', px_qa_result_tbl(l_indx).title);
2651: END IF; -- IF l_article_tbl(i).amendment_operation_code I
2652:
2653: END LOOP; -- FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP

Line 2650: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_AMEND_NO_TEXT, 'ARTICLE', px_qa_result_tbl(l_indx).title);

2646: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2647: px_qa_result_tbl(l_indx).error_severity := l_severity;
2648: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2649: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_ART_AMEND_NO_TEXT_SH);
2650: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_AMEND_NO_TEXT, 'ARTICLE', px_qa_result_tbl(l_indx).title);
2651: END IF; -- IF l_article_tbl(i).amendment_operation_code I
2652:
2653: END LOOP; -- FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
2654: END IF; -- IF l_article_tbl.count>0 THEN

Line 2765: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);

2761: px_qa_result_tbl(l_indx).title := cr.template_name;
2762: px_qa_result_tbl(l_indx).section_name := Null;
2763: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TMPL_EFFECTIVITY;
2764: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_EFFECTIVITY;
2765: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2766: px_qa_result_tbl(l_indx).error_severity := l_severity;
2767: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2768: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2769: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_EFFECTIVITY, 'TEMPLATE', cr.template_name);

Line 2768: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);

2764: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_EFFECTIVITY;
2765: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2766: px_qa_result_tbl(l_indx).error_severity := l_severity;
2767: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2768: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2769: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_EFFECTIVITY, 'TEMPLATE', cr.template_name);
2770: END IF; -- IF cr.status_code='ON_HOLD'
2771:
2772: --Bug 4126819 Getting the document type

Line 2769: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_EFFECTIVITY, 'TEMPLATE', cr.template_name);

2765: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2766: px_qa_result_tbl(l_indx).error_severity := l_severity;
2767: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2768: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2769: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_EFFECTIVITY, 'TEMPLATE', cr.template_name);
2770: END IF; -- IF cr.status_code='ON_HOLD'
2771:
2772: --Bug 4126819 Getting the document type
2773: OPEN l_get_doc_type_name;

Line 2791: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TEMPL_USG_ASSO_S,'DOCUMENT_TYPE',l_doc_type_name);

2787: px_qa_result_tbl(l_indx).title := cr.template_name;
2788: px_qa_result_tbl(l_indx).section_name := Null;
2789: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TMPL_EFFECTIVITY;
2790: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TEMPL_USG_ASSO;
2791: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TEMPL_USG_ASSO_S,'DOCUMENT_TYPE',l_doc_type_name);
2792: px_qa_result_tbl(l_indx).error_severity := l_severity;
2793: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2794: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2795: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO,'DOCUMENT_TYPE',l_doc_type_name,'TEMPLATE', cr.template_name);

Line 2794: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);

2790: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TEMPL_USG_ASSO;
2791: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TEMPL_USG_ASSO_S,'DOCUMENT_TYPE',l_doc_type_name);
2792: px_qa_result_tbl(l_indx).error_severity := l_severity;
2793: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2794: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2795: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO,'DOCUMENT_TYPE',l_doc_type_name,'TEMPLATE', cr.template_name);
2796: END IF;
2797: CLOSE l_get_template_usg_csr;
2798:

Line 2795: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO,'DOCUMENT_TYPE',l_doc_type_name,'TEMPLATE', cr.template_name);

2791: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TEMPL_USG_ASSO_S,'DOCUMENT_TYPE',l_doc_type_name);
2792: px_qa_result_tbl(l_indx).error_severity := l_severity;
2793: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2794: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2795: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO,'DOCUMENT_TYPE',l_doc_type_name,'TEMPLATE', cr.template_name);
2796: END IF;
2797: CLOSE l_get_template_usg_csr;
2798:
2799: END LOOP; -- FOR cr in l_get_template_crs LOOP

Line 3109: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);

3105: px_qa_result_tbl(l_indx).title := Get_article_title(cr.id);
3106: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3107: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_VALIDITY;
3108: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_ART_VALIDITY;
3109: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3110: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3111: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3112: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3113: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);

Line 3112: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);

3108: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_ART_VALIDITY;
3109: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3110: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3111: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3112: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3113: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3114:
3115: END LOOP; -- FOR cr in l_check_art_tmpl_csr
3116:

Line 3113: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);

3109: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3110: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3111: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3112: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3113: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3114:
3115: END LOOP; -- FOR cr in l_check_art_tmpl_csr
3116:
3117: /* expert commented out

Line 3133: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL_S);

3129:
3130: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_ART_VAL;
3131: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_ART_VAL;
3132: px_qa_result_tbl(l_indx).suggestion :=
3133: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL_S);
3134: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3135: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3136: px_qa_result_tbl(l_indx).problem_details_short :=
3137: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);

Line 3137: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);

3133: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL_S);
3134: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3135: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3136: px_qa_result_tbl(l_indx).problem_details_short :=
3137: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);
3138: px_qa_result_tbl(l_indx).problem_details :=
3139: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,
3140: 'RULE', cr.rule_name,
3141: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id)

Line 3139: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,

3135: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3136: px_qa_result_tbl(l_indx).problem_details_short :=
3137: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);
3138: px_qa_result_tbl(l_indx).problem_details :=
3139: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,
3140: 'RULE', cr.rule_name,
3141: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id)
3142: );
3143: END LOOP;

Line 3171: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);

3167: px_qa_result_tbl(l_indx).title := Get_article_title(cr.id);
3168: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3169: px_qa_result_tbl(l_indx).qa_code := G_CHECK_LATEST_VERSION;
3170: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LATEST_VERSION;
3171: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3172: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3173: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3174: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3175: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION, 'ARTICLE', px_qa_result_tbl(l_indx).title);

Line 3174: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);

3170: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LATEST_VERSION;
3171: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3172: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3173: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3174: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3175: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3176:
3177: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3178: END LOOP; -- FOR cr IN l_check_latest_version_csr LOOP

Line 3175: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION, 'ARTICLE', px_qa_result_tbl(l_indx).title);

3171: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3172: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3173: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3174: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3175: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3176:
3177: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3178: END LOOP; -- FOR cr IN l_check_latest_version_csr LOOP
3179: END IF; -- IF l_perform_lat_vers_qa ='Y' THEN

Line 3210: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);

3206: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3207:
3208: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_VALIDITY;
3209: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_VALIDITY;
3210: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3211: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3212: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3213: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3214: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);

Line 3213: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);

3209: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_VALIDITY;
3210: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3211: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3212: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3213: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3214: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3215: END IF; -- IF NOT l_found THEN
3216:
3217: END IF; -- IF ( p_qa_mode =G_AMEND_QA

Line 3214: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);

3210: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3211: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3212: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3213: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3214: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY, 'ARTICLE', px_qa_result_tbl(l_indx).title);
3215: END IF; -- IF NOT l_found THEN
3216:
3217: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3218:

Line 3376: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);

3372: px_qa_result_tbl(l_indx).title := l_template_name;
3373: px_qa_result_tbl(l_indx).section_name := Null;
3374: px_qa_result_tbl(l_indx).qa_code := G_CHECK_LAYOUT_TMPL;
3375: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LAYOUT_TMPL;
3376: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3377: px_qa_result_tbl(l_indx).error_severity := l_severity;
3378: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3379: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3380: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);

Line 3379: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);

3375: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LAYOUT_TMPL;
3376: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3377: px_qa_result_tbl(l_indx).error_severity := l_severity;
3378: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3379: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3380: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3381:
3382: END IF;
3383:

Line 3380: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);

3376: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3377: px_qa_result_tbl(l_indx).error_severity := l_severity;
3378: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3379: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3380: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3381:
3382: END IF;
3383:
3384: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN

Line 3498: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);

3494: px_qa_result_tbl(l_indx).title := l_trans_tmpl_name;
3495: px_qa_result_tbl(l_indx).section_name := Null;
3496: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TRANS_TMPL_REVISION;
3497: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_REV;
3498: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3499: px_qa_result_tbl(l_indx).error_severity := l_severity;
3500: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3501: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV_SH,'TMPL1',l_template_name);
3502: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV,'TMPL1',l_template_name);

Line 3501: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV_SH,'TMPL1',l_template_name);

3497: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_REV;
3498: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3499: px_qa_result_tbl(l_indx).error_severity := l_severity;
3500: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3501: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV_SH,'TMPL1',l_template_name);
3502: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV,'TMPL1',l_template_name);
3503:
3504: END IF;
3505:

Line 3502: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV,'TMPL1',l_template_name);

3498: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3499: px_qa_result_tbl(l_indx).error_severity := l_severity;
3500: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3501: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV_SH,'TMPL1',l_template_name);
3502: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_REV,'TMPL1',l_template_name);
3503:
3504: END IF;
3505:
3506: END IF;

Line 3620: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);

3616: px_qa_result_tbl(l_indx).title := l_trans_tmpl_name;
3617: px_qa_result_tbl(l_indx).section_name := Null;
3618: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TRANS_TMPL_EFF;
3619: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_EFF ;
3620: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3621: px_qa_result_tbl(l_indx).error_severity := l_severity;
3622: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3623: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF_SH,'TMPL1',l_template_name);
3624: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF,'TMPL1',l_template_name);

Line 3623: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF_SH,'TMPL1',l_template_name);

3619: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_EFF ;
3620: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3621: px_qa_result_tbl(l_indx).error_severity := l_severity;
3622: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3623: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF_SH,'TMPL1',l_template_name);
3624: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF,'TMPL1',l_template_name);
3625:
3626: END IF;
3627:

Line 3624: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF,'TMPL1',l_template_name);

3620: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3621: px_qa_result_tbl(l_indx).error_severity := l_severity;
3622: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3623: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF_SH,'TMPL1',l_template_name);
3624: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TRANS_TMPL_EFF,'TMPL1',l_template_name);
3625:
3626: END IF;
3627:
3628: END IF;

Line 3732: OKC_TERMS_UTIL_PVT.get_message(G_OKC,G_OKC_CHECK_ART_EXT_S);

3728: px_qa_result_tbl(l_indx).section_name := Null;
3729: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_EXT;
3730: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_EXT;
3731: px_qa_result_tbl(l_indx).suggestion :=
3732: OKC_TERMS_UTIL_PVT.get_message(G_OKC,G_OKC_CHECK_ART_EXT_S);
3733: px_qa_result_tbl(l_indx).error_severity := l_severity;
3734: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3735: px_qa_result_tbl(l_indx).problem_details_short :=
3736: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);

Line 3736: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);

3732: OKC_TERMS_UTIL_PVT.get_message(G_OKC,G_OKC_CHECK_ART_EXT_S);
3733: px_qa_result_tbl(l_indx).error_severity := l_severity;
3734: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3735: px_qa_result_tbl(l_indx).problem_details_short :=
3736: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);
3737: px_qa_result_tbl(l_indx).problem_details :=
3738: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3739: END IF;
3740:

Line 3738: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);

3734: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3735: px_qa_result_tbl(l_indx).problem_details_short :=
3736: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);
3737: px_qa_result_tbl(l_indx).problem_details :=
3738: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3739: END IF;
3740:
3741:
3742: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3909: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (

3905: x_return_status varchar2(150);
3906: x_msg_data varchar2(2000);
3907: x_msg_count number;
3908: begin
3909: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
3910: p_api_version => 1,
3911: p_init_msg_list => FND_API.G_FALSE,
3912: p_template_id => p_doc_id,
3913: p_org_id => g_org_id,

Line 4054: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_S);

4050: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4051:
4052: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_TYP;
4053: px_qa_result_tbl(l_indx).suggestion :=
4054: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_S);
4055: px_qa_result_tbl(l_indx).error_severity := l_severity_art_typ;
4056: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_art_typ;
4057: px_qa_result_tbl(l_indx).problem_details_short :=
4058: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_SH);

Line 4058: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_SH);

4054: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_S);
4055: px_qa_result_tbl(l_indx).error_severity := l_severity_art_typ;
4056: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_art_typ;
4057: px_qa_result_tbl(l_indx).problem_details_short :=
4058: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_SH);
4059: -- use same as problem_details
4060: l_validation_results(i).error_message;
4061: px_qa_result_tbl(l_indx).problem_details :=
4062: l_validation_results(i).error_message;

Line 4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);

4084: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4085:
4086: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_DEF_SEC;
4087: px_qa_result_tbl(l_indx).suggestion :=
4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);
4089: px_qa_result_tbl(l_indx).error_severity := l_severity_def_sec;
4090: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_def_sec;
4091: px_qa_result_tbl(l_indx).problem_details_short :=
4092: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_SH);

Line 4092: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_SH);

4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);
4089: px_qa_result_tbl(l_indx).error_severity := l_severity_def_sec;
4090: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_def_sec;
4091: px_qa_result_tbl(l_indx).problem_details_short :=
4092: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_SH);
4093: -- use same as problem_details
4094: l_validation_results(i).error_message;
4095: px_qa_result_tbl(l_indx).problem_details :=
4096: l_validation_results(i).error_message;

Line 4121: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_S);

4117: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4118:
4119: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_INV_VAR;
4120: px_qa_result_tbl(l_indx).suggestion :=
4121: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_S);
4122: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_var;
4123: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_var;
4124: px_qa_result_tbl(l_indx).problem_details_short :=
4125: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_SH);

Line 4125: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_SH);

4121: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_S);
4122: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_var;
4123: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_var;
4124: px_qa_result_tbl(l_indx).problem_details_short :=
4125: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_SH);
4126: -- use same as problem_details
4127: l_validation_results(i).error_message;
4128: px_qa_result_tbl(l_indx).problem_details :=
4129: l_validation_results(i).error_message;

Line 4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);

4151: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4152:
4153: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_INV_VAL;
4154: px_qa_result_tbl(l_indx).suggestion :=
4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);
4156: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_val;
4157: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_val;
4158: px_qa_result_tbl(l_indx).problem_details_short :=
4159: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_SH);

Line 4159: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_SH);

4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);
4156: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_val;
4157: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_val;
4158: px_qa_result_tbl(l_indx).problem_details_short :=
4159: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_SH);
4160: -- use same as problem_details
4161: l_validation_results(i).error_message;
4162: px_qa_result_tbl(l_indx).problem_details :=
4163: l_validation_results(i).error_message;

Line 4316: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);

4312: px_qa_result_tbl(l_indx).title := l_rejected_art.title;
4313: px_qa_result_tbl(l_indx).section_name := l_rejected_art.section;
4314: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_REJECTED;
4315: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_REJECTED;
4316: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4317: px_qa_result_tbl(l_indx).error_severity := l_severity;
4318: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);

Line 4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);

4315: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_REJECTED;
4316: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4317: px_qa_result_tbl(l_indx).error_severity := l_severity;
4318: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4321: END LOOP;
4322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');

Line 4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);

4316: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4317: px_qa_result_tbl(l_indx).error_severity := l_severity;
4318: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4319: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4320: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4321: END LOOP;
4322: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4324: END IF;

Line 4415: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,KART.ARTICLE_VERSION_ID) TITLE,

4411: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4412: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4413: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4414: KART.SCN_ID SCN_ID,
4415: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,KART.ARTICLE_VERSION_ID) TITLE,
4416: Decode(ART.standard_yn,'N',KART.ref_article_id,NULL) STD_ART_ID
4417: FROM OKC_K_ARTICLES_B KART,
4418: OKC_ARTICLES_ALL ART,
4419: OKC_ARTICLE_VERSIONS VERS

Line 4434: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE

4430: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4431: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4432: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4433: KART.SCN_ID SCN_ID,
4434: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4435: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4436: WHERE KART.DOCUMENT_TYPE = p_doc_type
4437: AND KART.DOCUMENT_ID = p_doc_id
4438: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID

Line 4445: -- 11.5.10+ modified cursor to get the version from OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id

4441: FROM OKC_ARTICLE_VERSIONS
4442: WHERE ARTICLE_ID=VERS.ARTICLE_ID);
4443: */
4444:
4445: -- 11.5.10+ modified cursor to get the version from OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id
4446: CURSOR l_get_tmpl_articles_csr IS
4447: SELECT KART.ID ID,
4448: KART.SAV_SAE_ID ARTICLE_ID,
4449: STD.ARTICLE_ID STD_ART_ID,

Line 4454: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE

4450: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4451: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4452: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4453: KART.SCN_ID SCN_ID,
4454: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4455: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4456: WHERE KART.DOCUMENT_TYPE = p_doc_type
4457: AND KART.DOCUMENT_ID = p_doc_id
4458: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID

Line 4460: AND VERS.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(

4456: WHERE KART.DOCUMENT_TYPE = p_doc_type
4457: AND KART.DOCUMENT_ID = p_doc_id
4458: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4459: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID
4460: AND VERS.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
4461: KART.sav_sae_id,
4462: g_start_date,
4463: g_end_date,
4464: g_status_code,

Line 4482: AND VER.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(

4478: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4479: WHERE XPRT.template_id = p_doc_id
4480: AND ART.article_id = XPRT.clause_id
4481: AND VER.article_id = ART.article_id
4482: AND VER.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
4483: ART.article_id,
4484: g_start_date,
4485: g_end_date,
4486: g_status_code,

Line 4499: okc_terms_util_pvt.get_message('OKC',

4495: AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4496: SCN_ID SCN_ID,
4497: SCN_CODE SCN_CODE,
4498: DECODE(LABEL,NULL,HEADING,
4499: okc_terms_util_pvt.get_message('OKC',
4500: 'OKC_TERMS_LABEL_AND_NAME',
4501: 'LABEL', LABEL,
4502: 'NAME', HEADING)) HEADING
4503: FROM OKC_SECTIONS_B