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 FND_API

Line 21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

17: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||G_PKG_NAME||'.';
18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19: G_TMPL_DOC_TYPE CONSTANT VARCHAR2(30) := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
20:
21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
24:
25: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;

Line 22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
19: G_TMPL_DOC_TYPE CONSTANT VARCHAR2(30) := OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE;
20:
21: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
22: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
23: G_OKC CONSTANT VARCHAR2(3) := 'OKC';
24:
25: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;
26: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;

Line 29: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

25: G_QA_STS_SUCCESS CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_SUCCESS;
26: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;
27: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
28:
29: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
30: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
31: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
32:
33: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 30: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

26: G_QA_STS_ERROR CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_ERROR;
27: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
28:
29: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
30: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
31: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
32:
33: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
34: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 31: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

27: G_QA_STS_WARNING CONSTANT varchar2(1) := OKC_TERMS_QA_GRP.G_QA_STS_WARNING;
28:
29: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
30: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
31: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
32:
33: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
34: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
35: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

542: FND_MESSAGE.set_token('ARG_NAME', 'p_qa_code');
543: FND_MESSAGE.set_token('ARG_VALUE', p_qa_code);
544: FND_MSG_PUB.add;
545: FND_MSG_PUB.ADD;
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 549: WHEN FND_API.G_EXC_ERROR THEN

545: FND_MSG_PUB.ADD;
546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
547: END IF;
548: EXCEPTION
549: WHEN FND_API.G_EXC_ERROR THEN
550: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
551: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : OKC_API.G_EXCEPTION_ERROR Exception');
552: END IF;
553: x_return_status := G_RET_STS_ERROR ;

Line 555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

551: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : OKC_API.G_EXCEPTION_ERROR Exception');
552: END IF;
553: x_return_status := G_RET_STS_ERROR ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');
558: END IF;
559: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');

553: x_return_status := G_RET_STS_ERROR ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
556: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
557: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving get_qa_code_detail : FND_API.G_EXC_UNEXPECTED_ERROR Exception');
558: END IF;
559: x_return_status := G_RET_STS_UNEXP_ERROR ;
560:
561: WHEN OTHERS THEN

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

595: x_sequence_id => x_sequence_id
596: );
597:
598: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:

Line 601: RAISE FND_API.G_EXC_ERROR;

597:
598: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: IF p_qa_result_tbl.COUNT > 0 THEN
605: FOR i IN p_qa_result_tbl.FIRST..p_qa_result_tbl.LAST LOOP

Line 635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

631: p_error_record_type_name => p_qa_result_tbl(i).error_record_type_name,
632: p_error_severity_name => p_qa_result_tbl(i).error_severity_name);
633:
634: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
636: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
637: RAISE FND_API.G_EXC_ERROR ;
638: END IF;
639:

Line 637: RAISE FND_API.G_EXC_ERROR ;

633:
634: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
636: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
637: RAISE FND_API.G_EXC_ERROR ;
638: END IF;
639:
640: END LOOP; -- FOR i IN p_qa_result_tbl.FIRST..p_qa_result_tbl.LAST LOOP
641: END IF; -- If p_qa_result_tbl.COUNT > 0 THEN

Line 648: WHEN FND_API.G_EXC_ERROR THEN

644: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1100: Leaving log_qa_messages');
645: END IF;
646:
647: EXCEPTION
648: WHEN FND_API.G_EXC_ERROR THEN
649: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');
651: END IF;
652: x_return_status := G_RET_STS_ERROR ;

Line 654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');
651: END IF;
652: x_return_status := G_RET_STS_ERROR ;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
655: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
656: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1300: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
657: END IF;
658: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

759: x_qa_name => l_incom_desc,
760: x_severity_flag => l_incom_severity,
761: x_return_status => x_return_status);
762: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
764: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
765: RAISE FND_API.G_EXC_ERROR ;
766: END IF;
767:

Line 765: RAISE FND_API.G_EXC_ERROR ;

761: x_return_status => x_return_status);
762: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
764: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
765: RAISE FND_API.G_EXC_ERROR ;
766: END IF;
767:
768: get_qa_code_detail(p_qa_code => G_CHECK_ALTERNATE,
769: x_perform_qa => l_perform_alternate_qa,

Line 774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

770: x_qa_name => l_alternate_desc,
771: x_severity_flag => l_alternate_severity,
772: x_return_status => x_return_status);
773: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
775: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR ;
777: END IF;
778:

Line 776: RAISE FND_API.G_EXC_ERROR ;

772: x_return_status => x_return_status);
773: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
774: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
775: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
776: RAISE FND_API.G_EXC_ERROR ;
777: END IF;
778:
779: IF l_perform_incom_QA ='Y' OR l_perform_alternate_QA='Y' THEN
780:

Line 898: WHEN FND_API.G_EXC_ERROR THEN

894: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
895: END IF;
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
900: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
901: END IF;
902:

Line 914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

910: */
911:
912: x_return_status := G_RET_STS_ERROR ;
913:
914: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
916: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
917: END IF;
918:

Line 1057: WHEN FND_API.G_EXC_ERROR THEN

1053: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1054: END IF;
1055:
1056: EXCEPTION
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1060: END IF;
1061:

Line 1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1060: END IF;
1061:
1062: x_return_status := G_RET_STS_ERROR ;
1063:
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1067: END IF;
1068:

Line 1287: WHEN FND_API.G_EXC_ERROR THEN

1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1284: END IF;
1285:
1286: EXCEPTION
1287: WHEN FND_API.G_EXC_ERROR THEN
1288: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1289: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1290: END IF;
1291:

Line 1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1290: END IF;
1291:
1292: x_return_status := G_RET_STS_ERROR ;
1293:
1294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1295: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1296: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1297: END IF;
1298:

Line 1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1357: x_qa_name => l_desc,
1358: x_severity_flag => l_severity,
1359: x_return_status => x_return_status);
1360: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1362: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1363: RAISE FND_API.G_EXC_ERROR ;
1364: END IF;
1365:

Line 1363: RAISE FND_API.G_EXC_ERROR ;

1359: x_return_status => x_return_status);
1360: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1361: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1362: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1363: RAISE FND_API.G_EXC_ERROR ;
1364: END IF;
1365:
1366: IF l_perform_duplicate_qa ='Y' THEN
1367:

Line 1464: WHEN FND_API.G_EXC_ERROR THEN

1460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1461: END IF;
1462:
1463: EXCEPTION
1464: WHEN FND_API.G_EXC_ERROR THEN
1465: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1467: END IF;
1468:

Line 1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1473: */
1474:
1475: x_return_status := G_RET_STS_ERROR ;
1476:
1477: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1478: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1479: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1480: END IF;
1481:

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1724: x_qa_name => l_desc,
1725: x_severity_flag => l_severity,
1726: x_return_status => x_return_status);
1727: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1729: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1730: RAISE FND_API.G_EXC_ERROR ;
1731: END IF;
1732:

Line 1730: RAISE FND_API.G_EXC_ERROR ;

1726: x_return_status => x_return_status);
1727: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1729: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1730: RAISE FND_API.G_EXC_ERROR ;
1731: END IF;
1732:
1733: IF l_perform_var_usg_qa ='Y' THEN
1734:

Line 1816: WHEN FND_API.G_EXC_ERROR THEN

1812: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1813: END IF;
1814:
1815: EXCEPTION
1816: WHEN FND_API.G_EXC_ERROR THEN
1817: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1818: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_ERROR Exception');
1819: END IF;
1820:

Line 1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1829: */
1830:
1831: x_return_status := G_RET_STS_ERROR ;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1835: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_var_doc_type_usage : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1836: END IF;
1837:

Line 1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1920: x_qa_name => l_int_desc,
1921: x_severity_flag => l_int_severity,
1922: x_return_status => x_return_status);
1923: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1925: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1926: RAISE FND_API.G_EXC_ERROR ;
1927: END IF;
1928:

Line 1926: RAISE FND_API.G_EXC_ERROR ;

1922: x_return_status => x_return_status);
1923: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1924: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1925: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1926: RAISE FND_API.G_EXC_ERROR ;
1927: END IF;
1928:
1929:
1930: FOR csr_udv_with_procs_rec IN csr_get_udv_with_procs LOOP

Line 1941: p_output_error => FND_API.G_FALSE,

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,
1942: x_variable_value => l_variable_value,
1943: x_return_status => l_return_status,
1944: x_msg_data => l_msg_data,
1945: x_msg_count => l_msg_count );

Line 1980: WHEN FND_API.G_EXC_ERROR THEN

1976: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1977: END IF;
1978:
1979: EXCEPTION
1980: WHEN FND_API.G_EXC_ERROR THEN
1981: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1982: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1100: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_ERROR Exception');
1983: END IF;
1984:

Line 1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1987: END IF;
1988:
1989: x_return_status := G_RET_STS_ERROR ;
1990:
1991: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1993: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving check_user_vars_with_procs : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1994: END IF;
1995:

Line 2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2082: x_qa_name => l_sys_desc,
2083: x_severity_flag => l_sys_severity,
2084: x_return_status => x_return_status);
2085: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2087: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR ;
2089: END IF;
2090:

Line 2088: RAISE FND_API.G_EXC_ERROR ;

2084: x_return_status => x_return_status);
2085: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2087: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2088: RAISE FND_API.G_EXC_ERROR ;
2089: END IF;
2090:
2091: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,
2092: x_perform_qa => l_perform_int_qa,

Line 2097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2093: x_qa_name => l_int_desc,
2094: x_severity_flag => l_int_severity,
2095: x_return_status => x_return_status);
2096: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2098: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2099: RAISE FND_API.G_EXC_ERROR ;
2100: END IF;
2101:

Line 2099: RAISE FND_API.G_EXC_ERROR ;

2095: x_return_status => x_return_status);
2096: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2098: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2099: RAISE FND_API.G_EXC_ERROR ;
2100: END IF;
2101:
2102: get_qa_code_detail(p_qa_code => G_CHECK_EXT_VAR_VALUE,
2103: x_perform_qa => l_perform_ext_qa,

Line 2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2104: x_qa_name => l_ext_desc,
2105: x_severity_flag => l_ext_severity,
2106: x_return_status => x_return_status);
2107: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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

Line 2110: RAISE FND_API.G_EXC_ERROR ;

2106: x_return_status => x_return_status);
2107: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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,

Line 2120: p_only_doc_variables => FND_API.G_TRUE,

2116: x_msg_data => l_msg_data,
2117: x_msg_count => l_msg_count,
2118: p_doc_type => p_doc_type,
2119: p_doc_id => p_doc_id,
2120: p_only_doc_variables => FND_API.G_TRUE,
2121: x_sys_var_value_tbl => l_var_value_tbl
2122: );
2123:
2124: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2121: x_sys_var_value_tbl => l_var_value_tbl
2122: );
2123:
2124: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2126: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2127: RAISE FND_API.G_EXC_ERROR ;
2128: END IF;
2129: END IF;-- IF l_perform_sys_qa ='Y' THEN

Line 2127: RAISE FND_API.G_EXC_ERROR ;

2123:
2124: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2126: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2127: RAISE FND_API.G_EXC_ERROR ;
2128: END IF;
2129: END IF;-- IF l_perform_sys_qa ='Y' THEN
2130:
2131: -- Bug# 6002595. Invoking check_user_vars_with_procs to check unresolved user variables with procedures

Line 2142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2138: x_return_status => x_return_status
2139: );
2140:
2141: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2143: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2144: RAISE FND_API.G_EXC_ERROR ;
2145: END IF;
2146:

Line 2144: RAISE FND_API.G_EXC_ERROR ;

2140:
2141: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2142: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2143: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2144: RAISE FND_API.G_EXC_ERROR ;
2145: END IF;
2146:
2147: END IF;
2148: -- End of fix for Bug# 6002595.

Line 2228: WHEN FND_API.G_EXC_ERROR THEN

2224: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2225: END IF;
2226:
2227: EXCEPTION
2228: WHEN FND_API.G_EXC_ERROR THEN
2229: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2230: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2231: END IF;
2232:

Line 2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2235: END IF;
2236:
2237: x_return_status := G_RET_STS_ERROR ;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2241: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2242: END IF;
2243:

Line 2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2302: x_qa_name => l_desc,
2303: x_severity_flag => l_severity,
2304: x_return_status => x_return_status);
2305: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2307: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2308: RAISE FND_API.G_EXC_ERROR ;
2309: END IF;
2310:

Line 2308: RAISE FND_API.G_EXC_ERROR ;

2304: x_return_status => x_return_status);
2305: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2307: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2308: RAISE FND_API.G_EXC_ERROR ;
2309: END IF;
2310:
2311: IF l_perform_unas_art_qa='Y' THEN
2312: FOR cr IN l_get_unass_art_crs LOOP

Line 2337: WHEN FND_API.G_EXC_ERROR THEN

2333: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2334: END IF;
2335:
2336: EXCEPTION
2337: WHEN FND_API.G_EXC_ERROR THEN
2338: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2339: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2340: END IF;
2341:

Line 2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2344: END IF;
2345:
2346: x_return_status := G_RET_STS_ERROR ;
2347:
2348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2349: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2350: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2351: END IF;
2352:

Line 2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2412: x_qa_name => l_desc,
2413: x_severity_flag => l_severity,
2414: x_return_status => x_return_status);
2415: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2417: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR ;
2419: END IF;
2420:

Line 2418: RAISE FND_API.G_EXC_ERROR ;

2414: x_return_status => x_return_status);
2415: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2417: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2418: RAISE FND_API.G_EXC_ERROR ;
2419: END IF;
2420:
2421: IF l_perform_empty_scn_QA='Y' THEN
2422: FOR cr IN l_get_empty_section_csr LOOP

Line 2447: WHEN FND_API.G_EXC_ERROR THEN

2443: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2444: END IF;
2445:
2446: EXCEPTION
2447: WHEN FND_API.G_EXC_ERROR THEN
2448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2449: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2450: END IF;
2451:

Line 2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2454: END IF;
2455:
2456: x_return_status := G_RET_STS_ERROR ;
2457:
2458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2459: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2461: END IF;
2462:

Line 2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2518: x_qa_name => l_desc,
2519: x_severity_flag => l_severity,
2520: x_return_status => x_return_status);
2521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2524: RAISE FND_API.G_EXC_ERROR ;
2525: END IF;
2526:

Line 2524: RAISE FND_API.G_EXC_ERROR ;

2520: x_return_status => x_return_status);
2521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2524: RAISE FND_API.G_EXC_ERROR ;
2525: END IF;
2526:
2527: IF l_perform_scn_amend_qa='Y' THEN
2528: IF l_section_tbl.count>0 THEN

Line 2560: WHEN FND_API.G_EXC_ERROR THEN

2556: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2557: END IF;
2558:
2559: EXCEPTION
2560: WHEN FND_API.G_EXC_ERROR THEN
2561: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_ERROR Exception');
2563: END IF;
2564:

Line 2567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2563: END IF;
2564:
2565: x_return_status := G_RET_STS_ERROR ;
2566:
2567: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2568: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2569: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_Section_Amend_No_Texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2570: END IF;
2571:

Line 2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2619: x_qa_name => l_desc,
2620: x_severity_flag => l_severity,
2621: x_return_status => x_return_status);
2622: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2624: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2625: RAISE FND_API.G_EXC_ERROR ;
2626: END IF;
2627:

Line 2625: RAISE FND_API.G_EXC_ERROR ;

2621: x_return_status => x_return_status);
2622: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2623: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2624: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2625: RAISE FND_API.G_EXC_ERROR ;
2626: END IF;
2627:
2628: IF l_perform_art_amend_qa ='Y' THEN
2629:

Line 2664: WHEN FND_API.G_EXC_ERROR THEN

2660: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2661: END IF;
2662:
2663: EXCEPTION
2664: WHEN FND_API.G_EXC_ERROR THEN
2665: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2666: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_ERROR Exception');
2667: END IF;
2668:

Line 2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2667: END IF;
2668:
2669: x_return_status := G_RET_STS_ERROR ;
2670:
2671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2672: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_article_amend_no_texts : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2674: END IF;
2675:

Line 2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2740: x_qa_name => l_desc,
2741: x_severity_flag => l_severity,
2742: x_return_status => x_return_status);
2743: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2745: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2746: RAISE FND_API.G_EXC_ERROR ;
2747: END IF;
2748:

Line 2746: RAISE FND_API.G_EXC_ERROR ;

2742: x_return_status => x_return_status);
2743: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2745: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2746: RAISE FND_API.G_EXC_ERROR ;
2747: END IF;
2748:
2749: IF l_perform_tmpl_qa ='Y' THEN
2750: FOR cr in l_get_template_crs LOOP

Line 2808: WHEN FND_API.G_EXC_ERROR THEN

2804: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');
2805: END IF;
2806:
2807: EXCEPTION
2808: WHEN FND_API.G_EXC_ERROR THEN
2809: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2810: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2811: END IF;
2812:

Line 2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2815: END IF;
2816:
2817: x_return_status := G_RET_STS_ERROR ;
2818:
2819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2820: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2821: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2822: END IF;
2823:

Line 3062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3058: x_qa_name => l_art_val_desc,
3059: x_severity_flag => l_art_val_severity,
3060: x_return_status => x_return_status);
3061: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3063: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3064: RAISE FND_API.G_EXC_ERROR ;
3065: END IF;
3066:

Line 3064: RAISE FND_API.G_EXC_ERROR ;

3060: x_return_status => x_return_status);
3061: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3063: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3064: RAISE FND_API.G_EXC_ERROR ;
3065: END IF;
3066:
3067: get_qa_code_detail(p_qa_code => G_CHECK_LATEST_VERSION,
3068: x_perform_qa => l_perform_lat_vers_qa,

Line 3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3069: x_qa_name => l_lat_vers_desc,
3070: x_severity_flag => l_lat_vers_severity,
3071: x_return_status => x_return_status);
3072: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3074: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3075: RAISE FND_API.G_EXC_ERROR ;
3076: END IF;
3077:

Line 3075: RAISE FND_API.G_EXC_ERROR ;

3071: x_return_status => x_return_status);
3072: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3074: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3075: RAISE FND_API.G_EXC_ERROR ;
3076: END IF;
3077:
3078: -- 11.5.10+: check should be OR not AND
3079: --IF l_perform_art_val_qa='Y' AND l_perform_lat_vers_qa='Y' THEN

Line 3233: WHEN FND_API.G_EXC_ERROR THEN

3229: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3230: END IF;
3231:
3232: EXCEPTION
3233: WHEN FND_API.G_EXC_ERROR THEN
3234: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3235: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3236: END IF;
3237:

Line 3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3255: */
3256:
3257: x_return_status := G_RET_STS_ERROR ;
3258:
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3261: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3262: END IF;
3263:

Line 3348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3344: x_qa_name => l_desc,
3345: x_severity_flag => l_severity,
3346: x_return_status => x_return_status);
3347: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3349: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3350: RAISE FND_API.G_EXC_ERROR ;
3351: END IF;
3352:

Line 3350: RAISE FND_API.G_EXC_ERROR ;

3346: x_return_status => x_return_status);
3347: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3348: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3349: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3350: RAISE FND_API.G_EXC_ERROR ;
3351: END IF;
3352:
3353:
3354: IF l_perform_layout_tmpl_qa='Y' THEN

Line 3391: WHEN FND_API.G_EXC_ERROR THEN

3387: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3388: END IF;
3389:
3390: EXCEPTION
3391: WHEN FND_API.G_EXC_ERROR THEN
3392: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3393: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3394: END IF;
3395:

Line 3402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3398: END IF;
3399:
3400: x_return_status := G_RET_STS_ERROR ;
3401:
3402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3403: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3404: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3405: END IF;
3406:

Line 3470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3466: x_qa_name => l_desc,
3467: x_severity_flag => l_severity,
3468: x_return_status => x_return_status);
3469: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3471: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3472: RAISE FND_API.G_EXC_ERROR ;
3473: END IF;
3474:

Line 3472: RAISE FND_API.G_EXC_ERROR ;

3468: x_return_status => x_return_status);
3469: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3471: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3472: RAISE FND_API.G_EXC_ERROR ;
3473: END IF;
3474:
3475:
3476: IF l_perform_trans_rev_qa ='Y' THEN

Line 3513: WHEN FND_API.G_EXC_ERROR THEN

3509: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3510: END IF;
3511:
3512: EXCEPTION
3513: WHEN FND_API.G_EXC_ERROR THEN
3514: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3515: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3516: END IF;
3517:

Line 3524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3520: END IF;
3521:
3522: x_return_status := G_RET_STS_ERROR ;
3523:
3524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3525: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3526: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3527: END IF;
3528:

Line 3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3588: x_qa_name => l_desc,
3589: x_severity_flag => l_severity,
3590: x_return_status => x_return_status);
3591: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3593: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3594: RAISE FND_API.G_EXC_ERROR ;
3595: END IF;
3596:

Line 3594: RAISE FND_API.G_EXC_ERROR ;

3590: x_return_status => x_return_status);
3591: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3592: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3593: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3594: RAISE FND_API.G_EXC_ERROR ;
3595: END IF;
3596:
3597:
3598: IF l_perform_trans_tmpl_eff_qa ='Y' THEN

Line 3635: WHEN FND_API.G_EXC_ERROR THEN

3631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3632: END IF;
3633:
3634: EXCEPTION
3635: WHEN FND_API.G_EXC_ERROR THEN
3636: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3637: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3638: END IF;
3639:

Line 3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3642: END IF;
3643:
3644: x_return_status := G_RET_STS_ERROR ;
3645:
3646: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3647: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3648: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3649: END IF;
3650:

Line 3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3699: x_qa_name => l_desc,
3700: x_severity_flag => l_severity,
3701: x_return_status => x_return_status);
3702: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3704: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3705: RAISE FND_API.G_EXC_ERROR ;
3706: END IF;
3707:

Line 3705: RAISE FND_API.G_EXC_ERROR ;

3701: x_return_status => x_return_status);
3702: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3703: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3704: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3705: RAISE FND_API.G_EXC_ERROR ;
3706: END IF;
3707:
3708:
3709: IF (l_perform_articles_exist_qa <> 'Y') THEN

Line 3747: WHEN FND_API.G_EXC_ERROR THEN

3743: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3744: END IF;
3745:
3746: EXCEPTION
3747: WHEN FND_API.G_EXC_ERROR THEN
3748: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3749: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3750: END IF;
3751:

Line 3754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3750: END IF;
3751:
3752: x_return_status := G_RET_STS_ERROR ;
3753:
3754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3755: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3756: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3757: END IF;
3758:

Line 3911: p_init_msg_list => FND_API.G_FALSE,

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,
3914: x_drafts_present => l_drafts_present,
3915: x_return_status => x_return_status,

Line 3919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3915: x_return_status => x_return_status,
3916: x_msg_count => x_msg_count,
3917: x_msg_data => x_msg_data);
3918: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3920: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
3923: end;

Line 3921: RAISE FND_API.G_EXC_ERROR;

3917: x_msg_data => x_msg_data);
3918: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3920: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3921: RAISE FND_API.G_EXC_ERROR;
3922: END IF;
3923: end;
3924: -- bug 4159533 end
3925: -- the above code simulates template submittion else the below

Line 3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3941: x_qa_name => l_desc_art_typ,
3942: x_severity_flag => l_severity_art_typ,
3943: x_return_status => x_return_status);
3944: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3946: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3947: RAISE FND_API.G_EXC_ERROR ;
3948: END IF;
3949:

Line 3947: RAISE FND_API.G_EXC_ERROR ;

3943: x_return_status => x_return_status);
3944: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3946: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3947: RAISE FND_API.G_EXC_ERROR ;
3948: END IF;
3949:
3950: get_qa_code_detail(p_qa_code => G_CHECK_ART_DEF_SEC,
3951: x_perform_qa => l_perform_qa_def_sec,

Line 3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3952: x_qa_name => l_desc_def_sec,
3953: x_severity_flag => l_severity_def_sec,
3954: x_return_status => x_return_status);
3955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3958: RAISE FND_API.G_EXC_ERROR ;
3959: END IF;
3960:

Line 3958: RAISE FND_API.G_EXC_ERROR ;

3954: x_return_status => x_return_status);
3955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3958: RAISE FND_API.G_EXC_ERROR ;
3959: END IF;
3960:
3961: get_qa_code_detail(p_qa_code => G_CHECK_ART_INV_VAR,
3962: x_perform_qa => l_perform_qa_inv_var,

Line 3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3963: x_qa_name => l_desc_inv_var,
3964: x_severity_flag => l_severity_inv_var,
3965: x_return_status => x_return_status);
3966: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3968: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3969: RAISE FND_API.G_EXC_ERROR ;
3970: END IF;
3971:

Line 3969: RAISE FND_API.G_EXC_ERROR ;

3965: x_return_status => x_return_status);
3966: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3967: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3968: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3969: RAISE FND_API.G_EXC_ERROR ;
3970: END IF;
3971:
3972: get_qa_code_detail(p_qa_code => G_CHECK_ART_INV_VAL,
3973: x_perform_qa => l_perform_qa_inv_val,

Line 3978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3974: x_qa_name => l_desc_inv_val,
3975: x_severity_flag => l_severity_inv_val,
3976: x_return_status => x_return_status);
3977: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3979: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3980: RAISE FND_API.G_EXC_ERROR ;
3981: END IF;
3982:

Line 3980: RAISE FND_API.G_EXC_ERROR ;

3976: x_return_status => x_return_status);
3977: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3979: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3980: RAISE FND_API.G_EXC_ERROR ;
3981: END IF;
3982:
3983:
3984: l_art_ver_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();

Line 4002: p_init_msg_list => FND_API.G_FALSE,

3998: ) THEN
3999:
4000: OKC_ART_BLK_PVT.validate_article_versions_blk(
4001: p_api_version => 1.0 ,
4002: p_init_msg_list => FND_API.G_FALSE,
4003: p_commit => FND_API.G_FALSE,
4004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4005: x_return_status => x_return_status,
4006: x_msg_count => l_msg_count,

Line 4003: p_commit => FND_API.G_FALSE,

3999:
4000: OKC_ART_BLK_PVT.validate_article_versions_blk(
4001: p_api_version => 1.0 ,
4002: p_init_msg_list => FND_API.G_FALSE,
4003: p_commit => FND_API.G_FALSE,
4004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4005: x_return_status => x_return_status,
4006: x_msg_count => l_msg_count,
4007: x_msg_data => l_msg_data,

Line 4004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4000: OKC_ART_BLK_PVT.validate_article_versions_blk(
4001: p_api_version => 1.0 ,
4002: p_init_msg_list => FND_API.G_FALSE,
4003: p_commit => FND_API.G_FALSE,
4004: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4005: x_return_status => x_return_status,
4006: x_msg_count => l_msg_count,
4007: x_msg_data => l_msg_data,
4008: p_org_id => g_org_id,

Line 4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4010: x_qa_return_status => l_qa_return_status,
4011: x_validation_results => l_validation_results
4012: );
4013: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4015: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4016: RAISE FND_API.G_EXC_ERROR ;
4017: END IF;
4018:

Line 4016: RAISE FND_API.G_EXC_ERROR ;

4012: );
4013: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4015: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4016: RAISE FND_API.G_EXC_ERROR ;
4017: END IF;
4018:
4019: ELSE
4020: -- nothing to validate

Line 4200: WHEN FND_API.G_EXC_ERROR THEN

4196: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4197: END IF;
4198:
4199: EXCEPTION
4200: WHEN FND_API.G_EXC_ERROR THEN
4201: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4202: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4203: END IF;
4204:

Line 4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4207: END IF;
4208:
4209: x_return_status := G_RET_STS_ERROR ;
4210:
4211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4212: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4213: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4214: END IF;
4215:

Line 4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4288: x_qa_name => l_desc,
4289: x_severity_flag => l_severity,
4290: x_return_status => x_return_status);
4291: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4293: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4294: RAISE FND_API.G_EXC_ERROR ;
4295: END IF;
4296:

Line 4294: RAISE FND_API.G_EXC_ERROR ;

4290: x_return_status => x_return_status);
4291: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4292: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4293: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4294: RAISE FND_API.G_EXC_ERROR ;
4295: END IF;
4296:
4297:
4298: IF (l_perform_articles_exist_qa <> 'Y') THEN

Line 4327: WHEN FND_API.G_EXC_ERROR THEN

4323: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4324: END IF;
4325:
4326: EXCEPTION
4327: WHEN FND_API.G_EXC_ERROR THEN
4328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4330: END IF;
4331:

Line 4338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4334: END IF;
4335:
4336: x_return_status := G_RET_STS_ERROR ;
4337:
4338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4339: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4340: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4341: END IF;
4342:

Line 4626: p_init_msg_list => FND_API.G_FALSE,

4622: -- Modify the severity level of the qa check for existence of clauses
4623: -- to 'W' (warning) if the template contains deliverables. It is 'E' otherwise.
4624: if okc_terms_util_grp.Is_Deliverable_Exist(
4625: p_api_version => 1,
4626: p_init_msg_list => FND_API.G_FALSE,
4627: x_return_status => x_return_status,
4628: x_msg_data => x_msg_data,
4629: x_msg_count => x_msg_count,
4630: p_doc_type => 'TEMPLATE',

Line 4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4718: px_qa_result_tbl => x_qa_result_tbl,
4719: x_return_status => x_return_status
4720: );
4721: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4723: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4724: RAISE FND_API.G_EXC_ERROR ;
4725: END IF;
4726:

Line 4724: RAISE FND_API.G_EXC_ERROR ;

4720: );
4721: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4723: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4724: RAISE FND_API.G_EXC_ERROR ;
4725: END IF;
4726:
4727: --call new internal procedure to check for article existence
4728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4734: px_qa_result_tbl => x_qa_result_tbl,
4735: x_return_status => x_return_status
4736: );
4737: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4739: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4740: RAISE FND_API.G_EXC_ERROR ;
4741: END IF;
4742:

Line 4740: RAISE FND_API.G_EXC_ERROR ;

4736: );
4737: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4738: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4739: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4740: RAISE FND_API.G_EXC_ERROR ;
4741: END IF;
4742:
4743: --call new internal procedure to validate any draft articles
4744: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4750: px_qa_result_tbl => x_qa_result_tbl,
4751: x_return_status => x_return_status
4752: );
4753: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4755: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4756: RAISE FND_API.G_EXC_ERROR ;
4757: END IF;
4758:

Line 4756: RAISE FND_API.G_EXC_ERROR ;

4752: );
4753: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4755: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4756: RAISE FND_API.G_EXC_ERROR ;
4757: END IF;
4758:
4759: -- For Bug# 6979012
4760: --call new internal procedure to give a warning for rejected articles

Line 4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4767: px_qa_result_tbl => x_qa_result_tbl,
4768: x_return_status => x_return_status
4769: );
4770: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4772: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4773: RAISE FND_API.G_EXC_ERROR ;
4774: END IF;
4775: -- Changes for Bug# 6979012 Ends

Line 4773: RAISE FND_API.G_EXC_ERROR ;

4769: );
4770: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4772: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4773: RAISE FND_API.G_EXC_ERROR ;
4774: END IF;
4775: -- Changes for Bug# 6979012 Ends
4776:
4777: --MLS for templates

Line 4788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4784: px_qa_result_tbl => x_qa_result_tbl,
4785: x_return_status => x_return_status
4786: );
4787: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4789: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4790: RAISE FND_API.G_EXC_ERROR ;
4791: END IF;
4792:

Line 4790: RAISE FND_API.G_EXC_ERROR ;

4786: );
4787: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4789: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4790: RAISE FND_API.G_EXC_ERROR ;
4791: END IF;
4792:
4793: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4794: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');

Line 4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4799: px_qa_result_tbl => x_qa_result_tbl,
4800: x_return_status => x_return_status
4801: );
4802: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4804: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4805: RAISE FND_API.G_EXC_ERROR ;
4806: END IF;
4807: --MLS for templates

Line 4805: RAISE FND_API.G_EXC_ERROR ;

4801: );
4802: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4804: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4805: RAISE FND_API.G_EXC_ERROR ;
4806: END IF;
4807: --MLS for templates
4808:
4809:

Line 4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4823: px_qa_result_tbl => x_qa_result_tbl,
4824: x_return_status => x_return_status
4825: );
4826: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4828: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4829: RAISE FND_API.G_EXC_ERROR ;
4830: END IF;
4831:

Line 4829: RAISE FND_API.G_EXC_ERROR ;

4825: );
4826: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4827: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4828: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4829: RAISE FND_API.G_EXC_ERROR ;
4830: END IF;
4831:
4832: --------------------------------------------
4833: -- QA Check for Duplicate articles

Line 4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4842: px_qa_result_tbl => x_qa_result_tbl,
4843: x_return_status => x_return_status
4844: );
4845: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4847: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4848: RAISE FND_API.G_EXC_ERROR ;
4849: END IF;
4850:

Line 4848: RAISE FND_API.G_EXC_ERROR ;

4844: );
4845: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4847: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4848: RAISE FND_API.G_EXC_ERROR ;
4849: END IF;
4850:
4851: --------------------------------------------
4852: -- QA Check for variable-doc type usage

Line 4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4861: px_qa_result_tbl => x_qa_result_tbl,
4862: x_return_status => x_return_status
4863: );
4864: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4866: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4867: RAISE FND_API.G_EXC_ERROR ;
4868: END IF;
4869:

Line 4867: RAISE FND_API.G_EXC_ERROR ;

4863: );
4864: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4865: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4866: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4867: RAISE FND_API.G_EXC_ERROR ;
4868: END IF;
4869:
4870: ----------------------------------------------------------------
4871: -- QA Check for article effectivity and old version of article

Line 4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4880: px_qa_result_tbl => x_qa_result_tbl,
4881: x_return_status => x_return_status
4882: );
4883: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4885: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4886: RAISE FND_API.G_EXC_ERROR ;
4887: END IF;
4888:

Line 4886: RAISE FND_API.G_EXC_ERROR ;

4882: );
4883: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4884: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4885: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4886: RAISE FND_API.G_EXC_ERROR ;
4887: END IF;
4888:
4889:
4890: -----------------------------------------------------------------------

Line 4908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4904: px_qa_result_tbl => x_qa_result_tbl,
4905: x_return_status => x_return_status
4906: );
4907: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4909: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4910: RAISE FND_API.G_EXC_ERROR ;
4911: END IF;
4912:

Line 4910: RAISE FND_API.G_EXC_ERROR ;

4906: );
4907: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4909: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4910: RAISE FND_API.G_EXC_ERROR ;
4911: END IF;
4912:
4913: ---------------------------------------------------------
4914: -- QA Check for unassigned articles

Line 4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4922: px_qa_result_tbl => x_qa_result_tbl,
4923: x_return_status => x_return_status
4924: );
4925: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4927: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4928: RAISE FND_API.G_EXC_ERROR ;
4929: END IF;
4930:

Line 4928: RAISE FND_API.G_EXC_ERROR ;

4924: );
4925: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4926: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4927: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4928: RAISE FND_API.G_EXC_ERROR ;
4929: END IF;
4930:
4931: ---------------------------------------------------------------
4932: -- QA Check for empty sections

Line 4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4940: px_qa_result_tbl => x_qa_result_tbl,
4941: x_return_status => x_return_status
4942: );
4943: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4945: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4946: RAISE FND_API.G_EXC_ERROR ;
4947: END IF;
4948:

Line 4946: RAISE FND_API.G_EXC_ERROR ;

4942: );
4943: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4944: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4945: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4946: RAISE FND_API.G_EXC_ERROR ;
4947: END IF;
4948:
4949: ---------------------------------------------------------------
4950: -- QA Check for inactive template

Line 4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4958: px_qa_result_tbl => x_qa_result_tbl,
4959: x_return_status => x_return_status
4960: );
4961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4964: RAISE FND_API.G_EXC_ERROR ;
4965: END IF;
4966:

Line 4964: RAISE FND_API.G_EXC_ERROR ;

4960: );
4961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4964: RAISE FND_API.G_EXC_ERROR ;
4965: END IF;
4966:
4967: IF p_qa_mode = G_AMEND_QA THEN
4968:

Line 4982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4978: px_qa_result_tbl => x_qa_result_tbl,
4979: x_return_status => x_return_status
4980: );
4981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4984: RAISE FND_API.G_EXC_ERROR ;
4985: END IF;
4986:

Line 4984: RAISE FND_API.G_EXC_ERROR ;

4980: );
4981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4984: RAISE FND_API.G_EXC_ERROR ;
4985: END IF;
4986:
4987: ------------------------------------------------------------
4988: -- QA Check for Amended section with no description

Line 5000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4996: px_qa_result_tbl => x_qa_result_tbl,
4997: x_return_status => x_return_status
4998: );
4999: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5001: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5002: RAISE FND_API.G_EXC_ERROR ;
5003: END IF;
5004:

Line 5002: RAISE FND_API.G_EXC_ERROR ;

4998: );
4999: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5001: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5002: RAISE FND_API.G_EXC_ERROR ;
5003: END IF;
5004:
5005: END IF; -- IF p_qa_mode = G_AMEND_QA THEN
5006:

Line 5020: p_init_msg_list => FND_API.G_FALSE,

5016: IF p_doc_type = G_TMPL_DOC_TYPE THEN
5017: --Added 11.5.10+ CE
5018: OKC_XPRT_UTIL_PVT.validate_template_for_expert (
5019: p_api_version => 1,
5020: p_init_msg_list => FND_API.G_FALSE,
5021: p_template_id => p_doc_id,
5022: x_msg_data => x_msg_data,
5023: x_msg_count => x_msg_count,
5024: x_qa_result_tbl => x_qa_result_tbl,

Line 5033: p_init_msg_list => FND_API.G_FALSE,

5029: -- Bug# 4874729. Not invoking expert validation for OKS doc type.
5030:
5031: OKC_XPRT_UTIL_PVT.contract_expert_bv (
5032: p_api_version => 1,
5033: p_init_msg_list => FND_API.G_FALSE,
5034: p_document_type => p_doc_type,
5035: p_document_id => p_doc_id,
5036: p_bv_mode => 'QA',
5037: x_expert_articles_tbl => l_expert_articles_tbl,

Line 5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

5043: END IF;
5044: END IF;
5045:
5046: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5048: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5049: RAISE FND_API.G_EXC_ERROR ;
5050: END IF;
5051:

Line 5049: RAISE FND_API.G_EXC_ERROR ;

5045:
5046: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5047: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5048: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5049: RAISE FND_API.G_EXC_ERROR ;
5050: END IF;
5051:
5052: --****************************************--
5053: -- End of validation set --

Line 5095: WHEN FND_API.G_EXC_ERROR THEN

5091: END IF;
5092: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5093:
5094: EXCEPTION
5095: WHEN FND_API.G_EXC_ERROR THEN
5096: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5097: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5098: END IF;
5099:

Line 5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5121:
5122: x_return_status := G_RET_STS_ERROR ;
5123: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5124:
5125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5126: ROLLBACK TO g_QA_Doc;
5127: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5128: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5129: END IF;