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

Line 5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY RCV_SLA_MRC_UPDATE_PKG AS
2: /* $Header: RCVPUMCB.pls 120.4 2006/04/24 00:00 bigoyal noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_SLA_MRC_UPDATE_PKG';
5: G_LOG_LEVEL CONSTANT NUMBER := fnd_log.G_CURRENT_RUNTIME_LEVEL;
6: gUserId number := nvl(fnd_global.user_id, -888);
7: gLoginId number := nvl(fnd_global.login_id, -888);
8: gUpdateDate DATE := sysdate;
9:

Line 37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND

33: l_je_category_name varchar2(30);
34:
35: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger';
36:
37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

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

34:
35: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger';
36:
37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
42:

Line 39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;

35: l_module CONSTANT VARCHAR2(90) := 'cst.plsql.RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger';
36:
37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
42:
43: l_stmt_num number;

Line 40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;

36:
37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
42:
43: l_stmt_num number;
44:

Line 41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;

37: l_uLog CONSTANT BOOLEAN := fnd_log.level_unexpected >= G_LOG_LEVEL AND
38: fnd_log.TEST(fnd_log.level_unexpected, l_module);
39: l_errorLog CONSTANT BOOLEAN := l_uLog AND fnd_log.level_error >= G_LOG_LEVEL;
40: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND fnd_log.level_exception >= G_LOG_LEVEL;
41: l_pLog CONSTANT BOOLEAN := l_exceptionLog AND fnd_log.level_procedure >= G_LOG_LEVEL;
42:
43: l_stmt_num number;
44:
45: BEGIN

Line 49: fnd_log.string(

45: BEGIN
46: l_stmt_num :=0;
47:
48: IF l_plog THEN
49: fnd_log.string(
50: fnd_log.level_procedure,
51: l_module||'.'||l_stmt_num,
52: 'Entering RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
53: 'X_upg_batch_id = '||X_upg_batch_id||','||

Line 50: fnd_log.level_procedure,

46: l_stmt_num :=0;
47:
48: IF l_plog THEN
49: fnd_log.string(
50: fnd_log.level_procedure,
51: l_module||'.'||l_stmt_num,
52: 'Entering RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
53: 'X_upg_batch_id = '||X_upg_batch_id||','||
54: 'X_je_category_name = '||X_je_category_name

Line 337: fnd_log.string(

333:
334: <>
335:
336: IF l_plog THEN
337: fnd_log.string(
338: fnd_log.level_procedure,
339: l_module||'.end',
340: 'Exiting RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
341: 'X_errbuf = '||X_errbuf||','||

Line 338: fnd_log.level_procedure,

334: <>
335:
336: IF l_plog THEN
337: fnd_log.string(
338: fnd_log.level_procedure,
339: l_module||'.end',
340: 'Exiting RCV_SLA_MRC_UPDATE_PKG.Update_Receiving_MRC_Subledger with '||
341: 'X_errbuf = '||X_errbuf||','||
342: 'X_retcode = '||X_retcode

Line 357: fnd_log.string(

353: p_pkg_name => 'RCV_SLA_MRC_UPDATE_PKG',
354: p_procedure_name => 'Update_Receiving_MRC_Subledger',
355: p_error_text => 'An exception has occurred.'
356: );
357: fnd_log.string(
358: fnd_log.level_exception,
359: l_module||'.'||l_stmt_num,
360: 'An exception has occurred.'
361: );

Line 358: fnd_log.level_exception,

354: p_procedure_name => 'Update_Receiving_MRC_Subledger',
355: p_error_text => 'An exception has occurred.'
356: );
357: fnd_log.string(
358: fnd_log.level_exception,
359: l_module||'.'||l_stmt_num,
360: 'An exception has occurred.'
361: );
362: END IF;

Line 371: fnd_log.message(

367: IF l_errorLog THEN
368: fnd_message.set_name('BOM','CST_ERROR');
369: fnd_message.set_token('SQLERRM',SQLERRM);
370: fnd_msg_pub.add;
371: fnd_log.message(
372: fnd_log.level_error,
373: l_module||'.'||l_stmt_num,
374: FALSE
375: );

Line 372: fnd_log.level_error,

368: fnd_message.set_name('BOM','CST_ERROR');
369: fnd_message.set_token('SQLERRM',SQLERRM);
370: fnd_msg_pub.add;
371: fnd_log.message(
372: fnd_log.level_error,
373: l_module||'.'||l_stmt_num,
374: FALSE
375: );
376: END IF;

Line 381: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

377: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
378: WHEN OTHERS THEN
379: ROLLBACK;
380: X_retcode := FND_API.g_ret_sts_unexp_error;
381: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
382: fnd_message.set_name('BOM','CST_UNEXPECTED');
383: fnd_message.set_token('SQLERRM',SQLERRM);
384: fnd_msg_pub.add;
385: fnd_log.message(

Line 385: fnd_log.message(

381: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
382: fnd_message.set_name('BOM','CST_UNEXPECTED');
383: fnd_message.set_token('SQLERRM',SQLERRM);
384: fnd_msg_pub.add;
385: fnd_log.message(
386: fnd_log.level_unexpected,
387: l_module||'.'||l_stmt_num,
388: FALSE
389: );

Line 386: fnd_log.level_unexpected,

382: fnd_message.set_name('BOM','CST_UNEXPECTED');
383: fnd_message.set_token('SQLERRM',SQLERRM);
384: fnd_msg_pub.add;
385: fnd_log.message(
386: fnd_log.level_unexpected,
387: l_module||'.'||l_stmt_num,
388: FALSE
389: );
390: END IF;