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 388: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');

384:
385: WHEN FND_API.G_EXC_ERROR THEN
386:
387: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
388: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_doc: OKC_API.G_EXCEPTION_ERROR Exception');
389: END IF;
390:
391: ROLLBACK TO g_copy_doc_grp;
392: x_return_status := G_RET_STS_ERROR ;

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

393: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
394:
395: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
396: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
397: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
398: END IF;
399:
400: ROLLBACK TO g_copy_doc_grp;
401: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

544: FETCH l_check_tmpl_name_csr INTO l_dummy;
545:
546: IF l_check_tmpl_name_csr%FOUND THEN
547:
548: okc_Api.Set_Message(p_app_name => G_APP_NAME,
549: p_msg_name => 'OKC_SAME_TMPL_NAME');
550: RAISE FND_API.G_EXC_ERROR ;
551:
552: END IF;

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

719:
720: WHEN FND_API.G_EXC_ERROR THEN
721:
722: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
723: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms_template: OKC_API.G_EXCEPTION_ERROR Exception');
724: END IF;
725:
726: IF l_get_tmpl_csr%ISOPEN THEN
727: CLOSE l_get_tmpl_csr;

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

736: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
737:
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
740: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms_template: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
741: END IF;
742:
743: IF l_get_tmpl_csr%ISOPEN THEN
744: CLOSE l_get_tmpl_csr;

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

1041:
1042: WHEN FND_API.G_EXC_ERROR THEN
1043:
1044: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1045: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_terms: OKC_API.G_EXCEPTION_ERROR Exception');
1046: END IF;
1047:
1048: ROLLBACK TO g_copy_terms_grp;
1049: x_return_status := G_RET_STS_ERROR ;

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

1050: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1051:
1052: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1053: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1054: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1055: END IF;
1056:
1057:
1058: ROLLBACK TO g_copy_terms_grp;

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

1261:
1262: WHEN FND_API.G_EXC_ERROR THEN
1263:
1264: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1265: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving create_template_revision: OKC_API.G_EXCEPTION_ERROR Exception');
1266: END IF;
1267:
1268: IF l_get_tmpl_csr%ISOPEN THEN
1269: CLOSE l_get_tmpl_csr;

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

1274: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1275:
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1277: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1278: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving create_template_revision: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1279: END IF;
1280:
1281: IF l_get_tmpl_csr%ISOPEN THEN
1282: CLOSE l_get_tmpl_csr;

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

1404:
1405: WHEN FND_API.G_EXC_ERROR THEN
1406:
1407: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1408: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1409: END IF;
1410:
1411: ROLLBACK TO g_copy_archived_doc_grp;
1412: x_return_status := G_RET_STS_ERROR ;

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

1413: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1414:
1415: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1417: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_archived_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1418: END IF;
1419:
1420: ROLLBACK TO g_copy_archived_doc_grp;
1421: x_return_status := G_RET_STS_UNEXP_ERROR ;

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

1632:
1633: WHEN FND_API.G_EXC_ERROR THEN
1634:
1635: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1636: FND_LOG.STRING( FND_LOG.LEVEL_ERROR ,g_module||l_api_name,'800: Leaving copy_response_doc: OKC_API.G_EXCEPTION_ERROR Exception');
1637: END IF;
1638:
1639: ROLLBACK TO g_copy_doc_grp;
1640: x_return_status := G_RET_STS_ERROR ;

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

1641: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1642:
1643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1644: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1645: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,g_module||l_api_name,'900: Leaving copy_response_doc: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
1646: END IF;
1647:
1648: ROLLBACK TO g_copy_doc_grp;
1649: x_return_status := G_RET_STS_UNEXP_ERROR ;