DBA Data[Home] [Help]

APPS.CST_LCMADJUSTMENTS_PUB dependencies on FND_LOG

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

8: allowed for the Cost manager.
9: ------------------------------------------------------------------------------------------*/
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30):='CST_LcmAdjustments_PUB';
12: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
13: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
14: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'po.plsql.'||G_PKG_NAME;
15:
16: /*===========================================================================+

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

48: l_api_version CONSTANT NUMBER := 1.0;
49: l_return_status VARCHAR2(1);
50: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

Line 53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

49: l_return_status VARCHAR2(1);
50: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);

50: l_module CONSTANT VARCHAR2(100) := 'cst.plsql.'|| G_PKG_NAME || '.' || l_api_name;
51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:

Line 55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

51:
52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: l_stmt_num NUMBER;

Line 56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

52: l_uLog CONSTANT BOOLEAN := FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module) AND (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL);
53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: l_stmt_num NUMBER;
60:

Line 57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

53: l_errorLog CONSTANT BOOLEAN := l_uLog AND (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
54: l_exceptionLog CONSTANT BOOLEAN := l_errorLog AND (FND_LOG.LEVEL_EXCEPTION >= G_LOG_LEVEL);
55: l_eventLog CONSTANT BOOLEAN := l_exceptionLog AND (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
56: l_pLog CONSTANT BOOLEAN := l_eventLog AND (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
57: l_sLog CONSTANT BOOLEAN := l_pLog AND (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
58:
59: l_stmt_num NUMBER;
60:
61: l_conc_status BOOLEAN;

Line 79: FND_LOG.STRING(

75: l_stmt_num := 0;
76:
77: -- Procedure level log message for Entry point
78: IF (l_pLog) THEN
79: FND_LOG.STRING(
80: FND_LOG.LEVEL_PROCEDURE,
81: l_module || '.begin',
82: 'Launch_Workers <<'
83: );

Line 80: FND_LOG.LEVEL_PROCEDURE,

76:
77: -- Procedure level log message for Entry point
78: IF (l_pLog) THEN
79: FND_LOG.STRING(
80: FND_LOG.LEVEL_PROCEDURE,
81: l_module || '.begin',
82: 'Launch_Workers <<'
83: );
84: END IF;

Line 163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module, 'Could not launch landed cost adjustment worker for group_id ' || to_char(l_group_id));

159:
160: COMMIT WORK;
161: fnd_file.put_line(fnd_file.log, 'Could not launch landed cost adjustment worker for group_id ' || to_char(l_group_id));
162: IF (l_uLog) THEN
163: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED,l_module, 'Could not launch landed cost adjustment worker for group_id ' || to_char(l_group_id));
164: END IF;
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167: l_stmt_num := 90;

Line 178: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

174: EXCEPTION
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK;
177: IF (l_uLog) THEN
178: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
179: END IF;
180:
181: /* Set concurrent program status to error */
182: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

Line 187: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);

183:
184: WHEN FND_API.G_EXC_ERROR THEN
185: ROLLBACK;
186: IF (l_exceptionLog) THEN
187: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,l_module, TRUE);
188: END IF;
189:
190: /* Set concurrent program status to error */
191: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',FND_MESSAGE.GET);

Line 199: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);

195:
196: FND_MESSAGE.SET_NAME('BOM','CST_LOG_UNEXPECTED');
197: FND_MESSAGE.SET_TOKEN('SQLERRM',SQLERRM);
198: IF (l_uLog) THEN
199: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,l_module, TRUE);
200: END IF;
201:
202: /* Set concurrent program status to error */
203: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',