eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PERF_RULES_PVT dependencies on PA_DEBUG

Line 62: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.create_rule');

58: BEGIN
59:
60: savepoint sp;
61: -- Initialize the Error Stack
62: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.create_rule');
63: x_msg_count := 0;
64: x_msg_data := NULL;
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

Line 66: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

62: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.create_rule');
63: x_msg_count := 0;
64: x_msg_data := NULL;
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
67:
68: IF l_debug_mode = 'Y' THEN
69: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.create_rule',
70: p_debug_mode => l_debug_mode );

Line 69: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.create_rule',

65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
67:
68: IF l_debug_mode = 'Y' THEN
69: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.create_rule',
70: p_debug_mode => l_debug_mode );
71: END IF;
72:
73: IF l_debug_mode = 'Y' THEN

Line 74: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.create_rule';

70: p_debug_mode => l_debug_mode );
71: END IF;
72:
73: IF l_debug_mode = 'Y' THEN
74: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.create_rule';
75: pa_debug.write(g_module_name,pa_debug.g_err_stage,
76: l_debug_level3);
77: END IF;
78:

Line 75: pa_debug.write(g_module_name,pa_debug.g_err_stage,

71: END IF;
72:
73: IF l_debug_mode = 'Y' THEN
74: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.create_rule';
75: pa_debug.write(g_module_name,pa_debug.g_err_stage,
76: l_debug_level3);
77: END IF;
78:
79: IF l_debug_mode = 'Y' THEN

Line 80: pa_debug.g_err_stage:= 'about to check if the name is duplicate';

76: l_debug_level3);
77: END IF;
78:
79: IF l_debug_mode = 'Y' THEN
80: pa_debug.g_err_stage:= 'about to check if the name is duplicate';
81: pa_debug.write(g_module_name,pa_debug.g_err_stage,
82: l_debug_level3);
83: END IF;
84:

Line 81: pa_debug.write(g_module_name,pa_debug.g_err_stage,

77: END IF;
78:
79: IF l_debug_mode = 'Y' THEN
80: pa_debug.g_err_stage:= 'about to check if the name is duplicate';
81: pa_debug.write(g_module_name,pa_debug.g_err_stage,
82: l_debug_level3);
83: END IF;
84:
85: OPEN CHECK_RULE_NAME;

Line 118: pa_debug.g_err_stage:= 'Validating input parameters';

114:
115: -- Check for business rules violations
116:
117: IF l_debug_mode = 'Y' THEN
118: pa_debug.g_err_stage:= 'Validating input parameters';
119: pa_debug.write(g_module_name,pa_debug.g_err_stage,
120: l_debug_level3);
121: END IF;
122:

Line 119: pa_debug.write(g_module_name,pa_debug.g_err_stage,

115: -- Check for business rules violations
116:
117: IF l_debug_mode = 'Y' THEN
118: pa_debug.g_err_stage:= 'Validating input parameters';
119: pa_debug.write(g_module_name,pa_debug.g_err_stage,
120: l_debug_level3);
121: END IF;
122:
123:

Line 125: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.create_rule';

121: END IF;
122:
123:
124: IF l_debug_mode = 'Y' THEN
125: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.create_rule';
126: pa_debug.write(g_module_name,pa_debug.g_err_stage,
127: l_debug_level3);
128: pa_debug.reset_curr_function;
129: END IF;

Line 126: pa_debug.write(g_module_name,pa_debug.g_err_stage,

122:
123:
124: IF l_debug_mode = 'Y' THEN
125: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.create_rule';
126: pa_debug.write(g_module_name,pa_debug.g_err_stage,
127: l_debug_level3);
128: pa_debug.reset_curr_function;
129: END IF;
130:

Line 128: pa_debug.reset_curr_function;

124: IF l_debug_mode = 'Y' THEN
125: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.create_rule';
126: pa_debug.write(g_module_name,pa_debug.g_err_stage,
127: l_debug_level3);
128: pa_debug.reset_curr_function;
129: END IF;
130:
131: -- Reset the Error Stack
132: PA_DEBUG.reset_err_stack;

Line 132: PA_DEBUG.reset_err_stack;

128: pa_debug.reset_curr_function;
129: END IF;
130:
131: -- Reset the Error Stack
132: PA_DEBUG.reset_err_stack;
133:
134:
135: EXCEPTION
136: WHEN duplicate_name THEN

Line 147: pa_debug.reset_curr_function;

143:
144: x_msg_count := FND_MSG_PUB.count_msg;
145:
146: IF l_debug_mode = 'Y' THEN
147: pa_debug.reset_curr_function;
148: END IF;
149:
150: rollback to sp;
151: RETURN;

Line 164: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;

160: ,p_procedure_name => 'CREATE_RULE'
161: ,p_error_text => x_msg_data);
162:
163: IF l_debug_mode = 'Y' THEN
164: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
165: pa_debug.write(g_module_name,pa_debug.g_err_stage,
166: l_debug_level5);
167: pa_debug.reset_curr_function;
168: END IF;

Line 165: pa_debug.write(g_module_name,pa_debug.g_err_stage,

161: ,p_error_text => x_msg_data);
162:
163: IF l_debug_mode = 'Y' THEN
164: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
165: pa_debug.write(g_module_name,pa_debug.g_err_stage,
166: l_debug_level5);
167: pa_debug.reset_curr_function;
168: END IF;
169: RAISE;

Line 167: pa_debug.reset_curr_function;

163: IF l_debug_mode = 'Y' THEN
164: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
165: pa_debug.write(g_module_name,pa_debug.g_err_stage,
166: l_debug_level5);
167: pa_debug.reset_curr_function;
168: END IF;
169: RAISE;
170: END CREATE_RULE;
171:

Line 226: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.Update_Rule');

222: BEGIN
223:
224: savepoint sp;
225: -- Initialize the Error Stack
226: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.Update_Rule');
227: x_msg_count := 0;
228: x_msg_data := NULL;
229:
230: -- Initialize the return status to success

Line 232: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

228: x_msg_data := NULL;
229:
230: -- Initialize the return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
233: IF l_debug_mode = 'Y' THEN
234: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.update_rule',
235: p_debug_mode => l_debug_mode );
236: END IF;

Line 234: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.update_rule',

230: -- Initialize the return status to success
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
233: IF l_debug_mode = 'Y' THEN
234: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.update_rule',
235: p_debug_mode => l_debug_mode );
236: END IF;
237:
238: IF l_debug_mode = 'Y' THEN

Line 239: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.update_rule';

235: p_debug_mode => l_debug_mode );
236: END IF;
237:
238: IF l_debug_mode = 'Y' THEN
239: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.update_rule';
240: pa_debug.write(g_module_name,pa_debug.g_err_stage,
241: l_debug_level3);
242:
243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;

Line 240: pa_debug.write(g_module_name,pa_debug.g_err_stage,

236: END IF;
237:
238: IF l_debug_mode = 'Y' THEN
239: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.update_rule';
240: pa_debug.write(g_module_name,pa_debug.g_err_stage,
241: l_debug_level3);
242:
243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
244: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;

239: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.update_rule';
240: pa_debug.write(g_module_name,pa_debug.g_err_stage,
241: l_debug_level3);
242:
243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
244: pa_debug.write(g_module_name,pa_debug.g_err_stage,
245: l_debug_level5);
246:
247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;

Line 244: pa_debug.write(g_module_name,pa_debug.g_err_stage,

240: pa_debug.write(g_module_name,pa_debug.g_err_stage,
241: l_debug_level3);
242:
243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
244: pa_debug.write(g_module_name,pa_debug.g_err_stage,
245: l_debug_level5);
246:
247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;
248: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;

243: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
244: pa_debug.write(g_module_name,pa_debug.g_err_stage,
245: l_debug_level5);
246:
247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;
248: pa_debug.write(g_module_name,pa_debug.g_err_stage,
249: l_debug_level5);
250: pa_debug.g_err_stage:= 'P_RULE_NAME = '|| P_RULE_NAME;
251: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 248: pa_debug.write(g_module_name,pa_debug.g_err_stage,

244: pa_debug.write(g_module_name,pa_debug.g_err_stage,
245: l_debug_level5);
246:
247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;
248: pa_debug.write(g_module_name,pa_debug.g_err_stage,
249: l_debug_level5);
250: pa_debug.g_err_stage:= 'P_RULE_NAME = '|| P_RULE_NAME;
251: pa_debug.write(g_module_name,pa_debug.g_err_stage,
252: l_debug_level5);

Line 250: pa_debug.g_err_stage:= 'P_RULE_NAME = '|| P_RULE_NAME;

246:
247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;
248: pa_debug.write(g_module_name,pa_debug.g_err_stage,
249: l_debug_level5);
250: pa_debug.g_err_stage:= 'P_RULE_NAME = '|| P_RULE_NAME;
251: pa_debug.write(g_module_name,pa_debug.g_err_stage,
252: l_debug_level5);
253: END IF;
254:

Line 251: pa_debug.write(g_module_name,pa_debug.g_err_stage,

247: pa_debug.g_err_stage:= 'P_RULE_TYPE = '|| P_RULE_TYPE;
248: pa_debug.write(g_module_name,pa_debug.g_err_stage,
249: l_debug_level5);
250: pa_debug.g_err_stage:= 'P_RULE_NAME = '|| P_RULE_NAME;
251: pa_debug.write(g_module_name,pa_debug.g_err_stage,
252: l_debug_level5);
253: END IF;
254:
255: IF l_debug_mode = 'Y' THEN

Line 256: pa_debug.g_err_stage:= 'about to check if the name is duplicate';

252: l_debug_level5);
253: END IF;
254:
255: IF l_debug_mode = 'Y' THEN
256: pa_debug.g_err_stage:= 'about to check if the name is duplicate';
257: pa_debug.write(g_module_name,pa_debug.g_err_stage,
258: l_debug_level3);
259: END IF;
260:

Line 257: pa_debug.write(g_module_name,pa_debug.g_err_stage,

253: END IF;
254:
255: IF l_debug_mode = 'Y' THEN
256: pa_debug.g_err_stage:= 'about to check if the name is duplicate';
257: pa_debug.write(g_module_name,pa_debug.g_err_stage,
258: l_debug_level3);
259: END IF;
260:
261: OPEN CHECK_RULE_NAME;

Line 269: pa_debug.g_err_stage:= 'about to call lock row method';

265: END IF;
266: CLOSE CHECK_RULE_NAME;
267:
268: IF l_debug_mode = 'Y' THEN
269: pa_debug.g_err_stage:= 'about to call lock row method';
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level3);
272: END IF;
273:

Line 270: pa_debug.write(g_module_name,pa_debug.g_err_stage,

266: CLOSE CHECK_RULE_NAME;
267:
268: IF l_debug_mode = 'Y' THEN
269: pa_debug.g_err_stage:= 'about to call lock row method';
270: pa_debug.write(g_module_name,pa_debug.g_err_stage,
271: l_debug_level3);
272: END IF;
273:
274: PA_PERF_RULES_PKG.LOCK_ROW (

Line 279: pa_debug.g_err_stage:= 'lock row method called';

275: X_RULE_ID => P_RULE_ID,
276: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER );
277:
278: IF l_debug_mode = 'Y' THEN
279: pa_debug.g_err_stage:= 'lock row method called';
280: pa_debug.write(g_module_name,pa_debug.g_err_stage,
281: l_debug_level3);
282: END IF;
283:

Line 280: pa_debug.write(g_module_name,pa_debug.g_err_stage,

276: X_RECORD_VERSION_NUMBER => P_RECORD_VERSION_NUMBER );
277:
278: IF l_debug_mode = 'Y' THEN
279: pa_debug.g_err_stage:= 'lock row method called';
280: pa_debug.write(g_module_name,pa_debug.g_err_stage,
281: l_debug_level3);
282: END IF;
283:
284: l_msg_count := FND_MSG_PUB.count_msg;

Line 291: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.UPDATE_ROW';

287: Raise Invalid_Ret_Status;
288: end if;
289:
290: IF l_debug_mode = 'Y' THEN
291: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.UPDATE_ROW';
292: pa_debug.write(g_module_name,pa_debug.g_err_stage,
293: l_debug_level3);
294: END IF;
295:

Line 292: pa_debug.write(g_module_name,pa_debug.g_err_stage,

288: end if;
289:
290: IF l_debug_mode = 'Y' THEN
291: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.UPDATE_ROW';
292: pa_debug.write(g_module_name,pa_debug.g_err_stage,
293: l_debug_level3);
294: END IF;
295:
296: PA_PERF_RULES_PKG.UPDATE_ROW(

Line 316: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.update_rule';

312: X_LAST_UPDATED_BY => P_LAST_UPDATED_BY,
313: X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN );
314:
315: IF l_debug_mode = 'Y' THEN
316: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.update_rule';
317: pa_debug.write(g_module_name,pa_debug.g_err_stage,
318: l_debug_level3);
319: pa_debug.reset_curr_function;
320: END IF;

Line 317: pa_debug.write(g_module_name,pa_debug.g_err_stage,

313: X_LAST_UPDATE_LOGIN => P_LAST_UPDATE_LOGIN );
314:
315: IF l_debug_mode = 'Y' THEN
316: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.update_rule';
317: pa_debug.write(g_module_name,pa_debug.g_err_stage,
318: l_debug_level3);
319: pa_debug.reset_curr_function;
320: END IF;
321:

Line 319: pa_debug.reset_curr_function;

315: IF l_debug_mode = 'Y' THEN
316: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.update_rule';
317: pa_debug.write(g_module_name,pa_debug.g_err_stage,
318: l_debug_level3);
319: pa_debug.reset_curr_function;
320: END IF;
321:
322: -- Reset the Error Stack
323: PA_DEBUG.reset_err_stack;

Line 323: PA_DEBUG.reset_err_stack;

319: pa_debug.reset_curr_function;
320: END IF;
321:
322: -- Reset the Error Stack
323: PA_DEBUG.reset_err_stack;
324:
325: EXCEPTION
326:
327: WHEN duplicate_name THEN

Line 337: pa_debug.reset_curr_function;

333:
334: x_msg_count := FND_MSG_PUB.count_msg;
335:
336: IF l_debug_mode = 'Y' THEN
337: pa_debug.reset_curr_function;
338: END IF;
339:
340: rollback to sp;
341: RETURN;

Line 363: pa_debug.reset_curr_function;

359: x_msg_count := l_msg_count;
360: END IF;
361:
362: IF l_debug_mode = 'Y' THEN
363: pa_debug.reset_curr_function;
364: END IF;
365:
366: rollback to sp;
367: RETURN;

Line 375: , p_procedure_name => PA_DEBUG.G_Err_Stack

371: x_msg_data := substr(SQLERRM,1,240);
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MSG_PUB.add_exc_msg (
374: p_pkg_name => 'PA_PERF_RULES_PVT'
375: , p_procedure_name => PA_DEBUG.G_Err_Stack
376: , p_error_text => substr(SQLERRM,1,240));
377:
378: rollback to sp;
379: RAISE;

Line 428: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.Delete_Row');

424: savepoint sp;
425:
426:
427: -- Initialize the Error Stack
428: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.Delete_Row');
429: x_msg_count := 0;
430: x_msg_data := NULL;
431:
432: -- Initialize the return status to success

Line 436: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.delete_rule',

432: -- Initialize the return status to success
433: x_return_status := FND_API.G_RET_STS_SUCCESS;
434:
435: IF l_debug_mode = 'Y' THEN
436: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.delete_rule',
437: p_debug_mode => l_debug_mode );
438: END IF;
439:
440: IF l_debug_mode = 'Y' THEN

Line 441: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.delete_rule';

437: p_debug_mode => l_debug_mode );
438: END IF;
439:
440: IF l_debug_mode = 'Y' THEN
441: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.delete_rule';
442: pa_debug.write(g_module_name,pa_debug.g_err_stage,
443: l_debug_level3);
444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
445: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 442: pa_debug.write(g_module_name,pa_debug.g_err_stage,

438: END IF;
439:
440: IF l_debug_mode = 'Y' THEN
441: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.delete_rule';
442: pa_debug.write(g_module_name,pa_debug.g_err_stage,
443: l_debug_level3);
444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
445: pa_debug.write(g_module_name,pa_debug.g_err_stage,
446: l_debug_level5);

Line 444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;

440: IF l_debug_mode = 'Y' THEN
441: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.delete_rule';
442: pa_debug.write(g_module_name,pa_debug.g_err_stage,
443: l_debug_level3);
444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
445: pa_debug.write(g_module_name,pa_debug.g_err_stage,
446: l_debug_level5);
447:
448: pa_debug.g_err_stage:= 'about to call lock row method';

Line 445: pa_debug.write(g_module_name,pa_debug.g_err_stage,

441: pa_debug.g_err_stage:= 'Entered PA_PERF_RULES_PVT.delete_rule';
442: pa_debug.write(g_module_name,pa_debug.g_err_stage,
443: l_debug_level3);
444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
445: pa_debug.write(g_module_name,pa_debug.g_err_stage,
446: l_debug_level5);
447:
448: pa_debug.g_err_stage:= 'about to call lock row method';
449: pa_debug.write(g_module_name,pa_debug.g_err_stage,

Line 448: pa_debug.g_err_stage:= 'about to call lock row method';

444: pa_debug.g_err_stage:= 'P_RULE_ID = '|| P_RULE_ID;
445: pa_debug.write(g_module_name,pa_debug.g_err_stage,
446: l_debug_level5);
447:
448: pa_debug.g_err_stage:= 'about to call lock row method';
449: pa_debug.write(g_module_name,pa_debug.g_err_stage,
450: l_debug_level3);
451: END IF;
452:

Line 449: pa_debug.write(g_module_name,pa_debug.g_err_stage,

445: pa_debug.write(g_module_name,pa_debug.g_err_stage,
446: l_debug_level5);
447:
448: pa_debug.g_err_stage:= 'about to call lock row method';
449: pa_debug.write(g_module_name,pa_debug.g_err_stage,
450: l_debug_level3);
451: END IF;
452:
453: PA_PERF_RULES_PKG.LOCK_ROW

Line 465: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.delete_row';

461: Raise Invalid_Ret_Status;
462: end if;
463:
464: IF l_debug_mode = 'Y' THEN
465: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.delete_row';
466: pa_debug.write(g_module_name,pa_debug.g_err_stage,
467: l_debug_level3);
468: END IF;
469:

Line 466: pa_debug.write(g_module_name,pa_debug.g_err_stage,

462: end if;
463:
464: IF l_debug_mode = 'Y' THEN
465: pa_debug.g_err_stage:= 'about to call PA_PERF_RULES_PKG.delete_row';
466: pa_debug.write(g_module_name,pa_debug.g_err_stage,
467: l_debug_level3);
468: END IF;
469:
470:

Line 485: pa_debug.g_err_stage:= 'about to delete the Rule Threshold, Threshold_id : '|| cur_var.threshold_id;

481: X_MSG_DATA => l_msg_data );
482:
483: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
484: IF l_debug_mode = 'Y' THEN
485: pa_debug.g_err_stage:= 'about to delete the Rule Threshold, Threshold_id : '|| cur_var.threshold_id;
486: pa_debug.write(g_module_name,pa_debug.g_err_stage,
487: l_debug_level3);
488: END IF;
489: Raise Invalid_Ret_Status;

Line 486: pa_debug.write(g_module_name,pa_debug.g_err_stage,

482:
483: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
484: IF l_debug_mode = 'Y' THEN
485: pa_debug.g_err_stage:= 'about to delete the Rule Threshold, Threshold_id : '|| cur_var.threshold_id;
486: pa_debug.write(g_module_name,pa_debug.g_err_stage,
487: l_debug_level3);
488: END IF;
489: Raise Invalid_Ret_Status;
490: end if;

Line 509: pa_debug.g_err_stage:= 'about to delete the Rule Object Association, object_rule_id : '|| cur_var.object_rule_id;

505: X_RULE_NAME => l_rule_name );
506:
507: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
508: IF l_debug_mode = 'Y' THEN
509: pa_debug.g_err_stage:= 'about to delete the Rule Object Association, object_rule_id : '|| cur_var.object_rule_id;
510: pa_debug.write(g_module_name,pa_debug.g_err_stage,
511: l_debug_level3);
512: END IF;
513: Raise Invalid_Ret_Status;

Line 510: pa_debug.write(g_module_name,pa_debug.g_err_stage,

506:
507: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
508: IF l_debug_mode = 'Y' THEN
509: pa_debug.g_err_stage:= 'about to delete the Rule Object Association, object_rule_id : '|| cur_var.object_rule_id;
510: pa_debug.write(g_module_name,pa_debug.g_err_stage,
511: l_debug_level3);
512: END IF;
513: Raise Invalid_Ret_Status;
514: end if;

Line 523: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.delete_rule';

519: PA_PERF_RULES_PKG.DELETE_ROW
520: ( X_RULE_ID => P_RULE_ID);
521:
522: IF l_debug_mode = 'Y' THEN
523: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.delete_rule';
524: pa_debug.write(g_module_name,pa_debug.g_err_stage,
525: l_debug_level3);
526: pa_debug.reset_curr_function;
527: END IF;

Line 524: pa_debug.write(g_module_name,pa_debug.g_err_stage,

520: ( X_RULE_ID => P_RULE_ID);
521:
522: IF l_debug_mode = 'Y' THEN
523: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.delete_rule';
524: pa_debug.write(g_module_name,pa_debug.g_err_stage,
525: l_debug_level3);
526: pa_debug.reset_curr_function;
527: END IF;
528:

Line 526: pa_debug.reset_curr_function;

522: IF l_debug_mode = 'Y' THEN
523: pa_debug.g_err_stage:= 'Exiting PA_PERF_RULES_PVT.delete_rule';
524: pa_debug.write(g_module_name,pa_debug.g_err_stage,
525: l_debug_level3);
526: pa_debug.reset_curr_function;
527: END IF;
528:
529: -- Reset the Error Stack
530: PA_DEBUG.reset_err_stack;

Line 530: PA_DEBUG.reset_err_stack;

526: pa_debug.reset_curr_function;
527: END IF;
528:
529: -- Reset the Error Stack
530: PA_DEBUG.reset_err_stack;
531:
532: EXCEPTION
533: WHEN Invalid_Ret_Status THEN
534: x_return_status := FND_API.G_RET_STS_ERROR;

Line 553: pa_debug.reset_curr_function;

549: x_msg_count := l_msg_count;
550: END IF;
551:
552: IF l_debug_mode = 'Y' THEN
553: pa_debug.reset_curr_function;
554: END IF;
555:
556: rollback to sp;
557: RETURN;

Line 565: , p_procedure_name => PA_DEBUG.G_Err_Stack

561: x_msg_data := substr(SQLERRM,1,240);
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: FND_MSG_PUB.add_exc_msg
564: ( p_pkg_name => 'PA_PERF_RULES_PVT'
565: , p_procedure_name => PA_DEBUG.G_Err_Stack
566: , p_error_text => substr(SQLERRM,1,240));
567:
568: rollback to sp;
569: RAISE;

Line 608: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.validate_rule');

604: l_debug_mode VARCHAR2(1);
605: BEGIN
606:
607: -- Initialize the Error Stack
608: PA_DEBUG.init_err_stack('PA_PERF_RULES_PVT.validate_rule');
609: x_msg_count := 0;
610: x_msg_data := NULL;
611:
612: -- Initialize the return status to success

Line 615: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

611:
612: -- Initialize the return status to success
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
616:
617: IF l_debug_mode = 'Y' THEN
618: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.validate_rule',
619: p_debug_mode => l_debug_mode );

Line 618: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.validate_rule',

614:
615: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
616:
617: IF l_debug_mode = 'Y' THEN
618: pa_debug.set_curr_function( p_function => 'PA_PERF_RULES_PVT.validate_rule',
619: p_debug_mode => l_debug_mode );
620: END IF;
621:
622: k := P_THRESHOLD_ID.count; /* Get the number of lines */