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

APPS.OKC_TERMS_QA_PVT dependencies on OKC_API

Line 7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_INVALID_ARGUMENT';

Line 8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;

4: ---------------------------------------------------------------------------
5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_INVALID_ARGUMENT';
12: -- ARG_NAME ARG_VALUE is invalid.

Line 9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

5: -- GLOBAL MESSAGE CONSTANTS
6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_INVALID_ARGUMENT';
12: -- ARG_NAME ARG_VALUE is invalid.
13: ---------------------------------------------------------------------------

Line 10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

6: ---------------------------------------------------------------------------
7: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
8: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
9: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
10: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
11: G_OKC_MSG_INVALID_ARGUMENT CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_INVALID_ARGUMENT';
12: -- ARG_NAME ARG_VALUE is invalid.
13: ---------------------------------------------------------------------------
14: -- GLOBAL CONSTANTS

Line 18: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

14: -- GLOBAL CONSTANTS
15: ---------------------------------------------------------------------------
16: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_QA_PVT';
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;

Line 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');

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 ;
554:
555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 650: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1200: Leaving Log_QA_Messages : OKC_API.G_EXCEPTION_ERROR Exception');

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 ;
653:
654: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 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');

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 ;
659:
660: WHEN OTHERS THEN

Line 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');

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:
903: IF l_get_incomp_alter_csr%ISOPEN THEN
904: CLOSE l_get_incomp_alter_csr;

Line 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');

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:
919: IF l_get_incomp_alter_csr%ISOPEN THEN
920: CLOSE l_get_incomp_alter_csr;

Line 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');

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:
1062: x_return_status := G_RET_STS_ERROR ;
1063:

Line 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');

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:
1069: x_return_status := G_RET_STS_UNEXP_ERROR ;
1070:

Line 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');

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:
1311: x_return_status := G_RET_STS_ERROR ;
1312:

Line 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');

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:
1318: x_return_status := G_RET_STS_UNEXP_ERROR ;
1319:

Line 1485: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_duplicate_articles : OKC_API.G_EXCEPTION_ERROR Exception');

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:
1488: /* expert commented out
1489: IF l_get_dup_xprt_csr%ISOPEN THEN

Line 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');

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:
1501: /* expert commented out
1502: IF l_get_dup_xprt_csr%ISOPEN THEN

Line 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');

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:
1840: IF l_check_usage_csr%ISOPEN THEN
1841: CLOSE l_check_usage_csr ;

Line 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');

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:
1857: IF l_check_usage_csr%ISOPEN THEN
1858: CLOSE l_check_usage_csr ;

Line 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');

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:
2004: IF csr_get_udv_with_procs%ISOPEN THEN
2005: CLOSE csr_get_udv_with_procs;

Line 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');

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:
2015: IF csr_get_udv_with_procs%ISOPEN THEN
2016: CLOSE csr_get_udv_with_procs;

Line 2264: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Check_variables : OKC_API.G_EXCEPTION_ERROR Exception');

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:
2267: IF l_check_variable_csr%ISOPEN THEN
2268: CLOSE l_check_variable_csr;

Line 2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Check_variables : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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:
2278: IF l_check_variable_csr%ISOPEN THEN
2279: CLOSE l_check_variable_csr;

Line 2373: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_unassigned_articles : OKC_API.G_EXCEPTION_ERROR Exception');

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:
2376: IF l_get_unass_art_crs%ISOPEN THEN
2377: CLOSE l_get_unass_art_crs;

Line 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');

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:
2387: IF l_get_unass_art_crs%ISOPEN THEN
2388: CLOSE l_get_unass_art_crs;

Line 2483: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_empty_sections : OKC_API.G_EXCEPTION_ERROR Exception');

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:
2486: IF l_get_empty_section_csr%ISOPEN THEN
2487: CLOSE l_get_empty_section_csr;

Line 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');

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:
2497: IF l_get_empty_section_csr%ISOPEN THEN
2498: CLOSE l_get_empty_section_csr;

Line 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');

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:
2599: x_return_status := G_RET_STS_ERROR ;
2600:

Line 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');

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:
2606: x_return_status := G_RET_STS_UNEXP_ERROR ;
2607:

Line 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');

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:
2703: x_return_status := G_RET_STS_ERROR ;
2704:

Line 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');

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:
2710: x_return_status := G_RET_STS_UNEXP_ERROR ;
2711:

Line 2737: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;

2733: l_indx NUMBER;
2734: l_severity OKC_QA_ERRORS_T.ERROR_SEVERITY%TYPE;
2735: l_desc OKC_QA_ERRORS_T.PROBLEM_SHORT_DESC%TYPE;
2736: l_perform_tmpl_qa VARCHAR2(1);
2737: l_tmpl_usg_exists_flag varchar2(1):=OKC_API.G_MISS_CHAR;
2738: l_doc_type_name OKC_BUS_DOC_TYPES_TL.NAME%TYPE;
2739:
2740:
2741: CURSOR l_get_template_crs IS

Line 2844: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_inactive_template : OKC_API.G_EXCEPTION_ERROR Exception');

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:
2847: IF l_get_template_crs%ISOPEN THEN
2848: CLOSE l_get_template_crs;

Line 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');

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:
2858: IF l_get_template_crs%ISOPEN THEN
2859: CLOSE l_get_template_crs;

Line 3269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_art_effectivity : OKC_API.G_EXCEPTION_ERROR Exception');

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:
3272: IF l_get_tmpl_dates_csr%ISOPEN THEN
3273: CLOSE l_get_tmpl_dates_csr;

Line 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');

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:
3298: IF l_get_tmpl_dates_csr%ISOPEN THEN
3299: CLOSE l_get_tmpl_dates_csr;

Line 3427: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_layout_template : OKC_API.G_EXCEPTION_ERROR Exception');

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:
3430: IF l_get_layout_tmpl_csr%ISOPEN THEN
3431: CLOSE l_get_layout_tmpl_csr;

Line 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');

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:
3441: IF l_get_layout_tmpl_csr%ISOPEN THEN
3442: CLOSE l_get_layout_tmpl_csr;

Line 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');

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:
3552: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3553: CLOSE l_translated_tmpl_revision_csr;

Line 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');

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:
3563: IF l_translated_tmpl_revision_csr%ISOPEN THEN
3564: CLOSE l_translated_tmpl_revision_csr;

Line 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');

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:
3674: IF l_get_trans_tmpl_csr%ISOPEN THEN
3675: CLOSE l_get_trans_tmpl_csr;

Line 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');

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:
3685: IF l_get_trans_tmpl_csr%ISOPEN THEN
3686: CLOSE l_get_trans_tmpl_csr;

Line 3783: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_articles_exist : OKC_API.G_EXCEPTION_ERROR Exception');

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:
3786: x_return_status := G_RET_STS_ERROR ;
3787:

Line 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');

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:
3793: x_return_status := G_RET_STS_UNEXP_ERROR ;
3794:

Line 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');

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:
4239: IF l_draft_art_csr%ISOPEN THEN
4240: CLOSE l_draft_art_csr;

Line 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');

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:
4250: IF l_draft_art_csr%ISOPEN THEN
4251: CLOSE l_draft_art_csr;

Line 4363: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving check_rejected_clauses : OKC_API.G_EXCEPTION_ERROR Exception');

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:
4366: IF l_rejected_art_csr%ISOPEN THEN
4367: CLOSE l_rejected_art_csr;

Line 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');

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:
4377: IF l_rejected_art_csr%ISOPEN THEN
4378: CLOSE l_rejected_art_csr;

Line 5131: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2400: Leaving QA_Doc : OKC_API.G_EXCEPTION_ERROR Exception');

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:
5134: IF l_get_qa_detail_csr%ISOPEN THEN
5135: CLOSE l_get_qa_detail_csr;

Line 5162: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2500: Leaving QA_Doc : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

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;
5164: IF l_get_qa_detail_csr%ISOPEN THEN
5165: CLOSE l_get_qa_detail_csr;
5166: END IF;