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 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Incomp_and_alternate');
1303: END IF;
1304:
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1308: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_Incomp_and_alternate : OKC_API.G_EXCEPTION_ERROR Exception');
1309: END IF;
1310:

Line 1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1309: END IF;
1310:
1311: x_return_status := G_RET_STS_ERROR ;
1312:
1313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1314: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1315: 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');
1316: END IF;
1317:

Line 1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1376: x_qa_name => l_desc,
1377: x_severity_flag => l_severity,
1378: x_return_status => x_return_status);
1379: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1381: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1382: RAISE FND_API.G_EXC_ERROR ;
1383: END IF;
1384:

Line 1382: RAISE FND_API.G_EXC_ERROR ;

1378: x_return_status => x_return_status);
1379: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1381: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1382: RAISE FND_API.G_EXC_ERROR ;
1383: END IF;
1384:
1385: IF l_perform_duplicate_qa ='Y' THEN
1386:

Line 1483: WHEN FND_API.G_EXC_ERROR THEN

1479: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_duplicate_articles');
1480: END IF;
1481:
1482: EXCEPTION
1483: WHEN FND_API.G_EXC_ERROR THEN
1484: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1485: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');
1486: END IF;
1487:

Line 1496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1492: */
1493:
1494: x_return_status := G_RET_STS_ERROR ;
1495:
1496: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1497: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1498: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1499: END IF;
1500:

Line 1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1743: x_qa_name => l_desc,
1744: x_severity_flag => l_severity,
1745: x_return_status => x_return_status);
1746: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1748: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1749: RAISE FND_API.G_EXC_ERROR ;
1750: END IF;
1751:

Line 1749: RAISE FND_API.G_EXC_ERROR ;

1745: x_return_status => x_return_status);
1746: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1748: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1749: RAISE FND_API.G_EXC_ERROR ;
1750: END IF;
1751:
1752: IF l_perform_var_usg_qa ='Y' THEN
1753:

Line 1835: WHEN FND_API.G_EXC_ERROR THEN

1831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_var_doc_type_usage');
1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1837: 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');
1838: END IF;
1839:

Line 1852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1848: */
1849:
1850: x_return_status := G_RET_STS_ERROR ;
1851:
1852: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1853: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1854: 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');
1855: END IF;
1856:

Line 1943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1939: x_qa_name => l_int_desc,
1940: x_severity_flag => l_int_severity,
1941: x_return_status => x_return_status);
1942: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1944: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1945: RAISE FND_API.G_EXC_ERROR ;
1946: END IF;
1947:

Line 1945: RAISE FND_API.G_EXC_ERROR ;

1941: x_return_status => x_return_status);
1942: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1944: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1945: RAISE FND_API.G_EXC_ERROR ;
1946: END IF;
1947:
1948:
1949: FOR csr_udv_with_procs_rec IN csr_get_udv_with_procs LOOP

Line 1960: p_output_error => FND_API.G_FALSE,

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,
1961: x_variable_value => l_variable_value,
1962: x_return_status => l_return_status,
1963: x_msg_data => l_msg_data,
1964: x_msg_count => l_msg_count );

Line 1999: WHEN FND_API.G_EXC_ERROR THEN

1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'600: Leaving check_user_vars_with_procs');
1996: END IF;
1997:
1998: EXCEPTION
1999: WHEN FND_API.G_EXC_ERROR THEN
2000: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2001: 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');
2002: END IF;
2003:

Line 2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2006: END IF;
2007:
2008: x_return_status := G_RET_STS_ERROR ;
2009:
2010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: 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');
2013: END IF;
2014:

Line 2108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2104: x_qa_name => l_sys_desc,
2105: x_severity_flag => l_sys_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:

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:
2113: get_qa_code_detail(p_qa_code => G_CHECK_INT_VAR_VALUE,
2114: x_perform_qa => l_perform_int_qa,

Line 2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2115: x_qa_name => l_int_desc,
2116: x_severity_flag => l_int_severity,
2117: x_return_status => x_return_status);
2118: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2120: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2121: RAISE FND_API.G_EXC_ERROR ;
2122: END IF;
2123:

Line 2121: RAISE FND_API.G_EXC_ERROR ;

2117: x_return_status => x_return_status);
2118: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2120: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2121: RAISE FND_API.G_EXC_ERROR ;
2122: END IF;
2123:
2124: get_qa_code_detail(p_qa_code => G_CHECK_EXT_VAR_VALUE,
2125: x_perform_qa => l_perform_ext_qa,

Line 2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2126: x_qa_name => l_ext_desc,
2127: x_severity_flag => l_ext_severity,
2128: x_return_status => x_return_status);
2129: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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

Line 2132: RAISE FND_API.G_EXC_ERROR ;

2128: x_return_status => x_return_status);
2129: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
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,

Line 2142: p_only_doc_variables => FND_API.G_TRUE,

2138: x_msg_data => l_msg_data,
2139: x_msg_count => l_msg_count,
2140: p_doc_type => p_doc_type,
2141: p_doc_id => p_doc_id,
2142: p_only_doc_variables => FND_API.G_TRUE,
2143: x_sys_var_value_tbl => l_var_value_tbl
2144: );
2145:
2146: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2143: x_sys_var_value_tbl => l_var_value_tbl
2144: );
2145:
2146: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2148: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR ;
2150: END IF;
2151: END IF;-- IF l_perform_sys_qa ='Y' THEN

Line 2149: RAISE FND_API.G_EXC_ERROR ;

2145:
2146: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2148: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR ;
2150: END IF;
2151: END IF;-- IF l_perform_sys_qa ='Y' THEN
2152:
2153: -- Bug# 6002595. Invoking check_user_vars_with_procs to check unresolved user variables with procedures

Line 2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2160: x_return_status => x_return_status
2161: );
2162:
2163: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2165: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2166: RAISE FND_API.G_EXC_ERROR ;
2167: END IF;
2168:

Line 2166: RAISE FND_API.G_EXC_ERROR ;

2162:
2163: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2165: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2166: RAISE FND_API.G_EXC_ERROR ;
2167: END IF;
2168:
2169: END IF;
2170: -- End of fix for Bug# 6002595.

Line 2262: WHEN FND_API.G_EXC_ERROR THEN

2258: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_variables');
2259: END IF;
2260:
2261: EXCEPTION
2262: WHEN FND_API.G_EXC_ERROR THEN
2263: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2264: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');
2265: END IF;
2266:

Line 2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2269: END IF;
2270:
2271: x_return_status := G_RET_STS_ERROR ;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2276: END IF;
2277:

Line 2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2336: x_qa_name => l_desc,
2337: x_severity_flag => l_severity,
2338: x_return_status => x_return_status);
2339: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2341: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2342: RAISE FND_API.G_EXC_ERROR ;
2343: END IF;
2344:

Line 2342: RAISE FND_API.G_EXC_ERROR ;

2338: x_return_status => x_return_status);
2339: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2341: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2342: RAISE FND_API.G_EXC_ERROR ;
2343: END IF;
2344:
2345: IF l_perform_unas_art_qa='Y' THEN
2346: FOR cr IN l_get_unass_art_crs LOOP

Line 2371: WHEN FND_API.G_EXC_ERROR THEN

2367: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_unassigned_articles');
2368: END IF;
2369:
2370: EXCEPTION
2371: WHEN FND_API.G_EXC_ERROR THEN
2372: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');
2374: END IF;
2375:

Line 2382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2378: END IF;
2379:
2380: x_return_status := G_RET_STS_ERROR ;
2381:
2382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2383: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2384: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2385: END IF;
2386:

Line 2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2446: x_qa_name => l_desc,
2447: x_severity_flag => l_severity,
2448: x_return_status => x_return_status);
2449: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2451: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2452: RAISE FND_API.G_EXC_ERROR ;
2453: END IF;
2454:

Line 2452: RAISE FND_API.G_EXC_ERROR ;

2448: x_return_status => x_return_status);
2449: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2450: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2451: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2452: RAISE FND_API.G_EXC_ERROR ;
2453: END IF;
2454:
2455: IF l_perform_empty_scn_QA='Y' THEN
2456: FOR cr IN l_get_empty_section_csr LOOP

Line 2481: WHEN FND_API.G_EXC_ERROR THEN

2477: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_empty_sections');
2478: END IF;
2479:
2480: EXCEPTION
2481: WHEN FND_API.G_EXC_ERROR THEN
2482: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2483: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');
2484: END IF;
2485:

Line 2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2488: END IF;
2489:
2490: x_return_status := G_RET_STS_ERROR ;
2491:
2492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2493: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2494: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_empty_sections : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2495: END IF;
2496:

Line 2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2552: x_qa_name => l_desc,
2553: x_severity_flag => l_severity,
2554: x_return_status => x_return_status);
2555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2558: RAISE FND_API.G_EXC_ERROR ;
2559: END IF;
2560:

Line 2558: RAISE FND_API.G_EXC_ERROR ;

2554: x_return_status => x_return_status);
2555: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2556: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2557: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2558: RAISE FND_API.G_EXC_ERROR ;
2559: END IF;
2560:
2561: IF l_perform_scn_amend_qa='Y' THEN
2562: IF l_section_tbl.count>0 THEN

Line 2594: WHEN FND_API.G_EXC_ERROR THEN

2590: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_Section_Amend_No_Texts');
2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2596: 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');
2597: END IF;
2598:

Line 2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2597: END IF;
2598:
2599: x_return_status := G_RET_STS_ERROR ;
2600:
2601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2602: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2603: 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');
2604: END IF;
2605:

Line 2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2653: x_qa_name => l_desc,
2654: x_severity_flag => l_severity,
2655: x_return_status => x_return_status);
2656: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2658: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2659: RAISE FND_API.G_EXC_ERROR ;
2660: END IF;
2661:

Line 2659: RAISE FND_API.G_EXC_ERROR ;

2655: x_return_status => x_return_status);
2656: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2658: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2659: RAISE FND_API.G_EXC_ERROR ;
2660: END IF;
2661:
2662: IF l_perform_art_amend_qa ='Y' THEN
2663:

Line 2698: WHEN FND_API.G_EXC_ERROR THEN

2694: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_article_amend_no_texts');
2695: END IF;
2696:
2697: EXCEPTION
2698: WHEN FND_API.G_EXC_ERROR THEN
2699: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: 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');
2701: END IF;
2702:

Line 2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2701: END IF;
2702:
2703: x_return_status := G_RET_STS_ERROR ;
2704:
2705: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2706: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2707: 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');
2708: END IF;
2709:

Line 2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

2774: x_qa_name => l_desc,
2775: x_severity_flag => l_severity,
2776: x_return_status => x_return_status);
2777: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2779: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2780: RAISE FND_API.G_EXC_ERROR ;
2781: END IF;
2782:

Line 2780: RAISE FND_API.G_EXC_ERROR ;

2776: x_return_status => x_return_status);
2777: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
2779: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2780: RAISE FND_API.G_EXC_ERROR ;
2781: END IF;
2782:
2783: IF l_perform_tmpl_qa ='Y' THEN
2784: FOR cr in l_get_template_crs LOOP

Line 2842: WHEN FND_API.G_EXC_ERROR THEN

2838: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_inactive_template');
2839: END IF;
2840:
2841: EXCEPTION
2842: WHEN FND_API.G_EXC_ERROR THEN
2843: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');
2845: END IF;
2846:

Line 2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2849: END IF;
2850:
2851: x_return_status := G_RET_STS_ERROR ;
2852:
2853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2854: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2855: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_inactive_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2856: END IF;
2857:

Line 3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3092: x_qa_name => l_art_val_desc,
3093: x_severity_flag => l_art_val_severity,
3094: x_return_status => x_return_status);
3095: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3097: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3098: RAISE FND_API.G_EXC_ERROR ;
3099: END IF;
3100:

Line 3098: RAISE FND_API.G_EXC_ERROR ;

3094: x_return_status => x_return_status);
3095: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3097: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3098: RAISE FND_API.G_EXC_ERROR ;
3099: END IF;
3100:
3101: get_qa_code_detail(p_qa_code => G_CHECK_LATEST_VERSION,
3102: x_perform_qa => l_perform_lat_vers_qa,

Line 3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3103: x_qa_name => l_lat_vers_desc,
3104: x_severity_flag => l_lat_vers_severity,
3105: x_return_status => x_return_status);
3106: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3108: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3109: RAISE FND_API.G_EXC_ERROR ;
3110: END IF;
3111:

Line 3109: RAISE FND_API.G_EXC_ERROR ;

3105: x_return_status => x_return_status);
3106: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3108: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3109: RAISE FND_API.G_EXC_ERROR ;
3110: END IF;
3111:
3112: -- 11.5.10+: check should be OR not AND
3113: --IF l_perform_art_val_qa='Y' AND l_perform_lat_vers_qa='Y' THEN

Line 3267: WHEN FND_API.G_EXC_ERROR THEN

3263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_art_effectivity');
3264: END IF;
3265:
3266: EXCEPTION
3267: WHEN FND_API.G_EXC_ERROR THEN
3268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3270: END IF;
3271:

Line 3293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3289: */
3290:
3291: x_return_status := G_RET_STS_ERROR ;
3292:
3293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3294: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3295: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3296: END IF;
3297:

Line 3382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3378: x_qa_name => l_desc,
3379: x_severity_flag => l_severity,
3380: x_return_status => x_return_status);
3381: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3383: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3384: RAISE FND_API.G_EXC_ERROR ;
3385: END IF;
3386:

Line 3384: RAISE FND_API.G_EXC_ERROR ;

3380: x_return_status => x_return_status);
3381: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3383: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3384: RAISE FND_API.G_EXC_ERROR ;
3385: END IF;
3386:
3387:
3388: IF l_perform_layout_tmpl_qa='Y' THEN

Line 3425: WHEN FND_API.G_EXC_ERROR THEN

3421: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_layout_template');
3422: END IF;
3423:
3424: EXCEPTION
3425: WHEN FND_API.G_EXC_ERROR THEN
3426: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');
3428: END IF;
3429:

Line 3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3432: END IF;
3433:
3434: x_return_status := G_RET_STS_ERROR ;
3435:
3436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3437: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3438: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_layout_template : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3439: END IF;
3440:

Line 3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3500: x_qa_name => l_desc,
3501: x_severity_flag => l_severity,
3502: x_return_status => x_return_status);
3503: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3505: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3506: RAISE FND_API.G_EXC_ERROR ;
3507: END IF;
3508:

Line 3506: RAISE FND_API.G_EXC_ERROR ;

3502: x_return_status => x_return_status);
3503: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3504: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3505: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3506: RAISE FND_API.G_EXC_ERROR ;
3507: END IF;
3508:
3509:
3510: IF l_perform_trans_rev_qa ='Y' THEN

Line 3547: WHEN FND_API.G_EXC_ERROR THEN

3543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_revision');
3544: END IF;
3545:
3546: EXCEPTION
3547: WHEN FND_API.G_EXC_ERROR THEN
3548: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3549: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_revision : OKC_API.G_EXCEPTION_ERROR Exception');
3550: END IF;
3551:

Line 3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3554: END IF;
3555:
3556: x_return_status := G_RET_STS_ERROR ;
3557:
3558: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3559: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3560: 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');
3561: END IF;
3562:

Line 3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3622: x_qa_name => l_desc,
3623: x_severity_flag => l_severity,
3624: x_return_status => x_return_status);
3625: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3627: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3628: RAISE FND_API.G_EXC_ERROR ;
3629: END IF;
3630:

Line 3628: RAISE FND_API.G_EXC_ERROR ;

3624: x_return_status => x_return_status);
3625: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3627: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3628: RAISE FND_API.G_EXC_ERROR ;
3629: END IF;
3630:
3631:
3632: IF l_perform_trans_tmpl_eff_qa ='Y' THEN

Line 3669: WHEN FND_API.G_EXC_ERROR THEN

3665: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving Check_translated_tmpl_effectivity');
3666: END IF;
3667:
3668: EXCEPTION
3669: WHEN FND_API.G_EXC_ERROR THEN
3670: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3671: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_translated_tmpl_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');
3672: END IF;
3673:

Line 3680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3676: END IF;
3677:
3678: x_return_status := G_RET_STS_ERROR ;
3679:
3680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3681: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3682: 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');
3683: END IF;
3684:

Line 3737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3733: x_qa_name => l_desc,
3734: x_severity_flag => l_severity,
3735: x_return_status => x_return_status);
3736: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3738: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3739: RAISE FND_API.G_EXC_ERROR ;
3740: END IF;
3741:

Line 3739: RAISE FND_API.G_EXC_ERROR ;

3735: x_return_status => x_return_status);
3736: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3737: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3738: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3739: RAISE FND_API.G_EXC_ERROR ;
3740: END IF;
3741:
3742:
3743: IF (l_perform_articles_exist_qa <> 'Y') THEN

Line 3781: WHEN FND_API.G_EXC_ERROR THEN

3777: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_articles_exist');
3778: END IF;
3779:
3780: EXCEPTION
3781: WHEN FND_API.G_EXC_ERROR THEN
3782: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3783: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');
3784: END IF;
3785:

Line 3788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3784: END IF;
3785:
3786: x_return_status := G_RET_STS_ERROR ;
3787:
3788: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3789: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3790: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_articles_exist : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
3791: END IF;
3792:

Line 3945: p_init_msg_list => FND_API.G_FALSE,

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,
3948: x_drafts_present => l_drafts_present,
3949: x_return_status => x_return_status,

Line 3953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3949: x_return_status => x_return_status,
3950: x_msg_count => x_msg_count,
3951: x_msg_data => x_msg_data);
3952: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3954: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3955: RAISE FND_API.G_EXC_ERROR;
3956: END IF;
3957: end;

Line 3955: RAISE FND_API.G_EXC_ERROR;

3951: x_msg_data => x_msg_data);
3952: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3953: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3954: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3955: RAISE FND_API.G_EXC_ERROR;
3956: END IF;
3957: end;
3958: -- bug 4159533 end
3959: -- the above code simulates template submittion else the below

Line 3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 3981: RAISE FND_API.G_EXC_ERROR ;

3977: x_return_status => x_return_status);
3978: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3979: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3980: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3981: RAISE FND_API.G_EXC_ERROR ;
3982: END IF;
3983:
3984: get_qa_code_detail(p_qa_code => G_CHECK_ART_DEF_SEC,
3985: x_perform_qa => l_perform_qa_def_sec,

Line 3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3986: x_qa_name => l_desc_def_sec,
3987: x_severity_flag => l_severity_def_sec,
3988: x_return_status => x_return_status);
3989: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3991: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3992: RAISE FND_API.G_EXC_ERROR ;
3993: END IF;
3994:

Line 3992: RAISE FND_API.G_EXC_ERROR ;

3988: x_return_status => x_return_status);
3989: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3990: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3991: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3992: RAISE FND_API.G_EXC_ERROR ;
3993: END IF;
3994:
3995: get_qa_code_detail(p_qa_code => G_CHECK_ART_INV_VAR,
3996: x_perform_qa => l_perform_qa_inv_var,

Line 4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3997: x_qa_name => l_desc_inv_var,
3998: x_severity_flag => l_severity_inv_var,
3999: x_return_status => x_return_status);
4000: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4002: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4003: RAISE FND_API.G_EXC_ERROR ;
4004: END IF;
4005:

Line 4003: RAISE FND_API.G_EXC_ERROR ;

3999: x_return_status => x_return_status);
4000: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4002: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4003: RAISE FND_API.G_EXC_ERROR ;
4004: END IF;
4005:
4006: get_qa_code_detail(p_qa_code => G_CHECK_ART_INV_VAL,
4007: x_perform_qa => l_perform_qa_inv_val,

Line 4012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4008: x_qa_name => l_desc_inv_val,
4009: x_severity_flag => l_severity_inv_val,
4010: x_return_status => x_return_status);
4011: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4013: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4014: RAISE FND_API.G_EXC_ERROR ;
4015: END IF;
4016:

Line 4014: RAISE FND_API.G_EXC_ERROR ;

4010: x_return_status => x_return_status);
4011: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4013: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4014: RAISE FND_API.G_EXC_ERROR ;
4015: END IF;
4016:
4017:
4018: l_art_ver_tbl := OKC_ART_BLK_PVT.NUM_TBL_TYPE();

Line 4036: p_init_msg_list => FND_API.G_FALSE,

4032: ) THEN
4033:
4034: OKC_ART_BLK_PVT.validate_article_versions_blk(
4035: p_api_version => 1.0 ,
4036: p_init_msg_list => FND_API.G_FALSE,
4037: p_commit => FND_API.G_FALSE,
4038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4039: x_return_status => x_return_status,
4040: x_msg_count => l_msg_count,

Line 4037: p_commit => FND_API.G_FALSE,

4033:
4034: OKC_ART_BLK_PVT.validate_article_versions_blk(
4035: p_api_version => 1.0 ,
4036: p_init_msg_list => FND_API.G_FALSE,
4037: p_commit => FND_API.G_FALSE,
4038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4039: x_return_status => x_return_status,
4040: x_msg_count => l_msg_count,
4041: x_msg_data => l_msg_data,

Line 4038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4034: OKC_ART_BLK_PVT.validate_article_versions_blk(
4035: p_api_version => 1.0 ,
4036: p_init_msg_list => FND_API.G_FALSE,
4037: p_commit => FND_API.G_FALSE,
4038: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4039: x_return_status => x_return_status,
4040: x_msg_count => l_msg_count,
4041: x_msg_data => l_msg_data,
4042: p_org_id => g_org_id,

Line 4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4044: x_qa_return_status => l_qa_return_status,
4045: x_validation_results => l_validation_results
4046: );
4047: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4049: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4050: RAISE FND_API.G_EXC_ERROR ;
4051: END IF;
4052:

Line 4050: RAISE FND_API.G_EXC_ERROR ;

4046: );
4047: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4049: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4050: RAISE FND_API.G_EXC_ERROR ;
4051: END IF;
4052:
4053: ELSE
4054: -- nothing to validate

Line 4234: WHEN FND_API.G_EXC_ERROR THEN

4230: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_validate_draft_articles');
4231: END IF;
4232:
4233: EXCEPTION
4234: WHEN FND_API.G_EXC_ERROR THEN
4235: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4236: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_validate_draft_articles : OKC_API.G_EXCEPTION_ERROR Exception');
4237: END IF;
4238:

Line 4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4241: END IF;
4242:
4243: x_return_status := G_RET_STS_ERROR ;
4244:
4245: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4246: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4247: 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');
4248: END IF;
4249:

Line 4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4322: x_qa_name => l_desc,
4323: x_severity_flag => l_severity,
4324: x_return_status => x_return_status);
4325: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4327: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4328: RAISE FND_API.G_EXC_ERROR ;
4329: END IF;
4330:

Line 4328: RAISE FND_API.G_EXC_ERROR ;

4324: x_return_status => x_return_status);
4325: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4327: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4328: RAISE FND_API.G_EXC_ERROR ;
4329: END IF;
4330:
4331:
4332: IF (l_perform_articles_exist_qa <> 'Y') THEN

Line 4361: WHEN FND_API.G_EXC_ERROR THEN

4357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'1600: Leaving check_rejected_clauses');
4358: END IF;
4359:
4360: EXCEPTION
4361: WHEN FND_API.G_EXC_ERROR THEN
4362: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');
4364: END IF;
4365:

Line 4372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4368: END IF;
4369:
4370: x_return_status := G_RET_STS_ERROR ;
4371:
4372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4375: END IF;
4376:

Line 4660: p_init_msg_list => FND_API.G_FALSE,

4656: -- Modify the severity level of the qa check for existence of clauses
4657: -- to 'W' (warning) if the template contains deliverables. It is 'E' otherwise.
4658: if okc_terms_util_grp.Is_Deliverable_Exist(
4659: p_api_version => 1,
4660: p_init_msg_list => FND_API.G_FALSE,
4661: x_return_status => x_return_status,
4662: x_msg_data => x_msg_data,
4663: x_msg_count => x_msg_count,
4664: p_doc_type => 'TEMPLATE',

Line 4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 4758: RAISE FND_API.G_EXC_ERROR ;

4754: );
4755: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4757: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4758: RAISE FND_API.G_EXC_ERROR ;
4759: END IF;
4760:
4761: --call new internal procedure to check for article existence
4762: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4768: px_qa_result_tbl => x_qa_result_tbl,
4769: x_return_status => x_return_status
4770: );
4771: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4773: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4774: RAISE FND_API.G_EXC_ERROR ;
4775: END IF;
4776:

Line 4774: RAISE FND_API.G_EXC_ERROR ;

4770: );
4771: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4773: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4774: RAISE FND_API.G_EXC_ERROR ;
4775: END IF;
4776:
4777: --call new internal procedure to validate any draft articles
4778: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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: -- For Bug# 6979012
4794: --call new internal procedure to give a warning for rejected articles

Line 4805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4801: px_qa_result_tbl => x_qa_result_tbl,
4802: x_return_status => x_return_status
4803: );
4804: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4806: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4807: RAISE FND_API.G_EXC_ERROR ;
4808: END IF;
4809: -- Changes for Bug# 6979012 Ends

Line 4807: RAISE FND_API.G_EXC_ERROR ;

4803: );
4804: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4806: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4807: RAISE FND_API.G_EXC_ERROR ;
4808: END IF;
4809: -- Changes for Bug# 6979012 Ends
4810:
4811: --MLS for templates

Line 4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4818: px_qa_result_tbl => x_qa_result_tbl,
4819: x_return_status => x_return_status
4820: );
4821: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4823: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4824: RAISE FND_API.G_EXC_ERROR ;
4825: END IF;
4826:

Line 4824: RAISE FND_API.G_EXC_ERROR ;

4820: );
4821: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4822: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4823: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4824: RAISE FND_API.G_EXC_ERROR ;
4825: END IF;
4826:
4827: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'2205: calling Check_translated_tmpl_effectivity');

Line 4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4833: px_qa_result_tbl => x_qa_result_tbl,
4834: x_return_status => x_return_status
4835: );
4836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4839: RAISE FND_API.G_EXC_ERROR ;
4840: END IF;
4841: --MLS for templates

Line 4839: RAISE FND_API.G_EXC_ERROR ;

4835: );
4836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4839: RAISE FND_API.G_EXC_ERROR ;
4840: END IF;
4841: --MLS for templates
4842:
4843:

Line 4861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4857: px_qa_result_tbl => x_qa_result_tbl,
4858: x_return_status => x_return_status
4859: );
4860: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4862: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4863: RAISE FND_API.G_EXC_ERROR ;
4864: END IF;
4865:

Line 4863: RAISE FND_API.G_EXC_ERROR ;

4859: );
4860: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4862: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4863: RAISE FND_API.G_EXC_ERROR ;
4864: END IF;
4865:
4866: --------------------------------------------
4867: -- QA Check for Duplicate articles

Line 4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4876: px_qa_result_tbl => x_qa_result_tbl,
4877: x_return_status => x_return_status
4878: );
4879: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4881: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4882: RAISE FND_API.G_EXC_ERROR ;
4883: END IF;
4884:

Line 4882: RAISE FND_API.G_EXC_ERROR ;

4878: );
4879: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4880: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4881: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4882: RAISE FND_API.G_EXC_ERROR ;
4883: END IF;
4884:
4885: --------------------------------------------
4886: -- QA Check for variable-doc type usage

Line 4899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4895: px_qa_result_tbl => x_qa_result_tbl,
4896: x_return_status => x_return_status
4897: );
4898: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4900: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4901: RAISE FND_API.G_EXC_ERROR ;
4902: END IF;
4903:

Line 4901: RAISE FND_API.G_EXC_ERROR ;

4897: );
4898: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4900: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4901: RAISE FND_API.G_EXC_ERROR ;
4902: END IF;
4903:
4904: ----------------------------------------------------------------
4905: -- QA Check for article effectivity and old version of article

Line 4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4914: px_qa_result_tbl => x_qa_result_tbl,
4915: x_return_status => x_return_status
4916: );
4917: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4919: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4920: RAISE FND_API.G_EXC_ERROR ;
4921: END IF;
4922:

Line 4920: RAISE FND_API.G_EXC_ERROR ;

4916: );
4917: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4919: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4920: RAISE FND_API.G_EXC_ERROR ;
4921: END IF;
4922:
4923:
4924: -----------------------------------------------------------------------

Line 4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 4944: RAISE FND_API.G_EXC_ERROR ;

4940: );
4941: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4942: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4943: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4944: RAISE FND_API.G_EXC_ERROR ;
4945: END IF;
4946:
4947: ---------------------------------------------------------
4948: -- QA Check for unassigned articles

Line 4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 4962: RAISE FND_API.G_EXC_ERROR ;

4958: );
4959: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4961: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4962: RAISE FND_API.G_EXC_ERROR ;
4963: END IF;
4964:
4965: ---------------------------------------------------------------
4966: -- QA Check for empty sections

Line 4978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4974: px_qa_result_tbl => x_qa_result_tbl,
4975: x_return_status => x_return_status
4976: );
4977: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4979: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4980: RAISE FND_API.G_EXC_ERROR ;
4981: END IF;
4982:

Line 4980: RAISE FND_API.G_EXC_ERROR ;

4976: );
4977: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4979: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4980: RAISE FND_API.G_EXC_ERROR ;
4981: END IF;
4982:
4983: ---------------------------------------------------------------
4984: -- QA Check for inactive template

Line 4996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4992: px_qa_result_tbl => x_qa_result_tbl,
4993: x_return_status => x_return_status
4994: );
4995: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4997: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4998: RAISE FND_API.G_EXC_ERROR ;
4999: END IF;
5000:

Line 4998: RAISE FND_API.G_EXC_ERROR ;

4994: );
4995: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4997: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4998: RAISE FND_API.G_EXC_ERROR ;
4999: END IF;
5000:
5001: IF p_qa_mode = G_AMEND_QA THEN
5002:

Line 5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

5012: px_qa_result_tbl => x_qa_result_tbl,
5013: x_return_status => x_return_status
5014: );
5015: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5017: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5018: RAISE FND_API.G_EXC_ERROR ;
5019: END IF;
5020:

Line 5018: RAISE FND_API.G_EXC_ERROR ;

5014: );
5015: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5017: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5018: RAISE FND_API.G_EXC_ERROR ;
5019: END IF;
5020:
5021: ------------------------------------------------------------
5022: -- QA Check for Amended section with no description

Line 5034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

5030: px_qa_result_tbl => x_qa_result_tbl,
5031: x_return_status => x_return_status
5032: );
5033: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5035: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5036: RAISE FND_API.G_EXC_ERROR ;
5037: END IF;
5038:

Line 5036: RAISE FND_API.G_EXC_ERROR ;

5032: );
5033: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5034: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5035: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5036: RAISE FND_API.G_EXC_ERROR ;
5037: END IF;
5038:
5039: END IF; -- IF p_qa_mode = G_AMEND_QA THEN
5040:

Line 5054: p_init_msg_list => FND_API.G_FALSE,

5050: IF p_doc_type = G_TMPL_DOC_TYPE THEN
5051: --Added 11.5.10+ CE
5052: OKC_XPRT_UTIL_PVT.validate_template_for_expert (
5053: p_api_version => 1,
5054: p_init_msg_list => FND_API.G_FALSE,
5055: p_template_id => p_doc_id,
5056: x_msg_data => x_msg_data,
5057: x_msg_count => x_msg_count,
5058: x_qa_result_tbl => x_qa_result_tbl,

Line 5067: p_init_msg_list => FND_API.G_FALSE,

5063: -- Bug# 4874729. Not invoking expert validation for OKS doc type.
5064:
5065: OKC_XPRT_UTIL_PVT.contract_expert_bv (
5066: p_api_version => 1,
5067: p_init_msg_list => FND_API.G_FALSE,
5068: p_document_type => p_doc_type,
5069: p_document_id => p_doc_id,
5070: p_bv_mode => 'QA',
5071: x_expert_articles_tbl => l_expert_articles_tbl,

Line 5081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

5077: END IF;
5078: END IF;
5079:
5080: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5082: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5083: RAISE FND_API.G_EXC_ERROR ;
5084: END IF;
5085:

Line 5083: RAISE FND_API.G_EXC_ERROR ;

5079:
5080: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
5081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
5082: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
5083: RAISE FND_API.G_EXC_ERROR ;
5084: END IF;
5085:
5086: --****************************************--
5087: -- End of validation set --

Line 5129: WHEN FND_API.G_EXC_ERROR THEN

5125: END IF;
5126: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5127:
5128: EXCEPTION
5129: WHEN FND_API.G_EXC_ERROR THEN
5130: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5131: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');
5132: END IF;
5133:

Line 5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

5155:
5156: x_return_status := G_RET_STS_ERROR ;
5157: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
5158:
5159: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5160: ROLLBACK TO g_QA_Doc;
5161: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5162: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
5163: END IF;