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

Line 33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

29:
30: l_api_name CONSTANT VARCHAR(30) := 'CREATE_EAM_GENEALOGY';
31: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:

Line 34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);

30: l_api_name CONSTANT VARCHAR(30) := 'CREATE_EAM_GENEALOGY';
31: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:
38: /*

Line 35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

31: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:
38: /*
39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

Line 36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

32:
33: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
34: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:
38: /*
39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
40: l_plog boolean ; -- := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);

Line 39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

35: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:
38: /*
39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
40: l_plog boolean ; -- := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
41: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
42: */
43:

Line 40: l_plog boolean ; -- := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);

36: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
37:
38: /*
39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
40: l_plog boolean ; -- := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
41: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
42: */
43:
44: l_errCode number;

Line 41: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);

37:
38: /*
39: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
40: l_plog boolean ; -- := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
41: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
42: */
43:
44: l_errCode number;
45: l_msg_count number;

Line 78: -- l_plog := ( (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND l_log );

74: l_parent_instance_number varchar2(30);
75:
76:
77: begin
78: -- l_plog := ( (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) AND l_log );
79: savepoint eam_rebuild_genealogy;
80:
81: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
82: p_api_version,

Line 103: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: l_return_status := FND_API.G_RET_STS_SUCCESS;
101:
102:
103: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
104: 'Start of ' || l_module || '('
105: || 'p_organization_id='|| p_organization_id || ','
106: || 'p_subinventory='|| p_subinventory || ','
107: || 'p_locator_id='|| p_locator_id || ','

Line 392: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);

388: l_api_name CONSTANT VARCHAR(30) := 'UPDATE_EAM_GENEALOGY';
389: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
390:
391: /*
392: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
393: l_plog boolean := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
395: */
396:

Line 393: l_plog boolean := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);

389: l_module constant varchar2(200) := 'eam.plsql.'||g_pkg_name|| '.' || l_api_name;
390:
391: /*
392: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
393: l_plog boolean := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
395: */
396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

Line 394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);

390:
391: /*
392: l_log boolean := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
393: l_plog boolean := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
395: */
396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);

Line 397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;

393: l_plog boolean := l_log and FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, l_module);
394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
395: */
396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
399: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
400: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
401:

Line 398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);

394: l_slog boolean := l_plog and FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, l_module);
395: */
396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
399: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
400: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
401:
402: l_errCode number;

Line 399: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;

395: */
396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
399: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
400: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
401:
402: l_errCode number;
403: l_msg_count number;

Line 400: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

396:
397: l_log_level CONSTANT NUMBER := fnd_log.g_current_runtime_level;
398: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND fnd_log.test(fnd_log.level_unexpected, l_module);
399: l_pLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_procedure >= l_log_level;
400: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
401:
402: l_errCode number;
403: l_msg_count number;
404: l_msg_data varchar2(100);

Line 466: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,

462: -- Initialize API return status to success
463: x_return_status := FND_API.G_RET_STS_SUCCESS;
464: l_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: if (l_plog) then FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, l_module,
467: 'Start of ' || l_module || '('
468: || 'p_organization_id='|| p_organization_id || ','
469: || 'p_subinventory='|| p_subinventory || ','
470: || 'p_locator_id='|| p_locator_id || ','