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_ACCRUAL_LOAD dependencies on FND_LOG

Line 6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2: /* $Header: CSTACCLB.pls 120.27.12010000.8 2009/02/13 12:31:05 smsasidh ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_ACCRUAL_LOAD';
5: G_LOG_HEADER CONSTANT VARCHAR2(40) := 'cst.plsql.CST_ACCRUAL_LOAD';
6: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
7: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
8:
9: --Local procedure and function
10: g_dummy_date CONSTANT DATE := TO_DATE('3000/01/01 00:00:00','YYYY/MM/DD HH24:MI:SS');

Line 17: | Purpose : This Procedure logs the message in fnd_log_messages |

13: /*===========================================================================+
14: | |
15: | Procedure Name : debug |
16: | |
17: | Purpose : This Procedure logs the message in fnd_log_messages |
18: | |
19: | Called from : |
20: | |
21: | Parameters : |

Line 35: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)

31: PROCEDURE debug
32: ( line IN VARCHAR2,
33: msg_prefix IN VARCHAR2 DEFAULT 'CST',
34: msg_module IN VARCHAR2 DEFAULT G_PKG_NAME,
35: msg_level IN NUMBER DEFAULT FND_LOG.LEVEL_STATEMENT)
36: IS
37: l_msg_prefix VARCHAR2(64);
38: l_msg_level NUMBER;
39: l_msg_module VARCHAR2(256);

Line 52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;

48:
49: fnd_file.put_line(fnd_file.LOG, line);
50:
51: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
53: END IF;
54: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
55: RETURN;
56: END IF;

Line 54: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN

50:
51: IF (INSTRB(upper(l_line), 'EXCEPTION') <> 0) THEN
52: l_msg_level := FND_LOG.LEVEL_EXCEPTION;
53: END IF;
54: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
55: RETURN;
56: END IF;
57: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
58: FND_LOG.STRING(l_msg_level,l_msg_module,SUBSTRB(l_line,1,1000));

Line 57: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

53: END IF;
54: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
55: RETURN;
56: END IF;
57: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
58: FND_LOG.STRING(l_msg_level,l_msg_module,SUBSTRB(l_line,1,1000));
59: FND_FILE.put_line(fnd_file.log, SUBSTRB(l_line,1,1000) );
60: END IF;
61: EXCEPTION

Line 58: FND_LOG.STRING(l_msg_level,l_msg_module,SUBSTRB(l_line,1,1000));

54: IF l_msg_level <> FND_LOG.LEVEL_EXCEPTION AND G_DEBUG = 'N' THEN
55: RETURN;
56: END IF;
57: IF ( l_msg_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
58: FND_LOG.STRING(l_msg_level,l_msg_module,SUBSTRB(l_line,1,1000));
59: FND_FILE.put_line(fnd_file.log, SUBSTRB(l_line,1,1000) );
60: END IF;
61: EXCEPTION
62: WHEN OTHERS THEN RAISE;

Line 455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

451: l_api_name CONSTANT VARCHAR2(30) := 'Start_accrual_load';
452: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
453: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
454:
455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

452: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
453: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
454:
455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
460:

Line 457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

453: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
454:
455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
460:
461: BEGIN

Line 458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

454:
455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
460:
461: BEGIN
462:

Line 459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

455: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
456: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
457: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
458: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
459: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
460:
461: BEGIN
462:
463: debug('start_accrual_load +');

Line 591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

587: l_api_name CONSTANT VARCHAR2(30) := 'accrual_load';
588: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
589: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
590:
591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

588: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
589: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
590:
591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:

Line 593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

589: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
590:
591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: --BUG#7384429

Line 594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

590:
591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: --BUG#7384429
598: CURSOR c_chk_misc_inv(p_ou_id IN NUMBER,

Line 595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

591: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
592: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
593: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
594: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
595: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
596:
597: --BUG#7384429
598: CURSOR c_chk_misc_inv(p_ou_id IN NUMBER,
599: p_from_date IN DATE,

Line 1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

1064: l_api_name CONSTANT VARCHAR2(30) := 'Upgrade_old_data';
1065: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1066: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1067:
1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

1065: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1066: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1067:
1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1073:

Line 1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

1066: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
1067:
1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1073:
1074:

Line 1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

1067:
1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1073:
1074:
1075:

Line 1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

1068: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
1069: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
1070: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
1071: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
1072: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
1073:
1074:
1075:
1076: BEGIN

Line 2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

2231: l_api_name CONSTANT VARCHAR2(30) := 'Load_ap_misc_data';
2232: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2233: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2234:
2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2232: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2233: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2234:
2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2240:

Line 2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

2233: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2234:
2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2240:
2241: BEGIN

Line 2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2234:
2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2240:
2241: BEGIN
2242: debug('Load_ap_misc_data +');

Line 2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2235: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2236: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2237: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2238: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2239: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2240:
2241: BEGIN
2242: debug('Load_ap_misc_data +');
2243: debug(' p_operating_unit : ' || p_operating_unit);

Line 2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

2539: l_api_name CONSTANT VARCHAR2(30) := 'Load_inv_misc_data';
2540: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2541: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2542:
2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2540: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2541: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2542:
2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2548:

Line 2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

2541: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2542:
2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2548:
2549: CURSOR c_opm_count IS

Line 2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2542:
2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2548:
2549: CURSOR c_opm_count IS
2550: SELECT 1 FROM gmf_rcv_accounting_txns

Line 2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2543: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2544: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2545: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2546: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2547: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2548:
2549: CURSOR c_opm_count IS
2550: SELECT 1 FROM gmf_rcv_accounting_txns
2551: WHERE org_id = p_operating_unit

Line 2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

2989: l_api_name CONSTANT VARCHAR2(30) := 'Insert_build_parameters';
2990: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2991: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2992:
2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

2990: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
2991: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2992:
2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2998:

Line 2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

2991: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
2992:
2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2998:
2999: BEGIN

Line 2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

2992:
2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2998:
2999: BEGIN
3000: debug('Insert_build_parameters+');

Line 2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

2993: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
2994: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
2995: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
2996: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
2997: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
2998:
2999: BEGIN
3000: debug('Insert_build_parameters+');
3001: debug(' p_operating_unit : ' || p_operating_unit);

Line 3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);

3117: l_api_name CONSTANT VARCHAR2(30) := 'Load_ap_po_data';
3118: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
3119: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
3120:
3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

3118: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
3119: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
3120:
3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3126:

Line 3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

3119: l_module CONSTANT VARCHAR2(60) := 'cst.plsql.'||l_full_name;
3120:
3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3126:
3127: /* The following cursor picks up PO distributions IDs that have had any activity

Line 3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

3120:
3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3126:
3127: /* The following cursor picks up PO distributions IDs that have had any activity
3128: (receipts or Invoices) against them recorded between the supplied from and to dates.Exclude consigned POs*/

Line 3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

3121: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
3122: l_errorLog CONSTANT BOOLEAN := l_uLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
3123: l_exceptionLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
3124: l_pLog CONSTANT BOOLEAN := l_exceptionLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
3125: l_sLog CONSTANT BOOLEAN := l_pLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
3126:
3127: /* The following cursor picks up PO distributions IDs that have had any activity
3128: (receipts or Invoices) against them recorded between the supplied from and to dates.Exclude consigned POs*/
3129: /* This query has been hinted based on suggestion from lguitterez,skoka of the perf team to avoid the bind peeking issue*/