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

Line 15: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_RO_BULLETINS_PVT';
12: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdvrobb.pls';
13:
14: -- Global variable for storing the debug level
15: G_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
16:
17:
18:
19: -- *******************************************************

Line 1330: -- VARIABLES FOR FND LOG --

1326: -- STANDARD API and DEBUG CONSTANTS --
1327: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETINS_TO_REPAIRS_CP';
1328: l_api_version CONSTANT NUMBER := 1.0;
1329:
1330: -- VARIABLES FOR FND LOG --
1331: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
1332: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletins_to_repairs_conc_prog';
1333:
1334: -- VARIABLES --

Line 1331: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;

1327: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETINS_TO_REPAIRS_CP';
1328: l_api_version CONSTANT NUMBER := 1.0;
1329:
1330: -- VARIABLES FOR FND LOG --
1331: l_error_level NUMBER := FND_LOG.LEVEL_ERROR;
1332: l_mod_name VARCHAR2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletins_to_repairs_conc_prog';
1333:
1334: -- VARIABLES --
1335: l_return_status VARCHAR2(30) := FND_API.G_RET_STS_SUCCESS;

Line 1470: -- VARIABLES FOR FND LOG --

1466: -- STANDARD CONSTANTS
1467: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETIN_FOR_RULE';
1468: l_api_version CONSTANT NUMBER := 1.0;
1469:
1470: -- VARIABLES FOR FND LOG --
1471: l_error_level number := FND_LOG.LEVEL_ERROR;
1472: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletin_for_rule';
1473:
1474: --VARIABLES --

Line 1471: l_error_level number := FND_LOG.LEVEL_ERROR;

1467: l_api_name CONSTANT VARCHAR2(30) := 'LINK_BULLETIN_FOR_RULE';
1468: l_api_version CONSTANT NUMBER := 1.0;
1469:
1470: -- VARIABLES FOR FND LOG --
1471: l_error_level number := FND_LOG.LEVEL_ERROR;
1472: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.link_bulletin_for_rule';
1473:
1474: --VARIABLES --
1475: l_sql_query VARCHAR2(32767) := null;

Line 1629: fnd_log.message(l_error_level,l_mod_name,FALSE);

1625: IF ( l_error_level >= G_debug_level) THEN
1626: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1627: fnd_message.set_token('SQLERRM',SQLERRM);
1628: fnd_message.set_token('SQLCODE',SQLCODE);
1629: fnd_log.message(l_error_level,l_mod_name,FALSE);
1630: END If;
1631: -- As we are committing the processed records in the inner APIs
1632: -- so we rollback only if the p_commit='F'
1633: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 1646: fnd_log.message(l_error_level,l_mod_name,FALSE);

1642: IF ( l_error_level >= G_debug_level) THEN
1643: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1644: fnd_message.set_token('SQLERRM',SQLERRM);
1645: fnd_message.set_token('SQLCODE',SQLCODE);
1646: fnd_log.message(l_error_level,l_mod_name,FALSE);
1647: END If;
1648: -- As we are committing the processed records in the inner APIs
1649: -- so we rollback only if the p_commit='F'
1650: IF NOT(FND_API.To_Boolean( p_commit )) THEN

Line 1750: -- VARIABLES FOR FND LOG --

1746: -- STANDARD CONSTANTS
1747: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_BULLETIN_SCS_TO_RO';
1748: l_api_version CONSTANT NUMBER := 1.0;
1749:
1750: -- VARIABLES FOR FND LOG --
1751: l_error_level number := FND_LOG.LEVEL_ERROR;
1752: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.apply_bulletin_scs_to_ro';
1753:
1754: -- VARIABLES --

Line 1751: l_error_level number := FND_LOG.LEVEL_ERROR;

1747: l_api_name CONSTANT VARCHAR2(30) := 'APPLY_BULLETIN_SCS_TO_RO';
1748: l_api_version CONSTANT NUMBER := 1.0;
1749:
1750: -- VARIABLES FOR FND LOG --
1751: l_error_level number := FND_LOG.LEVEL_ERROR;
1752: l_mod_name varchar2(2000) := 'csd.plsql.csd_ro_bulletins_pvt.apply_bulletin_scs_to_ro';
1753:
1754: -- VARIABLES --
1755: l_in_domain VARCHAR2(1);

Line 1896: fnd_log.message(l_error_level,l_mod_name,FALSE);

1892: IF ( l_error_level >= G_debug_level) THEN
1893: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1894: fnd_message.set_token('SQLERRM',SQLERRM);
1895: fnd_message.set_token('SQLCODE',SQLCODE);
1896: fnd_log.message(l_error_level,l_mod_name,FALSE);
1897: END If;
1898: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900: FND_MSG_PUB.Count_And_Get

Line 1909: fnd_log.message(l_error_level,l_mod_name,FALSE);

1905: IF ( l_error_level >= G_debug_level) THEN
1906: fnd_message.set_name('CSD','CSD_SQL_ERROR');
1907: fnd_message.set_token('SQLERRM',SQLERRM);
1908: fnd_message.set_token('SQLCODE',SQLCODE);
1909: fnd_log.message(l_error_level,l_mod_name,FALSE);
1910: END If;
1911: ROLLBACK TO APPLY_BULLETIN_SCS_TO_RO;
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1913: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN