DBA Data[Home] [Help]

APPS.PA_PERF_OBJECT_RULES_PUB dependencies on PA_DEBUG

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 50: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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');
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 );

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 59: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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:
63:

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 94: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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;
98:

Line 96: pa_debug.reset_curr_function;

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;
98:
99: -- Reset the Error Stack
100: PA_DEBUG.reset_err_stack;

Line 100: PA_DEBUG.reset_err_stack;

96: pa_debug.reset_curr_function;
97: END IF;
98:
99: -- Reset the Error Stack
100: PA_DEBUG.reset_err_stack;
101:
102:
103: EXCEPTION
104: WHEN Invalid_Ret_Status THEN

Line 124: pa_debug.reset_curr_function;

120: x_msg_count := l_msg_count;
121: END IF;
122:
123: IF l_debug_mode = 'Y' THEN
124: pa_debug.reset_curr_function;
125: END IF;
126:
127: rollback to sp;
128: RETURN;

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

137: ,p_procedure_name => 'CREATE_RULE_OBJECT'
138: ,p_error_text => x_msg_data);
139:
140: IF l_debug_mode = 'Y' THEN
141: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
142: pa_debug.write(g_module_name,pa_debug.g_err_stage,
143: l_debug_level5);
144: pa_debug.reset_curr_function;
145: END IF;

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

138: ,p_error_text => x_msg_data);
139:
140: IF l_debug_mode = 'Y' THEN
141: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
142: pa_debug.write(g_module_name,pa_debug.g_err_stage,
143: l_debug_level5);
144: pa_debug.reset_curr_function;
145: END IF;
146: RAISE;

Line 144: pa_debug.reset_curr_function;

140: IF l_debug_mode = 'Y' THEN
141: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
142: pa_debug.write(g_module_name,pa_debug.g_err_stage,
143: l_debug_level5);
144: pa_debug.reset_curr_function;
145: END IF;
146: RAISE;
147: END create_rule_object;
148:

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 193: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');

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');
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 );

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 202: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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:
206:

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 237: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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;
241:

Line 239: pa_debug.reset_curr_function;

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;
241:
242: -- Reset the Error Stack
243: PA_DEBUG.reset_err_stack;

Line 243: PA_DEBUG.reset_err_stack;

239: pa_debug.reset_curr_function;
240: END IF;
241:
242: -- Reset the Error Stack
243: PA_DEBUG.reset_err_stack;
244:
245:
246: EXCEPTION
247: WHEN Invalid_Ret_Status THEN

Line 267: pa_debug.reset_curr_function;

263: x_msg_count := l_msg_count;
264: END IF;
265:
266: IF l_debug_mode = 'Y' THEN
267: pa_debug.reset_curr_function;
268: END IF;
269:
270: rollback to sp;
271: RETURN;

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

280: ,p_procedure_name => 'UPDATE_RULE_OBJECT'
281: ,p_error_text => x_msg_data);
282:
283: IF l_debug_mode = 'Y' THEN
284: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
285: pa_debug.write(g_module_name,pa_debug.g_err_stage,
286: l_debug_level5);
287: pa_debug.reset_curr_function;
288: END IF;

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

281: ,p_error_text => x_msg_data);
282:
283: IF l_debug_mode = 'Y' THEN
284: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
285: pa_debug.write(g_module_name,pa_debug.g_err_stage,
286: l_debug_level5);
287: pa_debug.reset_curr_function;
288: END IF;
289: RAISE;

Line 287: pa_debug.reset_curr_function;

283: IF l_debug_mode = 'Y' THEN
284: pa_debug.g_err_stage:= 'Unexpected Error: '||x_msg_data;
285: pa_debug.write(g_module_name,pa_debug.g_err_stage,
286: l_debug_level5);
287: pa_debug.reset_curr_function;
288: END IF;
289: RAISE;
290: END update_rule_object;
291:

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 340: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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,
344: l_debug_level5);

Line 342: pa_debug.g_err_stage:= 'P_OBJECT_RULE_ID = '|| P_OBJECT_RULE_ID;

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,
344: l_debug_level5);
345: END IF;
346:

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

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,
344: l_debug_level5);
345: END IF;
346:
347:

Line 349: pa_debug.g_err_stage:= 'about to call PA_PERF_OBJECT_RULES_PVT.delete_rule_object';

345: END IF;
346:
347:
348: IF l_debug_mode = 'Y' THEN
349: pa_debug.g_err_stage:= 'about to call PA_PERF_OBJECT_RULES_PVT.delete_rule_object';
350: pa_debug.write(g_module_name,pa_debug.g_err_stage,
351: l_debug_level3);
352: END IF;
353:

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

346:
347:
348: IF l_debug_mode = 'Y' THEN
349: pa_debug.g_err_stage:= 'about to call PA_PERF_OBJECT_RULES_PVT.delete_rule_object';
350: pa_debug.write(g_module_name,pa_debug.g_err_stage,
351: l_debug_level3);
352: END IF;
353:
354: -- Delete Role

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 369: pa_debug.write(g_module_name,pa_debug.g_err_stage,

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;
373:

Line 371: pa_debug.reset_curr_function;

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;
373:
374: -- Reset the Error Stack
375: PA_DEBUG.reset_err_stack;

Line 375: PA_DEBUG.reset_err_stack;

371: pa_debug.reset_curr_function;
372: END IF;
373:
374: -- Reset the Error Stack
375: PA_DEBUG.reset_err_stack;
376:
377: EXCEPTION
378: WHEN Invalid_Ret_Status THEN
379: x_return_status := FND_API.G_RET_STS_ERROR;

Line 398: pa_debug.reset_curr_function;

394: x_msg_count := l_msg_count;
395: END IF;
396:
397: IF l_debug_mode = 'Y' THEN
398: pa_debug.reset_curr_function;
399: END IF;
400:
401: rollback to sp;
402: RETURN;

Line 410: , p_procedure_name => PA_DEBUG.G_Err_Stack

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;
414: RAISE;