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.

[Home] [Help]

APPS.ZX_CONDITIONS_PKG dependencies on FND_LOG

Line 6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

2: /* $Header: zxdconditionsb.pls 120.5.12020000.2 2013/01/31 06:43:40 srajapar ship $ */
3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

Line 7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

3:
4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

4: -- Logging Infra
5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';

Line 9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

5: G_CURRENT_RUNTIME_LEVEL NUMBER;
6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';
13: -- Logging Infra

Line 10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

6: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';
13: -- Logging Infra
14:

Line 11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

7: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
8: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
9: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
10: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
11: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
12: G_MODULE_NAME CONSTANT VARCHAR2(30) := 'ZX.PLSQL.ZX_CONDITIONS_PKG.';
13: -- Logging Infra
14:
15: procedure bulk_insert_conditions (

Line 134: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

130:
131: BEGIN
132:
133: -- Logging Infra: Setting up runtime level
134: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
135: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_PROCEDURE,
137: G_MODULE_NAME || l_procedure_name,
138: 'Started for '||

Line 136: FND_LOG.STRING(G_LEVEL_PROCEDURE,

132:
133: -- Logging Infra: Setting up runtime level
134: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
135: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
136: FND_LOG.STRING(G_LEVEL_PROCEDURE,
137: G_MODULE_NAME || l_procedure_name,
138: 'Started for '||
139: ': det_factor_templ_code :'||p_det_factor_templ_code ||
140: ': condition_group_id :'||p_condition_group_id ||

Line 145: FND_LOG.STRING(G_LEVEL_PROCEDURE,

141: ': condition_id :'||p_condition_id
142: );
143: END IF;
144: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
145: FND_LOG.STRING(G_LEVEL_PROCEDURE,
146: G_MODULE_NAME || l_procedure_name,
147: ': det_factor_class_code :'||p_det_factor_class_code ||
148: ': det_factor_code :'||p_det_factor_code ||
149: ': det_factor_cq_code :'||p_det_factor_cq_code ||

Line 154: FND_LOG.STRING(G_LEVEL_PROCEDURE,

150: ': operator_code :'||p_operator_code
151: );
152: END IF;
153: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
154: FND_LOG.STRING(G_LEVEL_PROCEDURE,
155: G_MODULE_NAME || l_procedure_name,
156: ': alphanumeric_value :'||p_alphanumeric_value ||
157: ': numeric_value :'||p_numeric_value ||
158: ': date_value :'||p_date_value ||

Line 206: FND_LOG.STRING(G_LEVEL_PROCEDURE,

202: AND rownum = 1;
203: END IF;
204: x_return_status := FND_API.G_RET_STS_ERROR;
205: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
206: FND_LOG.STRING(G_LEVEL_PROCEDURE,
207: G_MODULE_NAME || l_procedure_name,
208: 'Ended with duplicate code existing at : '||x_condition_group_code);
209: END IF;
210:

Line 216: FND_LOG.STRING(G_LEVEL_PROCEDURE,

212: WHEN NO_DATA_FOUND THEN
213: -- success case for us
214: x_return_status := FND_API.G_RET_STS_SUCCESS;
215: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
216: FND_LOG.STRING(G_LEVEL_PROCEDURE,
217: G_MODULE_NAME || l_procedure_name,
218: 'Ended with NO duplicate code -- VALID record');
219: END IF;
220: WHEN OTHERS THEN

Line 224: FND_LOG.STRING(G_LEVEL_PROCEDURE,

220: WHEN OTHERS THEN
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
222: x_msg_data := SQLERRM;
223: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
224: FND_LOG.STRING(G_LEVEL_PROCEDURE,
225: G_MODULE_NAME || l_procedure_name,
226: 'Unexpected Error '||SQLERRM);
227: END IF;
228: