DBA Data[Home] [Help]

APPS.PA_PERF_OBJECT_RULES_PUB dependencies on PA_PERF_OBJECT_RULES_PUB

Line 1: PACKAGE BODY PA_PERF_OBJECT_RULES_PUB AS

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

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

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

Line 46: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.create_rule_object');

42: -- set the savepoint
43: savepoint sp;
44: FND_MSG_PUB.initialize;
45: -- Initialize the Error Stack
46: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.create_rule_object');
47: x_msg_count := 0;
48: x_msg_data := NULL;
49: x_return_status := FND_API.G_RET_STS_SUCCESS;
50: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 53: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PUB.create_rule_object',

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

Line 58: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.create_rule_object';

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

Line 93: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.create_rule_object';

89: end if; */
90:
91:
92: IF l_debug_mode = 'Y' THEN
93: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.create_rule_object';
94: pa_debug.write(g_module_name,pa_debug.g_err_stage,
95: l_debug_level3);
96: pa_debug.reset_curr_function;
97: END IF;

Line 136: p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'

132: x_msg_count := 1;
133: x_msg_data := SQLERRM;
134:
135: FND_MSG_PUB.add_exc_msg(
136: p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'
137: ,p_procedure_name => 'CREATE_RULE_OBJECT'
138: ,p_error_text => x_msg_data);
139:
140: IF l_debug_mode = 'Y' THEN

Line 189: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.update_rule_object');

185: -- set the savepoint
186: savepoint sp;
187: FND_MSG_PUB.initialize;
188: -- Initialize the Error Stack
189: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.update_rule_object');
190: x_msg_count := 0;
191: x_msg_data := NULL;
192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 196: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PUB.update_rule_object',

192: x_return_status := FND_API.G_RET_STS_SUCCESS;
193: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
194:
195: IF l_debug_mode = 'Y' THEN
196: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PUB.update_rule_object',
197: p_debug_mode => l_debug_mode );
198: END IF;
199:
200: IF l_debug_mode = 'Y' THEN

Line 201: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.update_rule_object';

197: p_debug_mode => l_debug_mode );
198: END IF;
199:
200: IF l_debug_mode = 'Y' THEN
201: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.update_rule_object';
202: pa_debug.write(g_module_name,pa_debug.g_err_stage,
203: l_debug_level3);
204: END IF;
205:

Line 236: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.update_rule_object';

232: end if; */
233:
234:
235: IF l_debug_mode = 'Y' THEN
236: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.update_rule_object';
237: pa_debug.write(g_module_name,pa_debug.g_err_stage,
238: l_debug_level3);
239: pa_debug.reset_curr_function;
240: END IF;

Line 279: p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'

275: x_msg_count := 1;
276: x_msg_data := SQLERRM;
277:
278: FND_MSG_PUB.add_exc_msg(
279: p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'
280: ,p_procedure_name => 'UPDATE_RULE_OBJECT'
281: ,p_error_text => x_msg_data);
282:
283: IF l_debug_mode = 'Y' THEN

Line 326: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.delete_rule_object');

322:
323:
324: FND_MSG_PUB.initialize;
325: -- Initialize the Error Stack
326: PA_DEBUG.init_err_stack('PA_PERF_OBJECT_RULES_PUB.delete_rule_object');
327: x_msg_count := 0;
328: x_msg_data := NULL;
329:
330: -- Initialize the return status to success

Line 334: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PUB.delete_rule_object',

330: -- Initialize the return status to success
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333: IF l_debug_mode = 'Y' THEN
334: pa_debug.set_curr_function( p_function => 'PA_PERF_OBJECT_RULES_PUB.delete_rule_object',
335: p_debug_mode => l_debug_mode );
336: END IF;
337:
338: IF l_debug_mode = 'Y' THEN

Line 339: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.delete_rule_object';

335: p_debug_mode => l_debug_mode );
336: END IF;
337:
338: IF l_debug_mode = 'Y' THEN
339: pa_debug.g_err_stage:= 'Entered PA_PERF_OBJECT_RULES_PUB.delete_rule_object';
340: pa_debug.write(g_module_name,pa_debug.g_err_stage,
341: l_debug_level3);
342: pa_debug.g_err_stage:= 'P_OBJECT_RULE_ID = '|| P_OBJECT_RULE_ID;
343: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 368: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.delete_rule_object';

364: Raise Invalid_Ret_Status;
365: end if;
366:
367: IF l_debug_mode = 'Y' THEN
368: pa_debug.g_err_stage:= 'Exiting PA_PERF_OBJECT_RULES_PUB.delete_rule_object';
369: pa_debug.write(g_module_name,pa_debug.g_err_stage,
370: l_debug_level3);
371: pa_debug.reset_curr_function;
372: END IF;

Line 409: ( p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'

405: x_msg_count := 1;
406: x_msg_data := substr(SQLERRM,1,240);
407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
408: FND_MSG_PUB.add_exc_msg
409: ( p_pkg_name => 'PA_PERF_OBJECT_RULES_PUB'
410: , p_procedure_name => PA_DEBUG.G_Err_Stack
411: , p_error_text => substr(SQLERRM,1,240));
412:
413: rollback to sp;

Line 448: END PA_PERF_OBJECT_RULES_PUB;

444: X_MSG_DATA => X_MSG_DATA );
445:
446: END VALIDATE_RULE_OBJECT;
447:
448: END PA_PERF_OBJECT_RULES_PUB;