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 1211: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_CTRT_ADMIN_S);

1207: x_qa_result_tbl(l_indx).section_name := null;
1208:
1209: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1210: x_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_CTRT_ADMIN_S ;
1211: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_CTRT_ADMIN_S);
1212: OPEN l_get_ctrt_admin_err_wrn_csr;
1213: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1214: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1215: x_qa_result_tbl(l_indx).error_severity := 'W';

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

1218: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1219: x_qa_return_status := l_ctrt_admin_severity_flag;
1220: END IF;
1221: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1222: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1223: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1224: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1225: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1226: x_qa_result_tbl(l_indx).creation_date := sysdate;

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

1219: x_qa_return_status := l_ctrt_admin_severity_flag;
1220: END IF;
1221: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1222: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1223: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_CTRT_ADMIN_SH);
1224: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1225: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1226: x_qa_result_tbl(l_indx).creation_date := sysdate;
1227:

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

1239: x_qa_result_tbl(l_indx).section_name := null;
1240:
1241: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1242: x_qa_result_tbl(l_indx).message_name := G_OKC_CTRT_ADMIN_EMP_S ;
1243: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_EMP_SUGG);
1244: OPEN l_get_ctrt_admin_err_wrn_csr;
1245: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1246: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1247: x_qa_result_tbl(l_indx).error_severity := 'W';

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

1250: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1251: x_qa_return_status := l_ctrt_admin_severity_flag;
1252: END IF;
1253: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1254: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_SH);
1255: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_DT);
1256: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1257: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1258: x_qa_result_tbl(l_indx).creation_date := sysdate;

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

1251: x_qa_return_status := l_ctrt_admin_severity_flag;
1252: END IF;
1253: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1254: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_SH);
1255: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CTRT_ADMIN_EMP_DT);
1256: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1257: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1258: x_qa_result_tbl(l_indx).creation_date := sysdate;
1259:

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

1270: x_qa_result_tbl(l_indx).section_name := null;
1271:
1272: x_qa_result_tbl(l_indx).qa_code := G_OKC_CHECK_CONTRACT_ADMIN ;
1273: x_qa_result_tbl(l_indx).message_name := G_OKC_ADMIN_VALID_EMP_S ;
1274: x_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_ADMIN_VALID_EMP_SUGG);
1275: OPEN l_get_ctrt_admin_err_wrn_csr;
1276: FETCH l_get_ctrt_admin_err_wrn_csr into l_ctrt_admin_severity_flag;
1277: IF (l_get_ctrt_admin_err_wrn_csr%NOTFOUND) THEN
1278: x_qa_result_tbl(l_indx).error_severity := 'W';

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

1281: x_qa_result_tbl(l_indx).error_severity := l_ctrt_admin_severity_flag;
1282: x_qa_return_status := l_ctrt_admin_severity_flag;
1283: END IF;
1284: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1285: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_SH);
1286: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_DT);
1287: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1288: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1289: x_qa_result_tbl(l_indx).creation_date := sysdate;

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

1282: x_qa_return_status := l_ctrt_admin_severity_flag;
1283: END IF;
1284: x_qa_result_tbl(l_indx).problem_short_desc := l_ctrt_admin_desc;
1285: x_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_SH);
1286: x_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_ADMIN_VALID_EMP_DT);
1287: x_qa_result_tbl(l_indx).document_type := p_doc_type;
1288: x_qa_result_tbl(l_indx).document_id := p_doc_id;
1289: x_qa_result_tbl(l_indx).creation_date := sysdate;
1290:

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

1431: px_qa_result_tbl(l_indx).title := get_article_title(l_article_tbl(i).id);
1432: px_qa_result_tbl(l_indx).section_name := get_section_title(l_article_tbl(i).scn_id);
1433: px_qa_result_tbl(l_indx).qa_code := G_CHECK_DUPLICATE;
1434: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_DUPLICATE;
1435: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_DUPLICATE_S);
1436:
1437: px_qa_result_tbl(l_indx).error_severity := l_severity;
1438: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1439: 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 1439: 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);

1435: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_DUPLICATE_S);
1436:
1437: px_qa_result_tbl(l_indx).error_severity := l_severity;
1438: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1439: 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);
1440: 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);
1441: END IF; -- IF l_error_count > 1 THEN
1442:
1443: /* expert commented out

Line 1440: 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);

1436:
1437: px_qa_result_tbl(l_indx).error_severity := l_severity;
1438: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1439: 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);
1440: 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);
1441: END IF; -- IF l_error_count > 1 THEN
1442:
1443: /* expert commented out
1444: IF ((g_expert_enabled = 'Y') and (p_doc_type = 'TEMPLATE')) THEN

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

1454: px_qa_result_tbl(l_indx).section_name := Null;
1455: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_DUP;
1456: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_DUP;
1457: px_qa_result_tbl(l_indx).suggestion :=
1458: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP_S);
1459: px_qa_result_tbl(l_indx).error_severity := l_severity;
1460: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1461: px_qa_result_tbl(l_indx).problem_details_short :=
1462: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);

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

1458: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP_S);
1459: px_qa_result_tbl(l_indx).error_severity := l_severity;
1460: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1461: px_qa_result_tbl(l_indx).problem_details_short :=
1462: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);
1463: px_qa_result_tbl(l_indx).problem_details :=
1464: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,
1465: 'RULE', cr.rule_name,
1466: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id));

Line 1464: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,

1460: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1461: px_qa_result_tbl(l_indx).problem_details_short :=
1462: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_DUP_SH);
1463: px_qa_result_tbl(l_indx).problem_details :=
1464: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_DUP,
1465: 'RULE', cr.rule_name,
1466: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id));
1467: END LOOP;
1468:

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

1659: and kart.document_id=p_doc_id
1660: and allwd.template_id=kart.document_id
1661: and kart.sav_sae_id=vers.article_id
1662: -- new logic for determining clause version
1663: and vers.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
1664: kart.sav_sae_id,
1665: g_start_date,
1666: g_end_date,
1667: g_status_code,

Line 1719: OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(

1715: WHERE rule.template_id = p_doc_id
1716: and allwd.template_id=p_doc_id
1717: and vers.article_id = rule.clause_id
1718: and vers.article_version_id =
1719: OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
1720: rule.clause_id,
1721: g_start_date,
1722: g_end_date,
1723: g_status_code,

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

1784: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
1785: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
1786: px_qa_result_tbl(l_indx).qa_code := G_CHECK_VAR_USAGE;
1787: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_VAR_USAGE;
1788: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_VAR_USAGE_S);
1789:
1790: px_qa_result_tbl(l_indx).error_severity := l_severity;
1791: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1792: 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 1792: 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);

1788: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_VAR_USAGE_S);
1789:
1790: px_qa_result_tbl(l_indx).error_severity := l_severity;
1791: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1792: 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);
1793: 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);
1794: END IF; -- IF ( ( p_qa_mode =G_AMEND_QA
1795:
1796: END LOOP; -- FOR cr IN l_check_usage_csr LOOP

Line 1793: 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);

1789:
1790: px_qa_result_tbl(l_indx).error_severity := l_severity;
1791: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1792: 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);
1793: 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);
1794: END IF; -- IF ( ( p_qa_mode =G_AMEND_QA
1795:
1796: END LOOP; -- FOR cr IN l_check_usage_csr LOOP
1797:

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

1809:
1810: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_VAR_DOC;
1811: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_VAR_DOC;
1812: px_qa_result_tbl(l_indx).suggestion :=
1813: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_S);
1814: px_qa_result_tbl(l_indx).error_severity := l_severity;
1815: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1816: px_qa_result_tbl(l_indx).problem_details_short :=
1817: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);

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

1813: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_S);
1814: px_qa_result_tbl(l_indx).error_severity := l_severity;
1815: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1816: px_qa_result_tbl(l_indx).problem_details_short :=
1817: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);
1818: px_qa_result_tbl(l_indx).problem_details :=
1819: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,
1820: 'RULE', cr.rule_name,
1821: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id),

Line 1819: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,

1815: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
1816: px_qa_result_tbl(l_indx).problem_details_short :=
1817: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_VAR_DOC_SH);
1818: px_qa_result_tbl(l_indx).problem_details :=
1819: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_VAR_DOC,
1820: 'RULE', cr.rule_name,
1821: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id),
1822: 'DOCUMENT_TYPE', cr.doc_type);
1823: END LOOP;

Line 1956: OKC_TERMS_UTIL_PVT.get_udv_with_proc_value (

1952: IF l_previous_var_code <> csr_udv_with_procs_rec.variable_code THEN
1953:
1954: l_variable_value := NULL;
1955:
1956: OKC_TERMS_UTIL_PVT.get_udv_with_proc_value (
1957: p_document_type => p_doc_type,
1958: p_document_id => p_doc_id,
1959: p_variable_code => csr_udv_with_procs_rec.variable_code,
1960: p_output_error => FND_API.G_FALSE,

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

1975: px_qa_result_tbl(l_indx).deliverable_id := NULL;
1976: px_qa_result_tbl(l_indx).title := get_article_title(csr_udv_with_procs_rec.id);
1977: px_qa_result_tbl(l_indx).qa_code := G_CHECK_INT_VAR_VALUE;
1978: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_INT_VAR_VALUE;
1979: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);
1980: px_qa_result_tbl(l_indx).section_name := get_section_title(csr_udv_with_procs_rec.scn_id);
1981:
1982: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1983: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;

Line 1984: 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);

1980: px_qa_result_tbl(l_indx).section_name := get_section_title(csr_udv_with_procs_rec.scn_id);
1981:
1982: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1983: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
1984: 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);
1985: 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);
1986:
1987: END IF;
1988:

Line 1985: 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);

1981:
1982: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
1983: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
1984: 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);
1985: 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);
1986:
1987: END IF;
1988:
1989: l_previous_var_code := csr_udv_with_procs_rec.variable_code;

Line 2135: OKC_TERMS_UTIL_PVT.Get_System_Variables (

2131: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2132: RAISE FND_API.G_EXC_ERROR ;
2133: END IF;
2134: IF l_perform_sys_qa ='Y' THEN
2135: OKC_TERMS_UTIL_PVT.Get_System_Variables (
2136: p_api_version => 1,
2137: x_return_status => x_return_status,
2138: x_msg_data => l_msg_data,
2139: x_msg_count => l_msg_count,

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

2190: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2191: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2192: px_qa_result_tbl(l_indx).qa_code := G_CHECK_EXT_VAR_VALUE;
2193: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EXT_VAR_VALUE;
2194: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EXT_VAR_VALUE_S);
2195:
2196: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2197: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2198: 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 2198: 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);

2194: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EXT_VAR_VALUE_S);
2195:
2196: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2197: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2198: 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);
2199: 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);
2200:
2201: ELSIF ( ( cr.variable_type='U' AND cr.external_yn='N' AND l_perform_int_qa='Y')
2202: AND

Line 2199: 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);

2195:
2196: px_qa_result_tbl(l_indx).error_severity := l_ext_severity;
2197: px_qa_result_tbl(l_indx).problem_short_desc := l_ext_desc;
2198: 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);
2199: 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);
2200:
2201: ELSIF ( ( cr.variable_type='U' AND cr.external_yn='N' AND l_perform_int_qa='Y')
2202: AND
2203: (

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

2214: px_qa_result_tbl(l_indx).deliverable_id := Null;
2215: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2216: px_qa_result_tbl(l_indx).qa_code := G_CHECK_INT_VAR_VALUE;
2217: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_INT_VAR_VALUE;
2218: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_INT_VAR_VALUE_S);
2219: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2220:
2221: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2222: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;

Line 2223: 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);

2219: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2220:
2221: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2222: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
2223: 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);
2224: 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);
2225:
2226: ELSIF cr.variable_type='S' AND l_perform_sys_qa='Y' THEN
2227:

Line 2224: 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);

2220:
2221: px_qa_result_tbl(l_indx).error_severity := l_INT_severity;
2222: px_qa_result_tbl(l_indx).problem_short_desc := l_INT_desc;
2223: 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);
2224: 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);
2225:
2226: ELSIF cr.variable_type='S' AND l_perform_sys_qa='Y' THEN
2227:
2228: IF l_var_value_tbl.COUNT > 0 THEN

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

2236: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2237: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2238: px_qa_result_tbl(l_indx).qa_code := G_CHECK_UNRESOLVED_SYS_VAR;
2239: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNRES_SYS_VAR;
2240: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNRES_SYS_VAR_S);
2241:
2242: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2243: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2244: 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 2244: 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);

2240: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNRES_SYS_VAR_S);
2241:
2242: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2243: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2244: 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);
2245: 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);
2246: END IF; -- IF l_var_value_tbl(i).variable_code
2247: END LOOP; -- FOR i IN l_var_value_tbl.FIRST..
2248: END IF; -- IF l_var_value_tbl.COUNT > 0 THEN

Line 2245: 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);

2241:
2242: px_qa_result_tbl(l_indx).error_severity := l_sys_severity;
2243: px_qa_result_tbl(l_indx).problem_short_desc := l_sys_desc;
2244: 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);
2245: 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);
2246: END IF; -- IF l_var_value_tbl(i).variable_code
2247: END LOOP; -- FOR i IN l_var_value_tbl.FIRST..
2248: END IF; -- IF l_var_value_tbl.COUNT > 0 THEN
2249:

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

2353: px_qa_result_tbl(l_indx).title := get_article_title(cr.id);
2354: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2355: px_qa_result_tbl(l_indx).qa_code := G_CHECK_UNASSIGNED_ART;
2356: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNASSIGNED_ART;
2357: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2358: px_qa_result_tbl(l_indx).error_severity := l_severity;
2359: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2360: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2361: 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 2360: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);

2356: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_UNASSIGNED_ART;
2357: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2358: px_qa_result_tbl(l_indx).error_severity := l_severity;
2359: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2360: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2361: 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);
2362:
2363: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2364: END IF; -- IF l_perform_unas_art_qa='Y' THEN

Line 2361: 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);

2357: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_UNASSIGNED_ART_S);
2358: px_qa_result_tbl(l_indx).error_severity := l_severity;
2359: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2360: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_UNASSIGNED_ART_SH);
2361: 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);
2362:
2363: END LOOP; -- FOR cr IN l_get_unass_art_crs LOOP
2364: END IF; -- IF l_perform_unas_art_qa='Y' THEN
2365:

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

2463: px_qa_result_tbl(l_indx).title := get_section_title(cr.id);
2464: px_qa_result_tbl(l_indx).section_name := get_section_title(cr.scn_id);
2465: px_qa_result_tbl(l_indx).qa_code := G_CHECK_EMPTY_SECTION;
2466: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EMPTY_SECTION;
2467: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2468: px_qa_result_tbl(l_indx).error_severity := l_severity;
2469: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2470: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2471: 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 2470: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);

2466: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_EMPTY_SECTION;
2467: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2468: px_qa_result_tbl(l_indx).error_severity := l_severity;
2469: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2470: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2471: 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);
2472:
2473: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2474: END IF; -- IF l_perform_empty_scn_QA='Y' THEN

Line 2471: 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);

2467: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_EMPTY_SECTION_S);
2468: px_qa_result_tbl(l_indx).error_severity := l_severity;
2469: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2470: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_EMPTY_SECTION_SH);
2471: 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);
2472:
2473: END LOOP; -- FOR cr IN l_get_empty_section_csr LOOP
2474: END IF; -- IF l_perform_empty_scn_QA='Y' THEN
2475:

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

2572: px_qa_result_tbl(l_indx).title := get_section_title(l_section_tbl(i).id);
2573: px_qa_result_tbl(l_indx).section_name := get_section_title(l_section_tbl(i).scn_id);
2574: px_qa_result_tbl(l_indx).qa_code := G_CHECK_SCN_AMEND_NO_TEXT;
2575: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_SCN_AMEND_NO_TEXT;
2576: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2577: px_qa_result_tbl(l_indx).error_severity := l_severity;
2578: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2579: 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);
2580: 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 2579: 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);

2575: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_SCN_AMEND_NO_TEXT;
2576: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2577: px_qa_result_tbl(l_indx).error_severity := l_severity;
2578: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2579: 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);
2580: 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);
2581: END IF; -- IF l_section_tbl(i).amendment_operation_code
2582:
2583: END LOOP;-- FOR i IN l_section_tbl.FIRST..l_section_tbl.LAST

Line 2580: 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);

2576: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_SCN_AMEND_NO_TEXT_S);
2577: px_qa_result_tbl(l_indx).error_severity := l_severity;
2578: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2579: 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);
2580: 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);
2581: END IF; -- IF l_section_tbl(i).amendment_operation_code
2582:
2583: END LOOP;-- FOR i IN l_section_tbl.FIRST..l_section_tbl.LAST
2584: END IF; -- IF l_section_tbl.count>0 THEN

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

2676: px_qa_result_tbl(l_indx).title := get_article_title(l_article_tbl(i).id);
2677: px_qa_result_tbl(l_indx).section_name := get_section_title(l_article_tbl(i).scn_id);
2678: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_AMEND_NO_TEXT;
2679: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_AMEND_NO_TEXT;
2680: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2681: px_qa_result_tbl(l_indx).error_severity := l_severity;
2682: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2683: 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);
2684: 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 2683: 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);

2679: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_AMEND_NO_TEXT;
2680: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2681: px_qa_result_tbl(l_indx).error_severity := l_severity;
2682: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2683: 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);
2684: 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);
2685: END IF; -- IF l_article_tbl(i).amendment_operation_code I
2686:
2687: END LOOP; -- FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP

Line 2684: 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);

2680: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHK_ART_AMEND_NO_TEXT_S);
2681: px_qa_result_tbl(l_indx).error_severity := l_severity;
2682: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2683: 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);
2684: 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);
2685: END IF; -- IF l_article_tbl(i).amendment_operation_code I
2686:
2687: END LOOP; -- FOR i IN l_article_tbl.FIRST..l_article_tbl.LAST LOOP
2688: END IF; -- IF l_article_tbl.count>0 THEN

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

2795: px_qa_result_tbl(l_indx).title := cr.template_name;
2796: px_qa_result_tbl(l_indx).section_name := Null;
2797: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TMPL_EFFECTIVITY;
2798: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_EFFECTIVITY;
2799: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2800: px_qa_result_tbl(l_indx).error_severity := l_severity;
2801: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2802: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2803: 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 2802: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);

2798: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_EFFECTIVITY;
2799: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2800: px_qa_result_tbl(l_indx).error_severity := l_severity;
2801: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2802: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2803: 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);
2804: END IF; -- IF cr.status_code='ON_HOLD'
2805:
2806: --Bug 4126819 Getting the document type

Line 2803: 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);

2799: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_EFFECTIVITY_S);
2800: px_qa_result_tbl(l_indx).error_severity := l_severity;
2801: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2802: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHK_TMPL_EFFECTIVITY_SH);
2803: 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);
2804: END IF; -- IF cr.status_code='ON_HOLD'
2805:
2806: --Bug 4126819 Getting the document type
2807: OPEN l_get_doc_type_name;

Line 2825: 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);

2821: px_qa_result_tbl(l_indx).title := cr.template_name;
2822: px_qa_result_tbl(l_indx).section_name := Null;
2823: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TMPL_EFFECTIVITY;
2824: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TEMPL_USG_ASSO;
2825: 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);
2826: px_qa_result_tbl(l_indx).error_severity := l_severity;
2827: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2828: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2829: 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 2828: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);

2824: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TEMPL_USG_ASSO;
2825: 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);
2826: px_qa_result_tbl(l_indx).error_severity := l_severity;
2827: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2828: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2829: 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);
2830: END IF;
2831: CLOSE l_get_template_usg_csr;
2832:

Line 2829: 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);

2825: 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);
2826: px_qa_result_tbl(l_indx).error_severity := l_severity;
2827: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
2828: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TEMPL_USG_ASSO_SH);
2829: 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);
2830: END IF;
2831: CLOSE l_get_template_usg_csr;
2832:
2833: END LOOP; -- FOR cr in l_get_template_crs LOOP

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

3139: px_qa_result_tbl(l_indx).title := Get_article_title(cr.id);
3140: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3141: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_VALIDITY;
3142: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_ART_VALIDITY;
3143: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3144: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3145: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3146: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3147: 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 3146: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);

3142: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TMPL_ART_VALIDITY;
3143: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3144: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3145: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3146: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3147: 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);
3148:
3149: END LOOP; -- FOR cr in l_check_art_tmpl_csr
3150:

Line 3147: 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);

3143: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TMPL_ART_VALID_S);
3144: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3145: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3146: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_TMPL_ART_VALID_SH);
3147: 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);
3148:
3149: END LOOP; -- FOR cr in l_check_art_tmpl_csr
3150:
3151: /* expert commented out

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

3163:
3164: px_qa_result_tbl(l_indx).qa_code := G_CHECK_RUL_ART_VAL;
3165: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_RUL_ART_VAL;
3166: px_qa_result_tbl(l_indx).suggestion :=
3167: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL_S);
3168: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3169: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3170: px_qa_result_tbl(l_indx).problem_details_short :=
3171: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);

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

3167: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL_S);
3168: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3169: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3170: px_qa_result_tbl(l_indx).problem_details_short :=
3171: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);
3172: px_qa_result_tbl(l_indx).problem_details :=
3173: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,
3174: 'RULE', cr.rule_name,
3175: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id)

Line 3173: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,

3169: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3170: px_qa_result_tbl(l_indx).problem_details_short :=
3171: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_RUL_ART_VAL_SH);
3172: px_qa_result_tbl(l_indx).problem_details :=
3173: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_RUL_ART_VAL,
3174: 'RULE', cr.rule_name,
3175: 'XPRT_ARTICLE', get_xprt_article_title(cr.xprt_article_id)
3176: );
3177: END LOOP;

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

3201: px_qa_result_tbl(l_indx).title := Get_article_title(cr.id);
3202: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3203: px_qa_result_tbl(l_indx).qa_code := G_CHECK_LATEST_VERSION;
3204: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LATEST_VERSION;
3205: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3206: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3207: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3208: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3209: 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 3208: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);

3204: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LATEST_VERSION;
3205: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3206: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3207: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3208: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3209: 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);
3210:
3211: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3212: END LOOP; -- FOR cr IN l_check_latest_version_csr LOOP

Line 3209: 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);

3205: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LATEST_VERSION_S);
3206: px_qa_result_tbl(l_indx).error_severity := l_lat_vers_severity;
3207: px_qa_result_tbl(l_indx).problem_short_desc := l_lat_vers_desc;
3208: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LATEST_VERSION_SH);
3209: 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);
3210:
3211: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3212: END LOOP; -- FOR cr IN l_check_latest_version_csr LOOP
3213: END IF; -- IF l_perform_lat_vers_qa ='Y' THEN

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

3240: px_qa_result_tbl(l_indx).section_name := Get_section_title(cr.scn_id);
3241:
3242: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_VALIDITY;
3243: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_VALIDITY;
3244: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3245: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3246: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3247: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3248: 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 3247: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);

3243: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_VALIDITY;
3244: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3245: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3246: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3247: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3248: 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);
3249: END IF; -- IF NOT l_found THEN
3250:
3251: END IF; -- IF ( p_qa_mode =G_AMEND_QA

Line 3248: 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);

3244: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_VALIDITY_S);
3245: px_qa_result_tbl(l_indx).error_severity := l_art_val_severity;
3246: px_qa_result_tbl(l_indx).problem_short_desc := l_art_val_desc;
3247: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_VALIDITY_SH);
3248: 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);
3249: END IF; -- IF NOT l_found THEN
3250:
3251: END IF; -- IF ( p_qa_mode =G_AMEND_QA
3252:

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

3406: px_qa_result_tbl(l_indx).title := l_template_name;
3407: px_qa_result_tbl(l_indx).section_name := Null;
3408: px_qa_result_tbl(l_indx).qa_code := G_CHECK_LAYOUT_TMPL;
3409: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LAYOUT_TMPL;
3410: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3411: px_qa_result_tbl(l_indx).error_severity := l_severity;
3412: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3413: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3414: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);

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

3409: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_LAYOUT_TMPL;
3410: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3411: px_qa_result_tbl(l_indx).error_severity := l_severity;
3412: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3413: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3414: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3415:
3416: END IF;
3417:

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

3410: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_LAYOUT_TMPL_S);
3411: px_qa_result_tbl(l_indx).error_severity := l_severity;
3412: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3413: px_qa_result_tbl(l_indx).problem_details_short := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3414: px_qa_result_tbl(l_indx).problem_details := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_LAYOUT_TMPL);
3415:
3416: END IF;
3417:
3418: END IF; -- IF l_perform_layout_tmpl_qa='Y' THEN

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

3528: px_qa_result_tbl(l_indx).title := l_trans_tmpl_name;
3529: px_qa_result_tbl(l_indx).section_name := Null;
3530: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TRANS_TMPL_REVISION;
3531: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_REV;
3532: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3533: px_qa_result_tbl(l_indx).error_severity := l_severity;
3534: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3535: 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);
3536: 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 3535: 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);

3531: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_REV;
3532: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3533: px_qa_result_tbl(l_indx).error_severity := l_severity;
3534: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3535: 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);
3536: 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);
3537:
3538: END IF;
3539:

Line 3536: 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);

3532: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_REV_S);
3533: px_qa_result_tbl(l_indx).error_severity := l_severity;
3534: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3535: 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);
3536: 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);
3537:
3538: END IF;
3539:
3540: END IF;

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

3650: px_qa_result_tbl(l_indx).title := l_trans_tmpl_name;
3651: px_qa_result_tbl(l_indx).section_name := Null;
3652: px_qa_result_tbl(l_indx).qa_code := G_CHECK_TRANS_TMPL_EFF;
3653: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_EFF ;
3654: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3655: px_qa_result_tbl(l_indx).error_severity := l_severity;
3656: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3657: 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);
3658: 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 3657: 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);

3653: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_TRANS_TMPL_EFF ;
3654: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3655: px_qa_result_tbl(l_indx).error_severity := l_severity;
3656: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3657: 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);
3658: 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);
3659:
3660: END IF;
3661:

Line 3658: 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);

3654: px_qa_result_tbl(l_indx).suggestion := OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_TRANS_TMPL_EFF_S);
3655: px_qa_result_tbl(l_indx).error_severity := l_severity;
3656: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3657: 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);
3658: 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);
3659:
3660: END IF;
3661:
3662: END IF;

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

3762: px_qa_result_tbl(l_indx).section_name := Null;
3763: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_EXT;
3764: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_EXT;
3765: px_qa_result_tbl(l_indx).suggestion :=
3766: OKC_TERMS_UTIL_PVT.get_message(G_OKC,G_OKC_CHECK_ART_EXT_S);
3767: px_qa_result_tbl(l_indx).error_severity := l_severity;
3768: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3769: px_qa_result_tbl(l_indx).problem_details_short :=
3770: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);

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

3766: OKC_TERMS_UTIL_PVT.get_message(G_OKC,G_OKC_CHECK_ART_EXT_S);
3767: px_qa_result_tbl(l_indx).error_severity := l_severity;
3768: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3769: px_qa_result_tbl(l_indx).problem_details_short :=
3770: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);
3771: px_qa_result_tbl(l_indx).problem_details :=
3772: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3773: END IF;
3774:

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

3768: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
3769: px_qa_result_tbl(l_indx).problem_details_short :=
3770: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT_SH);
3771: px_qa_result_tbl(l_indx).problem_details :=
3772: OKC_TERMS_UTIL_PVT.get_message(G_OKC, G_OKC_CHECK_ART_EXT);
3773: END IF;
3774:
3775:
3776: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3943: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (

3939: x_return_status varchar2(150);
3940: x_msg_data varchar2(2000);
3941: x_msg_count number;
3942: begin
3943: OKC_TERMS_UTIL_PVT.create_tmpl_clauses_to_submit (
3944: p_api_version => 1,
3945: p_init_msg_list => FND_API.G_FALSE,
3946: p_template_id => p_doc_id,
3947: p_org_id => g_org_id,

Line 4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_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_TYP;
4087: px_qa_result_tbl(l_indx).suggestion :=
4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_S);
4089: px_qa_result_tbl(l_indx).error_severity := l_severity_art_typ;
4090: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_art_typ;
4091: px_qa_result_tbl(l_indx).problem_details_short :=
4092: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_SH);

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

4088: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_S);
4089: px_qa_result_tbl(l_indx).error_severity := l_severity_art_typ;
4090: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_art_typ;
4091: px_qa_result_tbl(l_indx).problem_details_short :=
4092: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_TYP_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 4122: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);

4118: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4119:
4120: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_DEF_SEC;
4121: px_qa_result_tbl(l_indx).suggestion :=
4122: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);
4123: px_qa_result_tbl(l_indx).error_severity := l_severity_def_sec;
4124: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_def_sec;
4125: px_qa_result_tbl(l_indx).problem_details_short :=
4126: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_SH);

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

4122: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_S);
4123: px_qa_result_tbl(l_indx).error_severity := l_severity_def_sec;
4124: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_def_sec;
4125: px_qa_result_tbl(l_indx).problem_details_short :=
4126: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_DEF_SEC_SH);
4127: -- use same as problem_details
4128: l_validation_results(i).error_message;
4129: px_qa_result_tbl(l_indx).problem_details :=
4130: l_validation_results(i).error_message;

Line 4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_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_VAR;
4154: px_qa_result_tbl(l_indx).suggestion :=
4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_S);
4156: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_var;
4157: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_var;
4158: px_qa_result_tbl(l_indx).problem_details_short :=
4159: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_SH);

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

4155: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_S);
4156: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_var;
4157: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_var;
4158: px_qa_result_tbl(l_indx).problem_details_short :=
4159: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAR_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 4189: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);

4185: px_qa_result_tbl(l_indx).qa_code := l_validation_results(i).error_code;
4186:
4187: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_INV_VAL;
4188: px_qa_result_tbl(l_indx).suggestion :=
4189: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);
4190: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_val;
4191: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_val;
4192: px_qa_result_tbl(l_indx).problem_details_short :=
4193: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_SH);

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

4189: OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_S);
4190: px_qa_result_tbl(l_indx).error_severity := l_severity_inv_val;
4191: px_qa_result_tbl(l_indx).problem_short_desc := l_desc_inv_val;
4192: px_qa_result_tbl(l_indx).problem_details_short :=
4193: --OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_INV_VAL_SH);
4194: -- use same as problem_details
4195: l_validation_results(i).error_message;
4196: px_qa_result_tbl(l_indx).problem_details :=
4197: l_validation_results(i).error_message;

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

4346: px_qa_result_tbl(l_indx).title := l_rejected_art.title;
4347: px_qa_result_tbl(l_indx).section_name := l_rejected_art.section;
4348: px_qa_result_tbl(l_indx).qa_code := G_CHECK_ART_REJECTED;
4349: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_REJECTED;
4350: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4351: px_qa_result_tbl(l_indx).error_severity := l_severity;
4352: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4353: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4354: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);

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

4349: px_qa_result_tbl(l_indx).message_name := G_OKC_CHECK_ART_REJECTED;
4350: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4351: px_qa_result_tbl(l_indx).error_severity := l_severity;
4352: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4353: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4354: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4355: END LOOP;
4356: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');

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

4350: px_qa_result_tbl(l_indx).suggestion :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC,G_OKC_CHECK_ART_REJECTED_S);
4351: px_qa_result_tbl(l_indx).error_severity := l_severity;
4352: px_qa_result_tbl(l_indx).problem_short_desc := l_desc;
4353: px_qa_result_tbl(l_indx).problem_details_short :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4354: px_qa_result_tbl(l_indx).problem_details :=OKC_TERMS_UTIL_PVT.Get_Message(G_OKC, G_OKC_CHECK_ART_REJECTED);
4355: END LOOP;
4356: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4358: END IF;

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

4445: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4446: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4447: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4448: KART.SCN_ID SCN_ID,
4449: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,KART.ARTICLE_VERSION_ID) TITLE,
4450: Decode(ART.standard_yn,'N',KART.ref_article_id,NULL) STD_ART_ID
4451: FROM OKC_K_ARTICLES_B KART,
4452: OKC_ARTICLES_ALL ART,
4453: OKC_ARTICLE_VERSIONS VERS

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

4464: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4465: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4466: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4467: KART.SCN_ID SCN_ID,
4468: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4469: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4470: WHERE KART.DOCUMENT_TYPE = p_doc_type
4471: AND KART.DOCUMENT_ID = p_doc_id
4472: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID

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

4475: FROM OKC_ARTICLE_VERSIONS
4476: WHERE ARTICLE_ID=VERS.ARTICLE_ID);
4477: */
4478:
4479: -- 11.5.10+ modified cursor to get the version from OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id
4480: CURSOR l_get_tmpl_articles_csr IS
4481: SELECT KART.ID ID,
4482: KART.SAV_SAE_ID ARTICLE_ID,
4483: STD.ARTICLE_ID STD_ART_ID,

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

4484: KART.ARTICLE_VERSION_ID ARTICLE_VERSION_ID,
4485: KART.AMENDMENT_OPERATION_CODE AMENDMENT_OPERATION_CODE,
4486: KART.AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4487: KART.SCN_ID SCN_ID,
4488: OKC_TERMS_UTIL_PVT.get_article_name(KART.SAV_SAE_ID ,VERS.ARTICLE_VERSION_ID) TITLE
4489: FROM OKC_K_ARTICLES_B KART, OKC_ARTICLE_VERSIONS VERS, OKC_ARTICLE_VERSIONS STD
4490: WHERE KART.DOCUMENT_TYPE = p_doc_type
4491: AND KART.DOCUMENT_ID = p_doc_id
4492: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID

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

4490: WHERE KART.DOCUMENT_TYPE = p_doc_type
4491: AND KART.DOCUMENT_ID = p_doc_id
4492: AND STD.ARTICLE_VERSION_ID(+) = VERS.STD_ARTICLE_VERSION_ID
4493: AND KART.SAV_SAE_ID = VERS.ARTICLE_ID
4494: AND VERS.ARTICLE_VERSION_ID = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
4495: KART.sav_sae_id,
4496: g_start_date,
4497: g_end_date,
4498: g_status_code,

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

4512: OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4513: WHERE XPRT.template_id = p_doc_id
4514: AND ART.article_id = XPRT.clause_id
4515: AND VER.article_id = ART.article_id
4516: AND VER.article_version_id = OKC_TERMS_UTIL_PVT.get_latest_tmpl_art_version_id(
4517: ART.article_id,
4518: g_start_date,
4519: g_end_date,
4520: g_status_code,

Line 4533: okc_terms_util_pvt.get_message('OKC',

4529: AMENDMENT_DESCRIPTION AMENDMENT_DESCRIPTION,
4530: SCN_ID SCN_ID,
4531: SCN_CODE SCN_CODE,
4532: DECODE(LABEL,NULL,HEADING,
4533: okc_terms_util_pvt.get_message('OKC',
4534: 'OKC_TERMS_LABEL_AND_NAME',
4535: 'LABEL', LABEL,
4536: 'NAME', HEADING)) HEADING
4537: FROM OKC_SECTIONS_B