DBA Data[Home] [Help]

APPS.PA_PERF_RULES_PUB dependencies on PA_PERF_RULES_PUB

Line 1: PACKAGE BODY pa_perf_rules_pub AS

1: PACKAGE BODY pa_perf_rules_pub AS
2: /* $Header: PAPERLPB.pls 120.1 2005/08/19 16:39:26 mwasowic noship $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_perf_rules_pub';
5:

Line 4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_perf_rules_pub';

1: PACKAGE BODY pa_perf_rules_pub AS
2: /* $Header: PAPERLPB.pls 120.1 2005/08/19 16:39:26 mwasowic noship $ */
3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_perf_rules_pub';
5:
6: /*==================================================================
7: PROCEDURE
8: create_rule

Line 54: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.create_rule');

50:
51: BEGIN
52:
53: -- Initialize the Error Stack
54: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.create_rule');
55: x_msg_count := 0;
56: x_msg_data := NULL;
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 61: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.create_rule',

57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
59:
60: IF l_debug_mode = 'Y' THEN
61: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.create_rule',
62: p_debug_mode => l_debug_mode );
63: END IF;
64:
65: IF l_debug_mode = 'Y' THEN

Line 66: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.create_rule';

62: p_debug_mode => l_debug_mode );
63: END IF;
64:
65: IF l_debug_mode = 'Y' THEN
66: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.create_rule';
67: pa_debug.write(g_module_name,pa_debug.g_err_stage,
68: l_debug_level3);
69: END IF;
70:

Line 103: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.create_rule';

99: end if;
100:
101:
102: IF l_debug_mode = 'Y' THEN
103: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.create_rule';
104: pa_debug.write(g_module_name,pa_debug.g_err_stage,
105: l_debug_level3);
106: pa_debug.reset_curr_function;
107: END IF;

Line 146: p_pkg_name => 'PA_PERF_RULES_PUB'

142: x_msg_count := 1;
143: x_msg_data := SQLERRM;
144:
145: FND_MSG_PUB.add_exc_msg(
146: p_pkg_name => 'PA_PERF_RULES_PUB'
147: ,p_procedure_name => 'CREATE_RULE'
148: ,p_error_text => x_msg_data);
149:
150: IF l_debug_mode = 'Y' THEN

Line 205: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Update_Rule');

201: BEGIN
202:
203: savepoint sp;
204: -- Initialize the Error Stack
205: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Update_Rule');
206: x_msg_count := 0;
207: x_msg_data := NULL;
208:
209: -- Initialize the return status to success

Line 213: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.update_rule',

209: -- Initialize the return status to success
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
212: IF l_debug_mode = 'Y' THEN
213: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.update_rule',
214: p_debug_mode => l_debug_mode );
215: END IF;
216:
217: IF l_debug_mode = 'Y' THEN

Line 218: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.update_rule';

214: p_debug_mode => l_debug_mode );
215: END IF;
216:
217: IF l_debug_mode = 'Y' THEN
218: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.update_rule';
219: pa_debug.write(g_module_name,pa_debug.g_err_stage,
220: l_debug_level3);
221:
222: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;

Line 268: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.update_rule';

264: Raise Invalid_Ret_Status;
265: end if;
266:
267: IF l_debug_mode = 'Y' THEN
268: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.update_rule';
269: pa_debug.write(g_module_name,pa_debug.g_err_stage,
270: l_debug_level3);
271: pa_debug.reset_curr_function;
272: END IF;

Line 309: p_pkg_name => 'PA_PERF_RULES_PUB'

305: x_msg_count := 1;
306: x_msg_data := substr(SQLERRM,1,240);
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: FND_MSG_PUB.add_exc_msg (
309: p_pkg_name => 'PA_PERF_RULES_PUB'
310: , p_procedure_name => PA_DEBUG.G_Err_Stack
311: , p_error_text => substr(SQLERRM,1,240));
312:
313: rollback to sp;

Line 350: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Delete_Rule');

346: savepoint sp;
347:
348:
349: -- Initialize the Error Stack
350: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.Delete_Rule');
351: x_msg_count := 0;
352: x_msg_data := NULL;
353:
354: -- Initialize the return status to success

Line 358: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.delete_rule',

354: -- Initialize the return status to success
355: x_return_status := FND_API.G_RET_STS_SUCCESS;
356:
357: IF l_debug_mode = 'Y' THEN
358: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.delete_rule',
359: p_debug_mode => l_debug_mode );
360: END IF;
361:
362: IF l_debug_mode = 'Y' THEN

Line 363: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.delete_rule';

359: p_debug_mode => l_debug_mode );
360: END IF;
361:
362: IF l_debug_mode = 'Y' THEN
363: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PUB.delete_rule';
364: pa_debug.write(g_module_name,pa_debug.g_err_stage,
365: l_debug_level3);
366: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
367: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 391: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.delete_rule';

387: Raise Invalid_Ret_Status;
388: end if;
389:
390: IF l_debug_mode = 'Y' THEN
391: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PUB.delete_rule';
392: pa_debug.write(g_module_name,pa_debug.g_err_stage,
393: l_debug_level3);
394: pa_debug.reset_curr_function;
395: END IF;

Line 432: ( p_pkg_name => 'PA_PERF_RULES_PUB'

428: x_msg_count := 1;
429: x_msg_data := substr(SQLERRM,1,240);
430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
431: FND_MSG_PUB.add_exc_msg
432: ( p_pkg_name => 'PA_PERF_RULES_PUB'
433: , p_procedure_name => PA_DEBUG.G_Err_Stack
434: , p_error_text => substr(SQLERRM,1,240));
435:
436: rollback to sp;

Line 474: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.validate_rule');

470:
471: FND_MSG_PUB.initialize;
472:
473: -- Initialize the Error Stack
474: PA_DEBUG.init_err_stack('PA_PERF_RULES_PUB.validate_rule');
475: x_msg_count := 0;
476: x_msg_data := NULL;
477:
478: -- Initialize the return status to success

Line 484: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.validate_rule',

480:
481: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
482:
483: IF l_debug_mode = 'Y' THEN
484: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PUB.validate_rule',
485: p_debug_mode => l_debug_mode );
486: END IF;
487:
488: IF l_debug_mode = 'Y' THEN

Line 516: END PA_PERF_RULES_PUB;

512: X_MSG_COUNT := l_MSG_COUNT ;
513: X_MSG_DATA := l_MSG_DATA ;
514:
515: END validate_rule;
516: END PA_PERF_RULES_PUB;