DBA Data[Home] [Help]

APPS.PA_PERF_OBJECT_RULES_PVT dependencies on PA_PERF_OBJECT_RULES_PVT

Line 1: PACKAGE BODY PA_PERF_OBJECT_RULES_PVT AS

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

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

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

Line 44: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.create_rule_object');

40:
41: BEGIN
42:
43: -- Initialize the Error Stack
44: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.create_rule_object');
45: x_msg_count := 0;
46: x_msg_data := NULL;
47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 51: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.create_rule_object',

47: x_return_status := FND_API.G_RET_STS_SUCCESS;
48: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
49:
50: IF l_debug_mode = 'Y' THEN
51: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.create_rule_object',
52: p_debug_mode => l_debug_mode );
53: END IF;
54:
55: IF l_debug_mode = 'Y' THEN

Line 56: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.create_rule_object';

52: p_debug_mode => l_debug_mode );
53: END IF;
54:
55: IF l_debug_mode = 'Y' THEN
56: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.create_rule_object';
57: pa_debug.write(g_module_name,pa_debug.g_err_stage,
58: l_debug_level3);
59: END IF;
60:

Line 146: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.create_rule_object';

142:
143: -- Check for business rules violations
144:
145: IF l_debug_mode = 'Y' THEN
146: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.create_rule_object';
147: pa_debug.write(g_module_name,pa_debug.g_err_stage,
148: l_debug_level3);
149: pa_debug.reset_curr_function;
150: END IF;

Line 163: p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'

159: x_msg_count := 1;
160: x_msg_data := SQLERRM;
161:
162: FND_MSG_PUB.add_exc_msg(
163: p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'
164: ,p_procedure_name => 'CREATE_RULE_OBJECT'
165: ,p_error_text => x_msg_data);
166:
167: IF l_debug_mode = 'Y' THEN

Line 214: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.update_rule_object');

210: BEGIN
211:
212: savepoint sp;
213: -- Initialize the Error Stack
214: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.update_rule_object');
215: x_msg_count := 0;
216: x_msg_data := NULL;
217:
218: -- Initialize the return status to success

Line 222: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.update_rule_object',

218: -- Initialize the return status to success
219: x_return_status := FND_API.G_RET_STS_SUCCESS;
220: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
221: IF l_debug_mode = 'Y' THEN
222: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.update_rule_object',
223: p_debug_mode => l_debug_mode );
224: END IF;
225:
226: IF l_debug_mode = 'Y' THEN

Line 227: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.update_rule_object';

223: p_debug_mode => l_debug_mode );
224: END IF;
225:
226: IF l_debug_mode = 'Y' THEN
227: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.update_rule_object';
228: pa_debug.write(g_module_name,pa_debug.g_err_stage,
229: l_debug_level3);
230:
231: pa_debug.g_err_stage:= 'P_OBJECT_RULE_ID = '|| P_OBJECT_RULE_ID;

Line 285: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.update_rule_object';

281: X_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
282: X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN );
283:
284: IF l_debug_mode = 'Y' THEN
285: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.update_rule_object';
286: pa_debug.write(g_module_name,pa_debug.g_err_stage,
287: l_debug_level3);
288: pa_debug.reset_curr_function;
289: END IF;

Line 326: p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'

322: x_msg_count := 1;
323: x_msg_data := substr(SQLERRM,1,240);
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: FND_MSG_PUB.add_exc_msg (
326: p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'
327: , p_procedure_name => PA_DEBUG.G_Err_Stack
328: , p_error_text => substr(SQLERRM,1,240));
329:
330: rollback to sp;

Line 367: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object');

363: savepoint sp;
364:
365:
366: -- Initialize the Error Stack
367: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object');
368: x_msg_count := 0;
369: x_msg_data := NULL;
370:
371: -- Initialize the return status to success

Line 375: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object',

371: -- Initialize the return status to success
372: x_return_status := FND_API.G_RET_STS_SUCCESS;
373:
374: IF l_debug_mode = 'Y' THEN
375: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object',
376: p_debug_mode => l_debug_mode );
377: END IF;
378:
379: IF l_debug_mode = 'Y' THEN

Line 380: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object';

376: p_debug_mode => l_debug_mode );
377: END IF;
378:
379: IF l_debug_mode = 'Y' THEN
380: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object';
381: pa_debug.write(g_module_name,pa_debug.g_err_stage,
382: l_debug_level3);
383: pa_debug.g_err_stage:= 'P_OBJECT_RULE_ID = '|| P_OBJECT_RULE_ID;
384: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 426: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object';

422: PA_PERF_OBJECT_RULES_PKG.DELETE_ROW
423: (X_OBJECT_RULE_ID => P_OBJECT_RULE_ID);
424:
425: IF l_debug_mode = 'Y' THEN
426: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PVT.Delete_Rule_object';
427: pa_debug.write(g_module_name,pa_debug.g_err_stage,
428: l_debug_level3);
429: pa_debug.reset_curr_function;
430: END IF;

Line 467: ( p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'

463: x_msg_count := 1;
464: x_msg_data := substr(SQLERRM,1,240);
465: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
466: FND_MSG_PUB.add_exc_msg
467: ( p_pkg_name => 'PA_PERF_OBJECT_RULES_PVT'
468: , p_procedure_name => PA_DEBUG.G_Err_Stack
469: , p_error_text => substr(SQLERRM,1,240));
470:
471: rollback to sp;

Line 634: END PA_PERF_OBJECT_RULES_PVT;

630: WHERE RECORD_VERSION_NUMBER =2;
631:
632: END VALIDATE_RULE_OBJECT;
633:
634: END PA_PERF_OBJECT_RULES_PVT;