DBA Data[Home] [Help]

APPS.PA_PERF_THRESHOLDS_PVT dependencies on PA_PERF_THRESHOLDS_PVT

Line 1: PACKAGE BODY pa_perf_thresholds_pvt AS

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

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

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

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

45:
46: BEGIN
47:
48: -- Initialize the Error Stack
49: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.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_PVT.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_PVT.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_PVT.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_PVT.create_rule_det';
62: pa_debug.write(g_module_name,pa_debug.g_err_stage,
63: l_debug_level3);
64: END IF;
65:

Line 89: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.create_rule_det';

85:
86: -- Check for business rules violations
87:
88: IF l_debug_mode = 'Y' THEN
89: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.create_rule_det';
90: pa_debug.write(g_module_name,pa_debug.g_err_stage,
91: l_debug_level3);
92: pa_debug.reset_curr_function;
93: END IF;

Line 106: p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'

102: x_msg_count := 1;
103: x_msg_data := SQLERRM;
104:
105: FND_MSG_PUB.add_exc_msg(
106: p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'
107: ,p_procedure_name => 'CREATE_RULE_DET'
108: ,p_error_text => x_msg_data);
109:
110: IF l_debug_mode = 'Y' THEN

Line 160: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Update_Rule_Det');

156: BEGIN
157:
158: savepoint sp;
159: -- Initialize the Error Stack
160: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Update_Rule_Det');
161: x_msg_count := 0;
162: x_msg_data := NULL;
163:
164: -- Initialize the return status to success

Line 168: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PVT.update_rule_det',

164: -- Initialize the return status to success
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
167: IF l_debug_mode = 'Y' THEN
168: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PVT.update_rule_det',
169: p_debug_mode => l_debug_mode );
170: END IF;
171:
172: IF l_debug_mode = 'Y' THEN

Line 173: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PVT.update_rule_det';

169: p_debug_mode => l_debug_mode );
170: END IF;
171:
172: IF l_debug_mode = 'Y' THEN
173: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PVT.update_rule_det';
174: pa_debug.write(g_module_name,pa_debug.g_err_stage,
175: l_debug_level3);
176:
177: pa_debug.g_err_stage:= 'P_THRESHOLD_ID = '|| P_THRESHOLD_ID;

Line 230: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.update_rule_det';

226: X_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
227: X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN );
228:
229: IF l_debug_mode = 'Y' THEN
230: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.update_rule_det';
231: pa_debug.write(g_module_name,pa_debug.g_err_stage,
232: l_debug_level3);
233: pa_debug.reset_curr_function;
234: END IF;

Line 271: p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'

267: x_msg_count := 1;
268: x_msg_data := substr(SQLERRM,1,240);
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: FND_MSG_PUB.add_exc_msg (
271: p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'
272: , p_procedure_name => PA_DEBUG.G_Err_Stack
273: , p_error_text => substr(SQLERRM,1,240));
274:
275: rollback to sp;

Line 311: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Delete_Rule_Det');

307: savepoint sp;
308:
309:
310: -- Initialize the Error Stack
311: PA_DEBUG.init_err_stack('PA_PERF_THRESHOLDS_PVT.Delete_Rule_Det');
312: x_msg_count := 0;
313: x_msg_data := NULL;
314:
315: -- Initialize the return status to success

Line 319: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PVT.delete_rule_det',

315: -- Initialize the return status to success
316: x_return_status := FND_API.G_RET_STS_SUCCESS;
317:
318: IF l_debug_mode = 'Y' THEN
319: pa_debug.set_curr_function( p_function => 'PA_PERF_THRESHOLDS_PVT.delete_rule_det',
320: p_debug_mode => l_debug_mode );
321: END IF;
322:
323: IF l_debug_mode = 'Y' THEN

Line 324: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PVT.delete_rule_det';

320: p_debug_mode => l_debug_mode );
321: END IF;
322:
323: IF l_debug_mode = 'Y' THEN
324: pa_debug.g_err_stage:= 'Entered PA_PERF_THRESHOLDS_PVT.delete_rule_det';
325: pa_debug.write(g_module_name,pa_debug.g_err_stage,
326: l_debug_level3);
327: pa_debug.g_err_stage:= 'P_THRESHOLD_ID = '|| P_THRESHOLD_ID;
328: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 358: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.delete_rule_det';

354: PA_PERF_THRESHOLDS_PKG.DELETE_ROW
355: (X_THRESHOLD_ID => P_THRESHOLD_ID);
356:
357: IF l_debug_mode = 'Y' THEN
358: pa_debug.g_err_stage:= 'Exiting PA_PERF_THRESHOLDS_PVT.delete_rule_det';
359: pa_debug.write(g_module_name,pa_debug.g_err_stage,
360: l_debug_level3);
361: pa_debug.reset_curr_function;
362: END IF;

Line 399: ( p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'

395: x_msg_count := 1;
396: x_msg_data := substr(SQLERRM,1,240);
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.add_exc_msg
399: ( p_pkg_name => 'PA_PERF_THRESHOLDS_PVT'
400: , p_procedure_name => PA_DEBUG.G_Err_Stack
401: , p_error_text => substr(SQLERRM,1,240));
402:
403: rollback to sp;

Line 410: END PA_PERF_THRESHOLDS_PVT;

406: END delete_rule_det;
407:
408:
409:
410: END PA_PERF_THRESHOLDS_PVT;