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

Line 108: pa_debug.init_err_stack('PA_BUDGET_ATTR_UPGR_PKG.Budget_Attr_Upgrd');

104: begin
105: -- FND_MSG_PUB.initialize; /* Bug 3800485 */
106: x_msg_count := 0;
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: pa_debug.init_err_stack('PA_BUDGET_ATTR_UPGR_PKG.Budget_Attr_Upgrd');
109: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN

Line 109: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

105: -- FND_MSG_PUB.initialize; /* Bug 3800485 */
106: x_msg_count := 0;
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: pa_debug.init_err_stack('PA_BUDGET_ATTR_UPGR_PKG.Budget_Attr_Upgrd');
109: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';

Line 111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);

107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: pa_debug.init_err_stack('PA_BUDGET_ATTR_UPGR_PKG.Budget_Attr_Upgrd');
109: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:

Line 113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';

109: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

Line 114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

110: l_debug_mode := NVL(l_debug_mode, 'Y');
111: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
118: END IF;

Line 116: pa_debug.g_err_stage := 'Checking for valid parameters';

112: IF l_debug_mode = 'Y' THEN
113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
118: END IF;
119:
120:

Line 117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

113: pa_debug.g_err_stage := 'Entered Budget Attribute Upgrade';
114: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
115:
116: pa_debug.g_err_stage := 'Checking for valid parameters';
117: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
118: END IF;
119:
120:
121: if (nvl(p_project_id,0) = 0) then

Line 123: pa_debug.g_err_stage := 'p_project_id='||to_char(p_project_id);

119:
120:
121: if (nvl(p_project_id,0) = 0) then
122: IF l_debug_mode = 'Y' THEN
123: pa_debug.g_err_stage := 'p_project_id='||to_char(p_project_id);
124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
125: END IF;
126: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
127: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

120:
121: if (nvl(p_project_id,0) = 0) then
122: IF l_debug_mode = 'Y' THEN
123: pa_debug.g_err_stage := 'p_project_id='||to_char(p_project_id);
124: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
125: END IF;
126: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
127: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
128: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 135: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);

131: -- bug 3673111, 07-JUN-04, jwhite ------------------------------------
132:
133: if (nvl(p_budget_version_id,0) = 0) then
134: IF l_debug_mode = 'Y' THEN
135: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
137: END IF;
138: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
139: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

132:
133: if (nvl(p_budget_version_id,0) = 0) then
134: IF l_debug_mode = 'Y' THEN
135: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
136: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
137: END IF;
138: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
139: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
140: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';

400: l_all_period_mask_id := l_period_mask_id;
401: end if;
402:
403: IF l_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';
405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
406: end if;
407:
408: update pa_proj_fp_options

Line 405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

401: end if;
402:
403: IF l_debug_mode = 'Y' THEN
404: pa_debug.g_err_stage := 'Update Pa_proj_fp_options Table.';
405: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
406: end if;
407:
408: update pa_proj_fp_options
409: SET cost_current_planning_period = l_cost_current_planning_period,

Line 427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';

423: IF l_get_fin_plan_ver_csr.fin_plan_option_level_code = 'PLAN_VERSION' THEN
424:
425: -- Update budget version table with the above values
426: IF l_debug_mode = 'Y' THEN
427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';
428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
429: end if;
430:
431: update pa_budget_versions

Line 428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);

424:
425: -- Update budget version table with the above values
426: IF l_debug_mode = 'Y' THEN
427: pa_debug.g_err_stage := 'Update Pa_Budget_versions Table.';
428: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
429: end if;
430:
431: update pa_budget_versions
432: set project_structure_version_id = NULL,

Line 470: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);

466:
467: IF ( l_return_status <> 'S')
468: THEN
469: IF l_debug_mode = 'Y' THEN
470: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
472: END IF;
473: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
474: p_msg_name => 'PA_FP_INV_PARAM_PASSED');

Line 471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

467: IF ( l_return_status <> 'S')
468: THEN
469: IF l_debug_mode = 'Y' THEN
470: pa_debug.g_err_stage := 'p_budget_version_id='||to_char(p_budget_version_id);
471: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
472: END IF;
473: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
474: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
475: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 502: pa_debug.g_err_stage:='Invalid Arguments Passed';

498: x_msg_data := l_msg_data;
499: END IF;
500:
501: IF l_debug_mode = 'Y' THEN
502: pa_debug.g_err_stage:='Invalid Arguments Passed';
503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);

Line 503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

499: END IF;
500:
501: IF l_debug_mode = 'Y' THEN
502: pa_debug.g_err_stage:='Invalid Arguments Passed';
503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);
507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);

Line 506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);

502: pa_debug.g_err_stage:='Invalid Arguments Passed';
503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);
507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);
508: pa_debug.reset_err_stack;
509: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
510: RAISE;

Line 507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);

503: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);
507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);
508: pa_debug.reset_err_stack;
509: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
510: RAISE;
511: WHEN OTHERS THEN

Line 508: pa_debug.reset_err_stack;

504: END IF;
505: x_return_status:= FND_API.G_RET_STS_ERROR;
506: pa_debug.write_file('BUDGET_ATTR_UPGRD_ATTR : Upgrade has failed for the project: '||p_project_id,5);
507: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||x_msg_data,5);
508: pa_debug.reset_err_stack;
509: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
510: RAISE;
511: WHEN OTHERS THEN
512:

Line 531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

527: x_msg_data := SQLERRM;
528:
529: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_BUDGET_ATTR_UPGR_PKG',p_procedure_name => 'BUDGET_ATTR_UPGRD');
530: IF l_debug_mode = 'Y' THEN
531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);

Line 532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

528:
529: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_BUDGET_ATTR_UPGR_PKG',p_procedure_name => 'BUDGET_ATTR_UPGRD');
530: IF l_debug_mode = 'Y' THEN
531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);
536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);

Line 535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);

531: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);
536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);
537: pa_debug.reset_err_stack;
538: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
539: RAISE;

Line 536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);

532: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);
536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);
537: pa_debug.reset_err_stack;
538: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
539: RAISE;
540: end BUDGET_ATTR_UPGRD;

Line 537: pa_debug.reset_err_stack;

533: END IF;
534:
535: pa_debug.write_file('BUDGET_ATTR_UPGRD : Upgrade has failed for the project'||p_project_id,5);
536: pa_debug.write_file('BUDGET_ATTR_UPGRD : Failure Reason:'||pa_debug.G_Err_Stack,5);
537: pa_debug.reset_err_stack;
538: --ROLLBACK; /* Should Not have Rollback in this package. Only main API rollback should be active */
539: RAISE;
540: end BUDGET_ATTR_UPGRD;
541: end PA_BUDGET_ATTR_UPGR_PKG;