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.OKS_TEMPLATE_SET_PUB dependencies on FND_LOG

Line 9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

5: ------------------------------------------------------------------------------
6: -- GLOBAL CONSTANTS
7: ------------------------------------------------------------------------------
8:
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_MODULE CONSTANT VARCHAR2(250) := 'oks.plsql.'||g_pkg_name||'.';
11: G_APPLICATION_ID CONSTANT NUMBER :=515; -- OKS Application
12:
13: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

Line 1694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1690:
1691:
1692: BEGIN
1693: -- start debug log
1694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1696: G_MODULE||l_api_name,
1697: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1698: END IF;

Line 1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1691:
1692: BEGIN
1693: -- start debug log
1694: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1695: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1696: G_MODULE||l_api_name,
1697: '100: Entered '||G_PKG_NAME ||'.'||l_api_name);
1698: END IF;
1699:

Line 1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1732: x_msg_data => x_msg_data
1733: );
1734:
1735: -- debug log
1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1738: G_MODULE||l_api_name,
1739: '150: After Calling OKS_WF_K_PROCESS_PVT.is_online_k_yn ');
1740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1733: );
1734:
1735: -- debug log
1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1738: G_MODULE||l_api_name,
1739: '150: After Calling OKS_WF_K_PROCESS_PVT.is_online_k_yn ');
1740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1741: G_MODULE||l_api_name,

Line 1740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1737: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1738: G_MODULE||l_api_name,
1739: '150: After Calling OKS_WF_K_PROCESS_PVT.is_online_k_yn ');
1740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1741: G_MODULE||l_api_name,
1742: '150: x_return_status '||x_return_status);
1743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1744: G_MODULE||l_api_name,

Line 1743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1739: '150: After Calling OKS_WF_K_PROCESS_PVT.is_online_k_yn ');
1740: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1741: G_MODULE||l_api_name,
1742: '150: x_return_status '||x_return_status);
1743: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1744: G_MODULE||l_api_name,
1745: '150: l_online_yn '||l_online_yn);
1746: END IF;
1747: --- If any errors happen treat it as online K

Line 1770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1766: FETCH csr_renewal_k_yn INTO l_applies_to;
1767: CLOSE csr_renewal_k_yn;
1768:
1769: -- debug log
1770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1772: G_MODULE||l_api_name,
1773: '200: l_applies_to '||l_applies_to);
1774: END IF;

Line 1771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1767: CLOSE csr_renewal_k_yn;
1768:
1769: -- debug log
1770: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1771: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1772: G_MODULE||l_api_name,
1773: '200: l_applies_to '||l_applies_to);
1774: END IF;
1775:

Line 1777: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1773: '200: l_applies_to '||l_applies_to);
1774: END IF;
1775:
1776: -- debug log
1777: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1779: G_MODULE||l_api_name,
1780: '210: Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET ');
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1774: END IF;
1775:
1776: -- debug log
1777: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1779: G_MODULE||l_api_name,
1780: '210: Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET ');
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1782: G_MODULE||l_api_name,

Line 1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1777: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1778: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1779: G_MODULE||l_api_name,
1780: '210: Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET ');
1781: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1782: G_MODULE||l_api_name,
1783: '210: p_contract_id : '||p_contract_id);
1784: END IF;
1785:

Line 1802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1798: );
1799:
1800:
1801: -- debug log
1802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1804: G_MODULE||l_api_name,
1805: '250: After Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET');
1806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1799:
1800:
1801: -- debug log
1802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1804: G_MODULE||l_api_name,
1805: '250: After Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET');
1806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1807: G_MODULE||l_api_name,

Line 1806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1802: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1803: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1804: G_MODULE||l_api_name,
1805: '250: After Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET');
1806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1807: G_MODULE||l_api_name,
1808: '250: l_template_set_id : '||l_template_set_id);
1809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1810: G_MODULE||l_api_name,

Line 1809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1805: '250: After Calling OKS_RENEW_UTIL_PVT.GET_TEMPLATE_SET');
1806: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1807: G_MODULE||l_api_name,
1808: '250: l_template_set_id : '||l_template_set_id);
1809: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1810: G_MODULE||l_api_name,
1811: '250: x_template_language : '||x_template_language);
1812: END IF;
1813:

Line 1840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1836: CLOSE csr_xdo_template_name;
1837: END IF;
1838:
1839: -- debug log
1840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1842: G_MODULE||l_api_name,
1843: '300: x_attachment_template_id : '||x_attachment_template_id);
1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

Line 1841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1837: END IF;
1838:
1839: -- debug log
1840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1842: G_MODULE||l_api_name,
1843: '300: x_attachment_template_id : '||x_attachment_template_id);
1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1845: G_MODULE||l_api_name,

Line 1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1840: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1841: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1842: G_MODULE||l_api_name,
1843: '300: x_attachment_template_id : '||x_attachment_template_id);
1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1845: G_MODULE||l_api_name,
1846: '300: x_message_template_id : '||x_message_template_id);
1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1848: G_MODULE||l_api_name,

Line 1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1843: '300: x_attachment_template_id : '||x_attachment_template_id);
1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1845: G_MODULE||l_api_name,
1846: '300: x_message_template_id : '||x_message_template_id);
1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1848: G_MODULE||l_api_name,
1849: '300: x_contract_update_status : '||x_contract_update_status);
1850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1851: G_MODULE||l_api_name,

Line 1850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1846: '300: x_message_template_id : '||x_message_template_id);
1847: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1848: G_MODULE||l_api_name,
1849: '300: x_contract_update_status : '||x_contract_update_status);
1850: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1851: G_MODULE||l_api_name,
1852: '300: x_attachment_name : '||x_attachment_name);
1853: END IF;
1854:

Line 1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1855: -- Standard call to get message count and if count is 1, get message info.
1856: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1857:
1858: -- end debug log
1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1861: G_MODULE||l_api_name,
1862: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1863: END IF;

Line 1860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1856: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1857:
1858: -- end debug log
1859: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1860: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1861: G_MODULE||l_api_name,
1862: '1000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1863: END IF;
1864:

Line 1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1863: END IF;
1864:
1865: EXCEPTION
1866: WHEN FND_API.G_EXC_ERROR THEN
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1869: G_MODULE||l_api_name,
1870: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1871: END IF;

Line 1868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1864:
1865: EXCEPTION
1866: WHEN FND_API.G_EXC_ERROR THEN
1867: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1868: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1869: G_MODULE||l_api_name,
1870: '2000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1871: END IF;
1872:

Line 1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1873: x_return_status := G_RET_STS_ERROR ;
1874: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1881: END IF;

Line 1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1874: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1879: G_MODULE||l_api_name,
1880: '3000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1881: END IF;
1882:

Line 1887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1883: x_return_status := G_RET_STS_UNEXP_ERROR ;
1884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1885:
1886: WHEN OTHERS THEN
1887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1889: G_MODULE||l_api_name,
1890: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1891: END IF;

Line 1888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,

1884: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
1885:
1886: WHEN OTHERS THEN
1887: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1889: G_MODULE||l_api_name,
1890: '4000: Leaving '||G_PKG_NAME ||'.'||l_api_name);
1891: END IF;
1892: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );