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_CLM_PKG dependencies on OKC_API

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

3: ------------------------------------------------------------------------------
4: -- GLOBAL CONSTANTS
5: ------------------------------------------------------------------------------
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CLM_PKG';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8:
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application

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

8:
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_MODULE CONSTANT VARCHAR2(250) := 'okc.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=510; -- OKC Application
12: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
13:
14:
15: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
16: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

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

21:
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
25: G_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_UNABLE_TO_RESERVE_REC;
26:
27: G_BUY_ITEM_VARIABLE_NAME CONSTANT VARCHAR2(50) := 'OKC$B_ITEM';
28: G_BUY_ITEM_CAT_VAR_NAME CONSTANT VARCHAR2(50) := 'OKC$B_ITEM_CATEGORY';
29: G_SELL_ITEM_VARIABLE_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM';

Line 32: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;

28: G_BUY_ITEM_CAT_VAR_NAME CONSTANT VARCHAR2(50) := 'OKC$B_ITEM_CATEGORY';
29: G_SELL_ITEM_VARIABLE_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM';
30: G_SELL_ITEM_CAT_VAR_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM_CATEGORY';
31:
32: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
33: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
35: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
36:

Line 33: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;

29: G_SELL_ITEM_VARIABLE_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM';
30: G_SELL_ITEM_CAT_VAR_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM_CATEGORY';
31:
32: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
33: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
35: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
36:
37: ---------------------------------------------------

Line 34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;

30: G_SELL_ITEM_CAT_VAR_NAME CONSTANT VARCHAR2(50) := 'OKC$S_ITEM_CATEGORY';
31:
32: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
33: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
35: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
36:
37: ---------------------------------------------------
38: -- Procedure: get_user_defined_variables

Line 35: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;

31:
32: G_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_DELETED;
33: G_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_CHANGED;
34: G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
35: G_LOCK_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_LOCK_RECORD_DELETED;
36:
37: ---------------------------------------------------
38: -- Procedure: get_user_defined_variables
39: ---------------------------------------------------

Line 758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');

754: EXCEPTION
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
758: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_ERROR Exception');
759: END IF;
760:
761: IF csr_get_clm_udv%ISOPEN THEN
762: CLOSE csr_get_clm_udv;

Line 771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

767:
768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
769:
770: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
771: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'2000: Leaving set_clm_udv : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
772: END IF;
773:
774: IF csr_get_clm_udv%ISOPEN THEN
775: CLOSE csr_get_clm_udv;

Line 1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');

1204:
1205: WHEN FND_API.G_EXC_ERROR THEN
1206:
1207: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1208: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_scn_art: OKC_API.G_EXCEPTION_ERROR Exception');
1209: END IF;
1210:
1211: IF l_get_dup_sec_csr%ISOPEN THEN
1212: CLOSE l_get_dup_sec_csr;

Line 1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');

1312:
1313: WHEN FND_API.G_EXC_ERROR THEN
1314:
1315: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1316: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'800: Leaving clm_remove_dup_articles: OKC_API.G_EXCEPTION_ERROR Exception');
1317: END IF;
1318:
1319: IF l_get_dup_articles_csr%ISOPEN THEN
1320: CLOSE l_get_dup_articles_csr;

Line 1446: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'VALID_CONFIG_YN');

1442: IF ( p_valid_config_yn NOT IN ('Y','N') AND p_valid_config_yn IS NOT NULL) THEN
1443: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1444: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: - attribute VALID_CONFIG_YN is invalid');
1445: END IF;
1446: -- Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'VALID_CONFIG_YN');
1447: x_return_status := G_RET_STS_ERROR;
1448: END IF;
1449:
1450: OPEN l_get_temp_already_exists_csr;

Line 1515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1511: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1512: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Insert_Row:OTHERS Exception');
1513: END IF;
1514:
1515: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1516: p_msg_name => G_UNEXPECTED_ERROR,
1517: p_token1 => G_SQLCODE_TOKEN,
1518: p_token1_value => sqlcode,
1519: p_token2 => G_SQLERRM_TOKEN,

Line 1574: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);

1570:
1571: IF (lock_csr%ISOPEN) THEN
1572: CLOSE lock_csr;
1573: END IF;
1574: Okc_Api.Set_Message(G_FND_APP,G_UNABLE_TO_RESERVE_REC);
1575: RETURN( G_RET_STS_ERROR );
1576: END;
1577:
1578: IF ( l_row_notfound ) THEN

Line 1587: Okc_Api.Set_Message(G_FND_APP,G_LOCK_RECORD_DELETED,

1583: l_row_notfound := lchk_csr%NOTFOUND;
1584: CLOSE lchk_csr;
1585:
1586: IF (l_row_notfound) THEN
1587: Okc_Api.Set_Message(G_FND_APP,G_LOCK_RECORD_DELETED,
1588: 'ENTITYNAME','OKC_MLP_TEMPLATE_USAGES',
1589: 'PKEY',p_document_type||':'||p_document_id,
1590: 'OVN',p_object_version_number
1591: );

Line 1593: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

1589: 'PKEY',p_document_type||':'||p_document_id,
1590: 'OVN',p_object_version_number
1591: );
1592: ELSIF l_object_version_number > p_object_version_number THEN
1593: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1594: ELSIF l_object_version_number = -1 THEN
1595: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1596: ELSE -- it can be the only above condition. It can happen after restore version
1597: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

Line 1595: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1591: );
1592: ELSIF l_object_version_number > p_object_version_number THEN
1593: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1594: ELSIF l_object_version_number = -1 THEN
1595: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1596: ELSE -- it can be the only above condition. It can happen after restore version
1597: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1598: END IF;
1599: ELSE

Line 1597: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);

1593: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1594: ELSIF l_object_version_number = -1 THEN
1595: Okc_Api.Set_Message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1596: ELSE -- it can be the only above condition. It can happen after restore version
1597: Okc_Api.Set_Message(G_FND_APP,G_RECORD_CHANGED);
1598: END IF;
1599: ELSE
1600: l_return_status := G_RET_STS_SUCCESS;
1601: END IF;

Line 1623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'400: Leaving Lock_Row because of EXCEPTION: '||sqlerrm);
1621: END IF;
1622:
1623: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1624: p_msg_name => G_UNEXPECTED_ERROR,
1625: p_token1 => G_SQLCODE_TOKEN,
1626: p_token1_value => sqlcode,
1627: p_token2 => G_SQLERRM_TOKEN,

Line 1691: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1687: WHEN OTHERS THEN
1688: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1689: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving Delete_Usages_Row because of EXCEPTION: '||sqlerrm);
1690: END IF;
1691: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1692: p_msg_name => G_UNEXPECTED_ERROR,
1693: p_token1 => G_SQLCODE_TOKEN,
1694: p_token1_value => sqlcode,
1695: p_token2 => G_SQLERRM_TOKEN,

Line 1749: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1745: WHEN OTHERS THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'700: Leaving check_dup_templates because of EXCEPTION: '||sqlerrm);
1748: END IF;
1749: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1750: p_msg_name => G_UNEXPECTED_ERROR,
1751: p_token1 => G_SQLCODE_TOKEN,
1752: p_token1_value => sqlcode,
1753: p_token2 => G_SQLERRM_TOKEN,

Line 1911: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

1907: WHEN OTHERS THEN
1908: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1909: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving copy_usages_row because of EXCEPTION: '||sqlerrm);
1910: END IF;
1911: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
1912: p_msg_name => G_UNEXPECTED_ERROR,
1913: p_token1 => G_SQLCODE_TOKEN,
1914: p_token1_value => sqlcode,
1915: p_token2 => G_SQLERRM_TOKEN,