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

Line 798: pa_debug.reset_err_stack;

794: x_msg_count := 1;
795: x_msg_data := SQLERRM;
796: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
797: p_procedure_name => 'Assign_Default_Amount');
798: pa_debug.reset_err_stack;
799: return;
800: END assign_default_amount;
801: /* --------------------------------------------------------------------- */
802: -- CHANGE HISTORY:

Line 1725: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||

1721: EXCEPTION
1722: WHEN NO_DATA_FOUND THEN
1723: return null;
1724: WHEN TOO_MANY_ROWS THEN
1725: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1726: to_char(p_period_profile_id));
1727: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1728: to_char(p_amount_type_id));
1729: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||

Line 1727: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||

1723: return null;
1724: WHEN TOO_MANY_ROWS THEN
1725: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1726: to_char(p_period_profile_id));
1727: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1728: to_char(p_amount_type_id));
1729: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1730: to_char(p_resource_assignment_id));
1731: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

Line 1729: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||

1725: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1726: to_char(p_period_profile_id));
1727: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1728: to_char(p_amount_type_id));
1729: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1730: to_char(p_resource_assignment_id));
1731: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1732: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4681: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for GL', 2);

4677: -- RETRIEVE the current period_profile_id's for GL
4678: open GL_ppId;
4679: fetch GL_ppId into GL_ppId_rec;
4680: if GL_ppId%NOTFOUND then
4681: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for GL', 2);
4682: else
4683: l_gl_pd_profile_id := GL_ppId_rec.period_profile_id;
4684: end if;
4685: close GL_ppId;

Line 4690: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for PA', 2);

4686: -- RETRIEVE the current period_profile_id's for PA
4687: open PA_ppId;
4688: fetch PA_ppId into PA_ppId_rec;
4689: if PA_ppId%NOTFOUND then
4690: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for PA', 2);
4691: else
4692: l_pa_pd_profile_id := PA_ppId_rec.period_profile_id;
4693: end if;
4694: close PA_ppId;

Line 4710: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';

4706: argument5 => l_gl_pd_profile_id,
4707: argument6 => l_pa_pd_profile_id,
4708: argument7 => l_debug_mode);
4709: IF l_rpt_request_id = 0 then
4710: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4712: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4713: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4714: x_return_status := FND_API.G_RET_STS_ERROR;

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

4707: argument6 => l_pa_pd_profile_id,
4708: argument7 => l_debug_mode);
4709: IF l_rpt_request_id = 0 then
4710: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4712: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4713: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4714: x_return_status := FND_API.G_RET_STS_ERROR;
4715: ROLLBACK;

Line 4718: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||

4714: x_return_status := FND_API.G_RET_STS_ERROR;
4715: ROLLBACK;
4716: RETURN;
4717: ELSE
4718: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||
4719: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4720: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4721: p_write_file => 'OUT',
4722: p_write_mode => 1);

Line 4720: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,

4716: RETURN;
4717: ELSE
4718: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||
4719: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4720: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4721: p_write_file => 'OUT',
4722: p_write_mode => 1);
4723: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4724: END IF;

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

4719: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4720: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4721: p_write_file => 'OUT',
4722: p_write_mode => 1);
4723: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4724: END IF;
4725: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4726:
4727: -- bug 2740907: stamp request_id into pa_budget_versions

Line 4845: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');

4841:
4842: l_stage number := 0;
4843:
4844: BEGIN
4845: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
4846:
4847: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4848: l_debug_mode := NVL(l_debug_mode, 'Y');
4849:

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

4843:
4844: BEGIN
4845: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
4846:
4847: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4848: l_debug_mode := NVL(l_debug_mode, 'Y');
4849:
4850: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4851:

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

4846:
4847: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4848: l_debug_mode := NVL(l_debug_mode, 'Y');
4849:
4850: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4851:
4852: l_amount_type_id := -99;
4853:
4854: IF l_amt_code.last IS NULL THEN

Line 4871: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';

4867: END IF;
4868: END LOOP;
4869: END IF;
4870: IF l_amount_type_id = -99 THEN
4871: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
4872: pa_debug.write_file(pa_debug.g_err_stage);
4873: END IF;
4874: pa_debug.reset_err_stack;
4875: RETURN(l_amount_type_id);

Line 4872: pa_debug.write_file(pa_debug.g_err_stage);

4868: END LOOP;
4869: END IF;
4870: IF l_amount_type_id = -99 THEN
4871: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
4872: pa_debug.write_file(pa_debug.g_err_stage);
4873: END IF;
4874: pa_debug.reset_err_stack;
4875: RETURN(l_amount_type_id);
4876:

Line 4874: pa_debug.reset_err_stack;

4870: IF l_amount_type_id = -99 THEN
4871: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
4872: pa_debug.write_file(pa_debug.g_err_stage);
4873: END IF;
4874: pa_debug.reset_err_stack;
4875: RETURN(l_amount_type_id);
4876:
4877: EXCEPTION
4878: WHEN OTHERS THEN

Line 4881: ,p_procedure_name => PA_DEBUG.G_Err_Stack);

4877: EXCEPTION
4878: WHEN OTHERS THEN
4879: FND_MSG_PUB.add_exc_msg(
4880: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
4881: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4882:
4883: pa_debug.write_file(SQLERRM);
4884: pa_debug.reset_err_stack;
4885: RAISE;

Line 4883: pa_debug.write_file(SQLERRM);

4879: FND_MSG_PUB.add_exc_msg(
4880: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
4881: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4882:
4883: pa_debug.write_file(SQLERRM);
4884: pa_debug.reset_err_stack;
4885: RAISE;
4886: END get_amttype_id;
4887:

Line 4884: pa_debug.reset_err_stack;

4880: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
4881: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4882:
4883: pa_debug.write_file(SQLERRM);
4884: pa_debug.reset_err_stack;
4885: RAISE;
4886: END get_amttype_id;
4887:
4888:

Line 4943: pa_debug.reset_err_stack;

4939: x_msg_count := 1;
4940: x_msg_data := SQLERRM;
4941: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
4942: p_procedure_name => 'check_res_assignment_exists');
4943: pa_debug.reset_err_stack;
4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END check_res_assignment_exists;
4946:
4947:

Line 5031: pa_debug.reset_err_stack;

5027: x_resource_level := 'N';
5028: end if;
5029: -- for an ungrouped resource list only these are the possible values.
5030: -- no further processing is required
5031: pa_debug.reset_err_stack;
5032: return;
5033: end if; -- l_group_resource_type_id = 0
5034:
5035: -- fetch proj_fp_options_id and planning level of the version

Line 5067: pa_debug.reset_err_stack;

5063: when no_data_found then
5064: -- no planning elements returned: return 'N'
5065: x_resource_level := 'N';
5066: l_prj_rlm_id := null;
5067: pa_debug.reset_err_stack;
5068: return;
5069: end;
5070: if nvl(l_prj_rlm_id,0) > 0 then
5071: select decode(parent_member_id,null,'G','R')

Line 5083: pa_debug.reset_err_stack;

5079: fetch c1 into c1_rec;
5080: if c1%NOTFOUND then
5081: -- no planning elements returned: return 'N'
5082: x_resource_level := 'N';
5083: pa_debug.reset_err_stack;
5084: return;
5085: else
5086: /* loop through the records, checking the 'resource_planning_level' attribute
5087: * if they are ALL 'R', then x_resource_level := 'R'

Line 5112: pa_debug.reset_err_stack;

5108:
5109: if x_resource_level = 'R' and l_group_resource_type_id <> 0 then
5110: x_resource_level := 'M';
5111: end if;
5112: pa_debug.reset_err_stack;
5113: EXCEPTION
5114: WHEN OTHERS THEN
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5116: x_msg_count := 1;

Line 5120: pa_debug.reset_err_stack;

5116: x_msg_count := 1;
5117: x_msg_data := SQLERRM;
5118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5119: p_procedure_name => 'get_plan_version_res_level');
5120: pa_debug.reset_err_stack;
5121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5122: END get_plan_version_res_level;
5123:
5124: end pa_fp_view_plans_util;