DBA Data[Home] [Help]

APPS.PA_PERF_THRESHOLDS_PUB dependencies on PA_PERF_THRESHOLDS_PUB

Line 1: PACKAGE BODY PA_PERF_THRESHOLDS_PUB AS

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

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

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

Line 49: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.create_rule_det');

45:
46: BEGIN
47:
48: -- Initialize the Error Stack
49: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.create_rule_det');
50: x_msg_count := 0;
51: x_msg_data := NULL;
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 56: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.create_rule_det',

52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
54:
55: IF l_debug_mode = 'Y' THEN
56: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.create_rule_det',
57: p_debug_mode => l_debug_mode );
58: END IF;
59:
60: IF l_debug_mode = 'Y' THEN

Line 61: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.create_rule_det';

57: p_debug_mode => l_debug_mode );
58: END IF;
59:
60: IF l_debug_mode = 'Y' THEN
61: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.create_rule_det';
62: pa_debug.write(g_module_name,pa_debug.g_err_stage,
63: l_debug_level3);
64: END IF;
65:

Line 94: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.create_rule_det';

90: end if;
91:
92:
93: IF l_debug_mode = 'Y' THEN
94: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.create_rule_det';
95: pa_debug.write(g_module_name,pa_debug.g_err_stage,
96: l_debug_level3);
97: pa_debug.reset_curr_function;
98: END IF;

Line 137: p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'

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

Line 192: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Update_Rule_Det');

188: BEGIN
189:
190: savepoint sp;
191: -- Initialize the Error Stack
192: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Update_Rule_Det');
193: x_msg_count := 0;
194: x_msg_data := NULL;
195:
196: -- Initialize the return status to success

Line 200: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.update_rule_det',

196: -- Initialize the return status to success
197: x_return_status := FND_API.G_RET_STS_SUCCESS;
198: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
199: IF l_debug_mode = 'Y' THEN
200: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.update_rule_det',
201: p_debug_mode => l_debug_mode );
202: END IF;
203:
204: IF l_debug_mode = 'Y' THEN

Line 205: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.update_rule';

201: p_debug_mode => l_debug_mode );
202: END IF;
203:
204: IF l_debug_mode = 'Y' THEN
205: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.update_rule';
206: pa_debug.write(g_module_name,pa_debug.g_err_stage,
207: l_debug_level3);
208:
209: pa_debug.g_err_stage:= 'P_THRESHOLD_ID = '|| P_THRESHOLD_ID;

Line 248: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.update_rule_det';

244: Raise Invalid_Ret_Status;
245: end if;
246:
247: IF l_debug_mode = 'Y' THEN
248: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.update_rule_det';
249: pa_debug.write(g_module_name,pa_debug.g_err_stage,
250: l_debug_level3);
251: pa_debug.reset_curr_function;
252: END IF;

Line 289: p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'

285: x_msg_count := 1;
286: x_msg_data := substr(SQLERRM,1,240);
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.add_exc_msg (
289: p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'
290: , p_procedure_name => PA_DEBUG.G_Err_Stack
291: , p_error_text => substr(SQLERRM,1,240));
292:
293: rollback to sp;

Line 330: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Delete_Rule_Det');

326: savepoint sp;
327:
328:
329: -- Initialize the Error Stack
330: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PUB.Delete_Rule_Det');
331: x_msg_count := 0;
332: x_msg_data := NULL;
333:
334: -- Initialize the return status to success

Line 338: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.delete_rule_det',

334: -- Initialize the return status to success
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: IF l_debug_mode = 'Y' THEN
338: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PUB.delete_rule_det',
339: p_debug_mode => l_debug_mode );
340: END IF;
341:
342: IF l_debug_mode = 'Y' THEN

Line 343: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.delete_rule_det';

339: p_debug_mode => l_debug_mode );
340: END IF;
341:
342: IF l_debug_mode = 'Y' THEN
343: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PUB.delete_rule_det';
344: pa_debug.write(g_module_name,pa_debug.g_err_stage,
345: l_debug_level3);
346: pa_debug.g_err_stage:= 'P_THRESHOLD_ID = '|| P_THRESHOLD_ID;
347: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 371: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.delete_rule_det';

367: Raise Invalid_Ret_Status;
368: end if;
369:
370: IF l_debug_mode = 'Y' THEN
371: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PUB.delete_rule_det';
372: pa_debug.write(g_module_name,pa_debug.g_err_stage,
373: l_debug_level3);
374: pa_debug.reset_curr_function;
375: END IF;

Line 412: ( p_pkg_name => 'PA_PERF_THRESHOLDS_PUB'

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

Line 423: END PA_PERF_THRESHOLDS_PUB;

419: END delete_rule_det;
420:
421:
422:
423: END PA_PERF_THRESHOLDS_PUB;