DBA Data[Home] [Help]

APPS.ZX_SIM_RULES_PKG dependencies on FND_LOG

Line 5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY ZX_SIM_RULES_PKG AS
2: /* $Header: zxrisimrulespkgb.pls 120.1 2005/10/27 18:50:58 pla ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:

Line 6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

2: /* $Header: zxrisimrulespkgb.pls 120.1 2005/10/27 18:50:58 pla ship $ */
3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row

Line 7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

3:
4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row
11: (p_sim_tax_rule_id NUMBER,

Line 8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

4: g_current_runtime_level NUMBER;
5: g_level_statement CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: g_level_procedure CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
7: g_level_event CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
8: g_level_unexpected CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
9:
10: PROCEDURE Insert_Row
11: (p_sim_tax_rule_id NUMBER,
12: p_content_owner_id NUMBER,

Line 39: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

35: l_msg_count NUMBER;
36: l_msg_data VARCHAR2(1000);
37:
38: BEGIN
39: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
40:
41: IF (g_level_procedure >= g_current_runtime_level ) THEN
42: FND_LOG.STRING(g_level_procedure,
43: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',

Line 42: FND_LOG.STRING(g_level_procedure,

38: BEGIN
39: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
40:
41: IF (g_level_procedure >= g_current_runtime_level ) THEN
42: FND_LOG.STRING(g_level_procedure,
43: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
44: 'ZX_SIM_RULES_PKG: Insert_Row (+)');
45: END IF;
46:

Line 93: FND_LOG.STRING(g_level_procedure,

89: p_program_id,
90: p_program_login_id);
91:
92: IF (g_level_procedure >= g_current_runtime_level ) THEN
93: FND_LOG.STRING(g_level_procedure,
94: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
95: 'ZX_SIM_RULES_PKG: Insert_Row (-)');
96: END IF;
97: END Insert_Row;

Line 128: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

124: l_msg_count NUMBER;
125: l_msg_data VARCHAR2(1000);
126:
127: BEGIN
128: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
129:
130: IF (g_level_procedure >= g_current_runtime_level ) THEN
131: FND_LOG.STRING(g_level_procedure,
132: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',

Line 131: FND_LOG.STRING(g_level_procedure,

127: BEGIN
128: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
129:
130: IF (g_level_procedure >= g_current_runtime_level ) THEN
131: FND_LOG.STRING(g_level_procedure,
132: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
133: 'ZX_SIM_RULES_PKG: Update_Row (+)');
134: END IF;
135:

Line 164: FND_LOG.STRING(g_level_procedure,

160: AND content_owner_id = p_content_owner_id
161: AND application_id = p_application_id;
162:
163: IF (g_level_procedure >= g_current_runtime_level ) THEN
164: FND_LOG.STRING(g_level_procedure,
165: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Update_Row.BEGIN',
166: 'ZX_SIM_RULES_PKG: Update_Row (-)');
167: END IF;
168: END Update_Row;

Line 199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

195: l_msg_count NUMBER;
196: l_msg_data VARCHAR2(1000);
197:
198: BEGIN
199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
200:
201: IF (g_level_procedure >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_procedure,
203: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',

Line 202: FND_LOG.STRING(g_level_procedure,

198: BEGIN
199: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
200:
201: IF (g_level_procedure >= g_current_runtime_level ) THEN
202: FND_LOG.STRING(g_level_procedure,
203: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
204: 'ZX_SIM_RULES_PKG: Delete_Row (+)');
205: END IF;
206:

Line 208: FND_LOG.STRING(g_level_procedure,

204: 'ZX_SIM_RULES_PKG: Delete_Row (+)');
205: END IF;
206:
207: IF (g_level_procedure >= g_current_runtime_level ) THEN
208: FND_LOG.STRING(g_level_procedure,
209: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
210: 'ZX_SIM_RULES_PKG: Delete_Row (-)');
211: END IF;
212: END Delete_Row;

Line 273: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

269:
270: Recinfo sim_rules_csr%ROWTYPE;
271:
272: BEGIN
273: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: IF (g_level_procedure >= g_current_runtime_level ) THEN
276: FND_LOG.STRING(g_level_procedure,
277: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',

Line 276: FND_LOG.STRING(g_level_procedure,

272: BEGIN
273: g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
274:
275: IF (g_level_procedure >= g_current_runtime_level ) THEN
276: FND_LOG.STRING(g_level_procedure,
277: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
278: 'ZX_SIM_RULES_PKG: Lock_Row (+)');
279: END IF;
280:

Line 336: FND_LOG.STRING(g_level_procedure,

332: APP_EXCEPTION.Raise_Exception;
333: END IF;
334:
335: IF (g_level_procedure >= g_current_runtime_level ) THEN
336: FND_LOG.STRING(g_level_procedure,
337: 'ZX.PLSQL.ZX_SIM_RULES_PKG.Insert_Row.BEGIN',
338: 'ZX_SIM_RULES_PKG: Lock_Row (-)');
339: END IF;
340: END Lock_Row;