DBA Data[Home] [Help]

APPS.OKC_TERMS_COPY_GRP 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: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_GRP';

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

8: ---------------------------------------------------------------------------
9: -- GLOBAL VARIABLES
10: ---------------------------------------------------------------------------
11: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TERMS_COPY_GRP';
12: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
13:
14: ------------------------------------------------------------------------------
15: -- GLOBAL CONSTANTS
16: ------------------------------------------------------------------------------

Line 28: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;

24:
25: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
26: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
27: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
28: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
29: G_TEMPLATE_MISS_REC OKC_TERMS_TEMPLATES_PVT.template_rec_type;
30:
31: /*
32: --To be used when copying/transitioning a document

Line 505: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');

501:
502: WHEN FND_API.G_EXC_ERROR THEN
503:
504: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
505: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');
506: END IF;
507:
508: ROLLBACK TO g_copy_doc_grp;
509: x_return_status := G_RET_STS_ERROR ;

Line 514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

510: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
511:
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
514: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
515: END IF;
516:
517: ROLLBACK TO g_copy_doc_grp;
518: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 666: okc_Api.Set_Message(p_app_name => G_APP_NAME,

662: FETCH l_check_tmpl_name_csr INTO l_dummy;
663:
664: IF l_check_tmpl_name_csr%FOUND THEN
665:
666: okc_Api.Set_Message(p_app_name => G_APP_NAME,
667: p_msg_name => 'OKC_SAME_TMPL_NAME');
668: RAISE FND_API.G_EXC_ERROR ;
669:
670: END IF;

Line 841: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms_template: OKC_API.G_EXCEPTION_ERROR Exception');

837:
838: WHEN FND_API.G_EXC_ERROR THEN
839:
840: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
841: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms_template: OKC_API.G_EXCEPTION_ERROR Exception');
842: END IF;
843:
844: IF l_get_tmpl_csr%ISOPEN THEN
845: CLOSE l_get_tmpl_csr;

Line 858: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

854: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
855:
856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
857: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
858: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
859: END IF;
860:
861: IF l_get_tmpl_csr%ISOPEN THEN
862: CLOSE l_get_tmpl_csr;

Line 1012: okc_Api.Set_Message(p_app_name => G_APP_NAME,

1008: p_document_id =>p_target_doc_id,
1009: p_template_id => p_template_id);
1010:
1011: IF l_template_exists = 'Y' THEN
1012: okc_Api.Set_Message(p_app_name => G_APP_NAME,
1013: p_msg_name => 'OKC_SAME_TMPL_NAME');
1014: RAISE FND_API.G_EXC_ERROR ;
1015: END IF;
1016: END IF;

Line 1180: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms: OKC_API.G_EXCEPTION_ERROR Exception');

1176:
1177: WHEN FND_API.G_EXC_ERROR THEN
1178:
1179: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1180: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms: OKC_API.G_EXCEPTION_ERROR Exception');
1181: END IF;
1182:
1183: ROLLBACK TO g_copy_terms_grp;
1184: x_return_status := G_RET_STS_ERROR ;

Line 1189: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1185: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1186:
1187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1188: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1189: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1190: END IF;
1191:
1192:
1193: ROLLBACK TO g_copy_terms_grp;

Line 1401: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_revision: OKC_API.G_EXCEPTION_ERROR Exception');

1397:
1398: WHEN FND_API.G_EXC_ERROR THEN
1399:
1400: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1401: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_revision: OKC_API.G_EXCEPTION_ERROR Exception');
1402: END IF;
1403:
1404: IF l_get_tmpl_csr%ISOPEN THEN
1405: CLOSE l_get_tmpl_csr;

Line 1414: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1410: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1411:
1412: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1413: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1414: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1415: END IF;
1416:
1417: IF l_get_tmpl_csr%ISOPEN THEN
1418: CLOSE l_get_tmpl_csr;

Line 1544: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');

1540:
1541: WHEN FND_API.G_EXC_ERROR THEN
1542:
1543: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1544: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1545: END IF;
1546:
1547: ROLLBACK TO g_copy_archived_doc_grp;
1548: x_return_status := G_RET_STS_ERROR ;

Line 1553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1549: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1550:
1551: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1552: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1553: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1554: END IF;
1555:
1556: ROLLBACK TO g_copy_archived_doc_grp;
1557: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1772: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_response_doc: OKC_API.G_EXCEPTION_ERROR Exception');

1768:
1769: WHEN FND_API.G_EXC_ERROR THEN
1770:
1771: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1772: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_response_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1773: END IF;
1774:
1775: ROLLBACK TO g_copy_doc_grp;
1776: x_return_status := G_RET_STS_ERROR ;

Line 1781: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

1777: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1778:
1779: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1782: END IF;
1783:
1784: ROLLBACK TO g_copy_doc_grp;
1785: x_return_status := G_RET_STS_UNEXP_ERROR ;

Line 1918: okc_api.set_message

1914: l_retain_exhibits := 'Y';
1915:
1916: IF okc_k_entity_locks_grp.has_amended_terms(p_source_doc_type,p_source_doc_id ) = 'Y' THEN
1917: IF okc_k_entity_locks_grp.has_conflicting_locks(p_source_doc_type,p_source_doc_id) = 'Y' THEN
1918: okc_api.set_message
1919: (p_app_name => g_app_name,
1920: p_msg_name => 'OKC_PAR_CONFLICT_LOCKS'
1921: );
1922: x_return_status := g_ret_sts_error;

Line 1965: OKC_API.set_message(G_APP_NAME, OKC_API.G_INVALID_VALUE,OKC_API.G_COL_NAME_TOKEN,'p_process');

1961: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1962: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: Invalid mode is passed ');
1963: END IF;
1964:
1965: OKC_API.set_message(G_APP_NAME, OKC_API.G_INVALID_VALUE,OKC_API.G_COL_NAME_TOKEN,'p_process');
1966: RAISE FND_API.G_EXC_ERROR;
1967: END IF;
1968:
1969:

Line 2075: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving process_mod_terms: OKC_API.G_EXCEPTION_ERROR Exception');

2071: EXCEPTION
2072: WHEN FND_API.G_EXC_ERROR THEN
2073:
2074: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2075: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving process_mod_terms: OKC_API.G_EXCEPTION_ERROR Exception');
2076: END IF;
2077:
2078: ROLLBACK TO g_process_mod_terms_GRP;
2079: x_return_status := G_RET_STS_ERROR ;

Line 2084: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving process_mod_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

2080: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
2081:
2082: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2083: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2084: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving process_mod_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2085: END IF;
2086:
2087: ROLLBACK TO g_process_mod_terms_GRP;
2088: x_return_status := G_RET_STS_UNEXP_ERROR ;