DBA Data[Home] [Help]

APPS.PA_FP_REFRESH_ELEMENTS_PUB dependencies on PA_DEBUG

Line 3: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

1: PACKAGE BODY pa_fp_refresh_elements_pub AS
2: /* $Header: PAFPPERB.pls 120.3 2005/08/19 16:27:59 mwasowic noship $ */
3: p_pa_debug_mode VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4:
5: PROCEDURE fp_write_log_ss_or_conc(
6: p_calling_context IN VARCHAR2,
7: p_msg IN VARCHAR2,

Line 15: pa_debug.write( x_module => p_module,

11: /* p_calling_context - SS when called from OA pages and
12: CP when called from concurrent program */
13: BEGIN
14: IF p_calling_context = 'SS' THEN
15: pa_debug.write( x_module => p_module,
16: x_msg => p_msg,
17: x_log_level => p_log_level);
18: ELSIF p_calling_context = 'CP' THEN
19: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 19: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

15: pa_debug.write( x_module => p_module,
16: x_msg => p_msg,
17: x_log_level => p_log_level);
18: ELSIF p_calling_context = 'CP' THEN
19: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
20: END IF;
21: END fp_write_log_ss_or_conc;
22:
23: /* This API updates the budget version and proj fp options table

Line 150: IF P_PA_DEBUG_MODE = 'Y' THEN

146: ELSE
147: l_calling_context := 'SS';
148: END IF;
149:
150: IF P_PA_DEBUG_MODE = 'Y' THEN
151: pa_debug.set_err_stack(l_module);
152: pa_debug.set_process('refresh_planning_elements: ' || 'PLSQL','LOG',p_pa_debug_mode);
153: END IF;
154:

Line 151: pa_debug.set_err_stack(l_module);

147: l_calling_context := 'SS';
148: END IF;
149:
150: IF P_PA_DEBUG_MODE = 'Y' THEN
151: pa_debug.set_err_stack(l_module);
152: pa_debug.set_process('refresh_planning_elements: ' || 'PLSQL','LOG',p_pa_debug_mode);
153: END IF;
154:
155: IF p_pa_debug_mode = 'Y' THEN

Line 152: pa_debug.set_process('refresh_planning_elements: ' || 'PLSQL','LOG',p_pa_debug_mode);

148: END IF;
149:
150: IF P_PA_DEBUG_MODE = 'Y' THEN
151: pa_debug.set_err_stack(l_module);
152: pa_debug.set_process('refresh_planning_elements: ' || 'PLSQL','LOG',p_pa_debug_mode);
153: END IF;
154:
155: IF p_pa_debug_mode = 'Y' THEN
156: l_msg := 'Project Id:'||to_char(p_project_id) ||' Req Id :'||to_char(p_request_id);

Line 155: IF p_pa_debug_mode = 'Y' THEN

151: pa_debug.set_err_stack(l_module);
152: pa_debug.set_process('refresh_planning_elements: ' || 'PLSQL','LOG',p_pa_debug_mode);
153: END IF;
154:
155: IF p_pa_debug_mode = 'Y' THEN
156: l_msg := 'Project Id:'||to_char(p_project_id) ||' Req Id :'||to_char(p_request_id);
157: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
158: p_calling_context => l_calling_context,
159: p_msg => l_msg,

Line 233: IF p_pa_debug_mode = 'Y' THEN

229: l_dummy := 1;
230: END;
231:
232: IF l_fp_opt_tbl.COUNT = 0 THEN
233: IF p_pa_debug_mode = 'Y' THEN
234: l_msg := 'l_fp_opt_tbl count is zero. Returning ';
235: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
236: p_calling_context => l_calling_context,
237: p_msg => l_msg,

Line 260: IF p_pa_debug_mode = 'Y' THEN

256: project_id = p_project_id
257: ORDER BY PA_PROJ_ELEMENTS_UTILS.GET_DISPLAY_SEQUENCE(task_id);
258:
259: IF l_task_id_tab.COUNT = 0 THEN
260: IF p_pa_debug_mode = 'Y' THEN
261: l_msg := 'task tbl count is zero. Returning ';
262: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
263: p_calling_context => l_calling_context,
264: p_msg => l_msg,

Line 278: IF p_pa_debug_mode = 'Y' THEN

274: l_impacted_tasks_rec(task_idx).top_task_id := l_top_task_id_tab(task_idx);
275: l_impacted_tasks_rec(task_idx).task_level := l_task_level_tab(task_idx);
276: END LOOP;
277:
278: IF p_pa_debug_mode = 'Y' THEN
279: l_msg := 'before calling PA_FP_ELEMENTS_PUB.make_new_tasks_plannable';
280: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
281: p_calling_context => l_calling_context,
282: p_msg => l_msg,

Line 299: IF p_pa_debug_mode = 'Y' THEN

295: /* the return status should be retained to pass the value
296: back to the calling API. */
297: l_ret_status := x_return_status;
298:
299: IF p_pa_debug_mode = 'Y' THEN
300: l_msg := 'after calling PA_FP_ELEMENTS_PUB.make_new_tasks_plannable'
301: || 'ret status:'||x_return_status;
302: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
303: p_calling_context => l_calling_context,

Line 312: IF p_pa_debug_mode = 'Y' THEN

308:
309: IF p_request_id IS NULL OR
310: ( p_request_id IS NOT NULL AND
311: x_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
312: IF p_pa_debug_mode = 'Y' THEN
313: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status';
314: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
315: p_calling_context => l_calling_context,
316: p_msg => l_msg,

Line 331: IF p_pa_debug_mode = 'Y' THEN

327: x_msg_count => x_msg_count,
328: x_msg_data => x_msg_data );
329: ELSIF p_request_id IS NOT NULL AND
330: x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
331: IF p_pa_debug_mode = 'Y' THEN
332: l_msg := 'calling pa_fp_refresh_elements_pub.update_process_status_auto';
333: pa_fp_refresh_elements_pub.fp_write_log_ss_or_conc(
334: p_calling_context => l_calling_context,
335: p_msg => l_msg,

Line 352: IF p_pa_debug_mode = 'Y' THEN

348: END IF;
349: /* setting the return status from PA_FP_ELEMENTS_PUB.make_new_tasks_plannable */
350: x_return_status := l_ret_status;
351:
352: IF p_pa_debug_mode = 'Y' THEN
353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: EXCEPTION
356: WHEN OTHERS THEN

Line 353: PA_DEBUG.Reset_Err_stack;

349: /* setting the return status from PA_FP_ELEMENTS_PUB.make_new_tasks_plannable */
350: x_return_status := l_ret_status;
351:
352: IF p_pa_debug_mode = 'Y' THEN
353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: EXCEPTION
356: WHEN OTHERS THEN
357: IF p_pa_debug_mode = 'Y' THEN

Line 357: IF p_pa_debug_mode = 'Y' THEN

353: PA_DEBUG.Reset_Err_stack;
354: END IF;
355: EXCEPTION
356: WHEN OTHERS THEN
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_DEBUG.Reset_Err_stack;
359: END IF;
360: IF p_request_id IS NOT NULL THEN
361: x_return_status_in := x_return_status;

Line 358: PA_DEBUG.Reset_Err_stack;

354: END IF;
355: EXCEPTION
356: WHEN OTHERS THEN
357: IF p_pa_debug_mode = 'Y' THEN
358: PA_DEBUG.Reset_Err_stack;
359: END IF;
360: IF p_request_id IS NOT NULL THEN
361: x_return_status_in := x_return_status;
362: pa_fp_refresh_elements_pub.update_process_status_auto(