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 317: IF P_PA_DEBUG_MODE = 'Y' THEN

313: l_exists_association VARCHAR2(1);
314:
315: BEGIN
316: FND_MSG_PUB.initialize;
317: IF P_PA_DEBUG_MODE = 'Y' THEN
318: pa_debug.init_err_stack('PA_FIN_PLAN_TYPE_GLOBAL.delete_plan_type_from_project');
319: END IF;
320: x_msg_count := 0;
321: /* CHECK FOR BUSINESS RULES VIOLATIONS */

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

314:
315: BEGIN
316: FND_MSG_PUB.initialize;
317: IF P_PA_DEBUG_MODE = 'Y' THEN
318: pa_debug.init_err_stack('PA_FIN_PLAN_TYPE_GLOBAL.delete_plan_type_from_project');
319: END IF;
320: x_msg_count := 0;
321: /* CHECK FOR BUSINESS RULES VIOLATIONS */
322: -- If versions of the plan type exist in the project, cannot delete plan type

Line 360: pa_debug.reset_err_stack;

356: x_msg_count := l_msg_count;
357: else
358: x_msg_count := l_msg_count;
359: end if;
360: pa_debug.reset_err_stack;
361: return;
362: end if;
363:
364: /* IF NO BUSINESS RULES VIOLATIONS: PROCEED WITH DELETE PLAN TYPE */

Line 503: IF P_PA_DEBUG_MODE = 'Y' THEN

499: o.fin_plan_type_id = p_fin_plan_type_id);
500:
501: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
502:
503: IF P_PA_DEBUG_MODE = 'Y' THEN
504: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
506: END IF;
507:

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

500:
501: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
502:
503: IF P_PA_DEBUG_MODE = 'Y' THEN
504: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
506: END IF;
507:
508: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take

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

501: --For Bug 2976168. Should delete the records from pa_fp_excluded_elements also
502:
503: IF P_PA_DEBUG_MODE = 'Y' THEN
504: pa_debug.g_err_stage:= 'About to delete from pa_fp_excluded_elements';
505: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
506: END IF;
507:
508: /* Using proj_fp_options_id join instead of directly using project_id, fin_plan_type_id to take
509: advantage of pa_fp_excluded_index_u1 index on pa_fp_excluded_elements */

Line 518: IF P_PA_DEBUG_MODE = 'Y' THEN

514: FROM pa_proj_fp_options pfo
515: WHERE pfo.project_id = p_project_id
516: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
517:
518: IF P_PA_DEBUG_MODE = 'Y' THEN
519: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
520: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
521: END IF;
522:

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

515: WHERE pfo.project_id = p_project_id
516: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
517:
518: IF P_PA_DEBUG_MODE = 'Y' THEN
519: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
520: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
521: END IF;
522:
523: --Bug#11776072 - Addition starts

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

516: AND pfo.fin_plan_type_id=p_fin_plan_type_id);
517:
518: IF P_PA_DEBUG_MODE = 'Y' THEN
519: pa_debug.g_err_stage:= To_char(SQL%ROWCOUNT) || ' records deleted.';
520: pa_debug.write('delete_plan_type_from_project : PA_FIN_PLAN_TYPE_GLOBAL',pa_debug.g_err_stage,3);
521: END IF;
522:
523: --Bug#11776072 - Addition starts
524: open get_rbs_version_id_cur(p_project_id,p_fin_plan_type_id);

Line 561: pa_debug.reset_err_stack;

557: END IF;
558: --Bug#11776072 - Addition end
559:
560: x_return_status := FND_API.G_RET_STS_SUCCESS;
561: pa_debug.reset_err_stack;
562:
563: exception
564: when others then
565: rollback to PA_FP_DELETE_PLAN_TYPE;

Line 571: pa_debug.reset_err_stack;

567: x_msg_count := 1;
568: x_msg_data := SQLERRM;
569: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FIN_PLAN_TYPE_GLOBAL',
570: p_procedure_name => 'delete_plan_type_from_project');
571: pa_debug.reset_err_stack;
572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
573: END delete_plan_type_from_project;
574:
575: