APPS.CST_PRJMFG_ACCT_HOOK dependencies on FND_LOG

Line 3: /* FND Logging Constants */

1: PACKAGE BODY CST_PRJMFG_ACCT_HOOK as
2: /* $Header: CSTPMHKB.pls 120.0.12010000.2 2010/02/18 01:24:35 ipineda ship $*/
3: /* FND Logging Constants */
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_XLA_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
7: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

3: /* FND Logging Constants */
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CST_XLA_PVT';
5: G_DEBUG CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
6: G_LOG_HEAD CONSTANT VARCHAR2(40) := 'cst.plsql.'||G_PKG_NAME;
7: G_LOG_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
8:
9:
10: /*----------------------------------------------------------------------------*
11: | PRIVATE FUNCTION/PROCEDURES |

Line 135: /* FND Logging */

131: l_txn_type_mmt NUMBER :=0;
132: l_txn_type_wt NUMBER :=0;
133: l_api_name CONSTANT VARCHAR2(30) := 'blueprint_sla_hook';
134: l_api_version CONSTANT NUMBER := 1.0;
135: /* FND Logging */
136: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

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

133: l_api_name CONSTANT VARCHAR2(30) := 'blueprint_sla_hook';
134: l_api_version CONSTANT NUMBER := 1.0;
135: /* FND Logging */
136: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

Line 138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);

134: l_api_version CONSTANT NUMBER := 1.0;
135: /* FND Logging */
136: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
142:

Line 139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);

135: /* FND Logging */
136: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
142:
143: BEGIN

Line 140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);

136: l_module CONSTANT VARCHAR2(100) := G_LOG_HEAD ||'.'||l_api_name;
137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
142:
143: BEGIN
144: x_return_status := fnd_api.g_ret_sts_success;

Line 141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);

137: l_unexpLog CONSTANT BOOLEAN := (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) AND FND_LOG.TEST(FND_LOG.LEVEL_UNEXPECTED, l_module);
138: l_errorLog CONSTANT BOOLEAN := l_unexpLog and (FND_LOG.LEVEL_ERROR >= G_LOG_LEVEL);
139: l_eventLog CONSTANT BOOLEAN := l_errorLog and (FND_LOG.LEVEL_EVENT >= G_LOG_LEVEL);
140: l_procLog CONSTANT BOOLEAN := l_eventLog and (FND_LOG.LEVEL_PROCEDURE >= G_LOG_LEVEL);
141: l_stmtLog CONSTANT BOOLEAN := l_procLog and (FND_LOG.LEVEL_STATEMENT >= G_LOG_LEVEL);
142:
143: BEGIN
144: x_return_status := fnd_api.g_ret_sts_success;
145:

Line 147: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

143: BEGIN
144: x_return_status := fnd_api.g_ret_sts_success;
145:
146: IF l_stmtLog THEN
147: FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
148: 'Transaction: '||p_transaction_id||
149: ': Source table: '||p_table_source );
150: END IF;
151:

Line 174: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,

170: x_msg_data := SQLERRM;
171: FND_MSG_PUB.count_and_get(p_count => x_msg_count,
172: p_data => x_msg_data);
173: --IF l_stmtLog THEN
174: -- FND_LOG.string(FND_LOG.LEVEL_STATEMENT, l_module,
175: -- 'ERROR IN cst_blueprint_create_SLA');
176: -- END IF;
177: -- raise;
178: fnd_file.put_line(FND_FILE.LOG,'Error in: CST_PRJMFG_ACCT_HOOK.blueprint_sla_hook');