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_FIN_PLAN_TYPE_GLOBAL dependencies on PA_DEBUG

Line 11: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

7: NOTE :
8: End of Comments
9: */
10:
11: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
12:
13: function Get_Project_Id return NUMBER is
14: BEGIN
15: return pa_fin_plan_type_global.G_PROJECT_ID;

Line 286: IF P_PA_DEBUG_MODE = 'Y' THEN

282: l_return_status VARCHAR2(2000);
283:
284: BEGIN
285: FND_MSG_PUB.initialize;
286: IF P_PA_DEBUG_MODE = 'Y' THEN
287: pa_debug.init_err_stack('PA_FIN_PLAN_TYPE_GLOBAL.delete_plan_type_from_project');
288: END IF;
289: x_msg_count := 0;
290: /* CHECK FOR BUSINESS RULES VIOLATIONS */

Line 287: pa_debug.init_err_stack('PA_FIN_PLAN_TYPE_GLOBAL.delete_plan_type_from_project');

283:
284: BEGIN
285: FND_MSG_PUB.initialize;
286: IF P_PA_DEBUG_MODE = 'Y' THEN
287: pa_debug.init_err_stack('PA_FIN_PLAN_TYPE_GLOBAL.delete_plan_type_from_project');
288: END IF;
289: x_msg_count := 0;
290: /* CHECK FOR BUSINESS RULES VIOLATIONS */
291: -- If versions of the plan type exist in the project, cannot delete plan type

Line 329: pa_debug.reset_err_stack;

325: x_msg_count := l_msg_count;
326: else
327: x_msg_count := l_msg_count;
328: end if;
329: pa_debug.reset_err_stack;
330: return;
331: end if;
332:
333: /* IF NO BUSINESS RULES VIOLATIONS: PROCEED WITH DELETE PLAN TYPE */

Line 460: IF P_PA_DEBUG_MODE = 'Y' THEN

456: o.fin_plan_type_id = p_fin_plan_type_id);
457:
458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
463: END IF;
464:

Line 461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';

457:
458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
463: END IF;
464:
465: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take

Line 462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);

458: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
459:
460: IF P_PA_DEBUG_MODE = 'Y' THEN
461: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
462: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
463: END IF;
464:
465: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
466: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */

Line 475: IF P_PA_DEBUG_MODE = 'Y' THEN

471: FROM pa_proj_fp_options pfo
472: WHERE pfo.project_id = p_project_id
473: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
474:
475: IF P_PA_DEBUG_MODE = 'Y' THEN
476: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
477: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
478: END IF;
479:

Line 476: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';

472: WHERE pfo.project_id = p_project_id
473: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
474:
475: IF P_PA_DEBUG_MODE = 'Y' THEN
476: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
477: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
478: END IF;
479:
480: -- finally, delete from PA_PROJ_FP_OPTIONS

Line 477: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);

473: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
474:
475: IF P_PA_DEBUG_MODE = 'Y' THEN
476: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
477: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
478: END IF;
479:
480: -- finally, delete from PA_PROJ_FP_OPTIONS
481: delete from pa_proj_fp_options

Line 487: pa_debug.reset_err_stack;

483: fin_plan_option_level_code = 'PLAN_TYPE' and
484: fin_plan_type_id = p_fin_plan_type_id;
485:
486: x_return_status := FND_API.G_RET_STS_SUCCESS;
487: pa_debug.reset_err_stack;
488:
489: exception
490: when others then
491: rollback to PA_FP_DELETE_PLAN_TYPE;

Line 497: pa_debug.reset_err_stack;

493: x_msg_count := 1;
494: x_msg_data := SQLERRM;
495: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPE_GLOBAL',
496: p_procedure_name => 'delete_plan_type_from_project');
497: pa_debug.reset_err_stack;
498: raise FND_API.G_EXC_UNEXPECTED_ERROR;
499: END delete_plan_type_from_project;
500:
501: