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

Line 66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

62: l_stmt_num NUMBER := 0;
63: l_ledger_id NUMBER;
64:
65: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent';
66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND

63: l_ledger_id NUMBER;
64:
65: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent';
66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 68: fnd_log.TEST(fnd_log.level_unexpected, l_module);

64:
65: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent';
66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

65: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent';
66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

66: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN

Line 71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

67: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN
75: IF l_plog THEN

Line 72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

68: fnd_log.TEST(fnd_log.level_unexpected, l_module);
69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN
75: IF l_plog THEN
76: fnd_log.string(

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

69: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
70: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
71: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN
75: IF l_plog THEN
76: fnd_log.string(
77: fnd_log.level_procedure,

Line 76: fnd_log.string(

72: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN
75: IF l_plog THEN
76: fnd_log.string(
77: fnd_log.level_procedure,
78: l_module||'.'||l_stmt_num,
79: 'Entering CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
80: 'p_api_version = '||p_api_version||','||

Line 77: fnd_log.level_procedure,

73: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
74: BEGIN
75: IF l_plog THEN
76: fnd_log.string(
77: fnd_log.level_procedure,
78: l_module||'.'||l_stmt_num,
79: 'Entering CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
80: 'p_api_version = '||p_api_version||','||
81: 'p_revenue_event_line_id = '||p_revenue_event_line_id||','||

Line 181: fnd_log.string(

177: , p_encoded => FND_API.g_false
178: );
179:
180: IF l_plog THEN
181: fnd_log.string(
182: fnd_log.level_procedure,
183: l_module||'.'||l_stmt_num,
184: 'Exiting CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
185: 'x_return_status = '||x_return_status||','||

Line 182: fnd_log.level_procedure,

178: );
179:
180: IF l_plog THEN
181: fnd_log.string(
182: fnd_log.level_procedure,
183: l_module||'.'||l_stmt_num,
184: 'Exiting CST_RevenueCogsMatch_GRP.Receive_CloseLineEvent with '||
185: 'x_return_status = '||x_return_status||','||
186: 'x_msg_count = '||x_msg_count||','||

Line 194: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num,

190:
191: EXCEPTION
192: WHEN dup_val_on_index THEN
193: IF l_eventLog THEN
194: FND_LOG.string(FND_LOG.LEVEL_EVENT,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num,
195: 'Row already exists in cst_revenue_recognition_lines.');
196: END IF;
197:
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_success) THEN

Line 217: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN

213:
214: ROLLBACK TO Receive_CloseLineEvent_GRP;
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
219: ,'Receive_CloseLineEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
220: END IF;
221:

Line 218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

214: ROLLBACK TO Receive_CloseLineEvent_GRP;
215: x_return_status := fnd_api.g_ret_sts_unexp_error ;
216:
217: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
219: ,'Receive_CloseLineEvent '||l_stmt_num||' : '||substr(SQLERRM,1,200));
220: END IF;
221:
222: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)

Line 297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

293: l_stmt_num NUMBER := 0;
294: l_closed_cst_periods NUMBER;
295:
296: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Return_PeriodStatuses';
297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

Line 298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND

294: l_closed_cst_periods NUMBER;
295:
296: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Return_PeriodStatuses';
297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

Line 299: fnd_log.TEST(fnd_log.level_unexpected, l_module);

295:
296: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Return_PeriodStatuses';
297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

Line 300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;

296: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.CST_RevenueCogsMatch_GRP.Return_PeriodStatuses';
297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
304: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;

Line 301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;

297: l_log_level CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
304: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
305:

Line 302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;

298: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= l_log_level AND
299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
304: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
305:
306: BEGIN

Line 303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;

299: fnd_log.TEST(fnd_log.level_unexpected, l_module);
300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
304: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
305:
306: BEGIN
307:

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

300: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= l_log_level;
301: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= l_log_level;
302: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_event >= l_log_level;
303: l_pLog CONSTANT BOOLEAN := l_eventLog AND fnd_log.level_procedure >= l_log_level;
304: l_sLog CONSTANT BOOLEAN := l_pLog AND fnd_log.level_statement >= l_log_level;
305:
306: BEGIN
307:
308: IF l_plog THEN

Line 309: fnd_log.string(

305:
306: BEGIN
307:
308: IF l_plog THEN
309: fnd_log.string(
310: fnd_log.level_procedure,
311: l_module||'.'||l_stmt_num,
312: 'Entering CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
313: 'p_api_version = '||p_api_version||','||

Line 310: fnd_log.level_procedure,

306: BEGIN
307:
308: IF l_plog THEN
309: fnd_log.string(
310: fnd_log.level_procedure,
311: l_module||'.'||l_stmt_num,
312: 'Entering CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
313: 'p_api_version = '||p_api_version||','||
314: 'p_set_of_books_id = '||p_set_of_books_id||','||

Line 379: fnd_log.string(

375: , p_data => x_msg_data
376: );
377:
378: IF l_plog THEN
379: fnd_log.string(
380: fnd_log.level_procedure,
381: l_module||'.'||l_stmt_num,
382: 'Exiting CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
383: 'x_return_status = '||x_return_status||','||

Line 380: fnd_log.level_procedure,

376: );
377:
378: IF l_plog THEN
379: fnd_log.string(
380: fnd_log.level_procedure,
381: l_module||'.'||l_stmt_num,
382: 'Exiting CST_RevenueCogsMatch_GRP.Return_PeriodStatuses with '||
383: 'x_return_status = '||x_return_status||','||
384: 'x_msg_count = '||x_msg_count||','||

Line 396: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN

392:
393: ROLLBACK TO Return_PeriodStatuses_GRP;
394: x_return_status := fnd_api.g_ret_sts_unexp_error ;
395:
396: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
398: ,'Return_PeriodStatuses '||l_stmt_num||' : '||substr(SQLERRM,1,200));
399: END IF;
400:

Line 397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num

393: ROLLBACK TO Return_PeriodStatuses_GRP;
394: x_return_status := fnd_api.g_ret_sts_unexp_error ;
395:
396: IF fnd_log.level_unexpected >= fnd_log.G_CURRENT_RUNTIME_LEVEL THEN
397: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,G_LOG_HEAD || '.'||l_api_name||'.'||l_stmt_num
398: ,'Return_PeriodStatuses '||l_stmt_num||' : '||substr(SQLERRM,1,200));
399: END IF;
400:
401: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) -- *** check this w/ API standards!