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 800: pa_debug.reset_err_stack;

796: x_msg_count := 1;
797: x_msg_data := SQLERRM;
798: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
799: p_procedure_name => 'Assign_Default_Amount');
800: pa_debug.reset_err_stack;
801: return;
802: END assign_default_amount;
803:
804: /* Added this new function as part of the changes done for View Plan Enhancement 7514054 */

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

951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: return null;
954: WHEN TOO_MANY_ROWS THEN
955: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
956: to_char(p_period_profile_id));
957: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
958: to_char(p_amount_type_id));
959: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||

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

953: return null;
954: WHEN TOO_MANY_ROWS THEN
955: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
956: to_char(p_period_profile_id));
957: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
958: to_char(p_amount_type_id));
959: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
960: to_char(p_resource_assignment_id));
961: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

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

955: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
956: to_char(p_period_profile_id));
957: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
958: to_char(p_amount_type_id));
959: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
960: to_char(p_resource_assignment_id));
961: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
962: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1890: EXCEPTION
1891: WHEN NO_DATA_FOUND THEN
1892: return null;
1893: WHEN TOO_MANY_ROWS THEN
1894: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1895: to_char(p_period_profile_id));
1896: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1897: to_char(p_amount_type_id));
1898: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||

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

1892: return null;
1893: WHEN TOO_MANY_ROWS THEN
1894: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1895: to_char(p_period_profile_id));
1896: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1897: to_char(p_amount_type_id));
1898: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1899: to_char(p_resource_assignment_id));
1900: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

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

1894: pa_debug.write_file('get_period_n_value: p_period_profile_id= ' ||
1895: to_char(p_period_profile_id));
1896: pa_debug.write_file('get_period_n_value: p_amount_type_id= ' ||
1897: to_char(p_amount_type_id));
1898: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1899: to_char(p_resource_assignment_id));
1900: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1901: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

4847: -- RETRIEVE the current period_profile_id's for GL
4848: open GL_ppId;
4849: fetch GL_ppId into GL_ppId_rec;
4850: if GL_ppId%NOTFOUND then
4851: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for GL', 2);
4852: else
4853: l_gl_pd_profile_id := GL_ppId_rec.period_profile_id;
4854: end if;
4855: close GL_ppId;

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

4856: -- RETRIEVE the current period_profile_id's for PA
4857: open PA_ppId;
4858: fetch PA_ppId into PA_ppId_rec;
4859: if PA_ppId%NOTFOUND then
4860: pa_debug.write('pa_fp_view_plans_util.refresh_period_profile', 'no ppid for PA', 2);
4861: else
4862: l_pa_pd_profile_id := PA_ppId_rec.period_profile_id;
4863: end if;
4864: close PA_ppId;

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

4876: argument5 => l_gl_pd_profile_id,
4877: argument6 => l_pa_pd_profile_id,
4878: argument7 => l_debug_mode);
4879: IF l_rpt_request_id = 0 then
4880: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4881: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4882: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4883: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4884: x_return_status := FND_API.G_RET_STS_ERROR;

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

4877: argument6 => l_pa_pd_profile_id,
4878: argument7 => l_debug_mode);
4879: IF l_rpt_request_id = 0 then
4880: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4881: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4882: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4883: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4884: x_return_status := FND_API.G_RET_STS_ERROR;
4885: ROLLBACK;

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

4884: x_return_status := FND_API.G_RET_STS_ERROR;
4885: ROLLBACK;
4886: RETURN;
4887: ELSE
4888: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||
4889: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4890: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4891: p_write_file => 'OUT',
4892: p_write_mode => 1);

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

4886: RETURN;
4887: ELSE
4888: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||
4889: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4890: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4891: p_write_file => 'OUT',
4892: p_write_mode => 1);
4893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4894: END IF;

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

4889: LTRIM(TO_CHAR(l_rpt_request_id )) ;
4890: PA_DEBUG.log_Message( p_message => PA_DEBUG.g_err_stage,
4891: p_write_file => 'OUT',
4892: p_write_mode => 1);
4893: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4894: END IF;
4895: x_conc_req_id := LTRIM(RTRIM(TO_CHAR(l_rpt_request_id)));
4896:
4897: -- bug 2740907: stamp request_id into pa_budget_versions

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

5011:
5012: l_stage number := 0;
5013:
5014: BEGIN
5015: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
5016:
5017: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5018: l_debug_mode := NVL(l_debug_mode, 'Y');
5019:

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

5013:
5014: BEGIN
5015: pa_debug.init_err_stack('PA_FP_ORG_FCST_GEN_PUB.get_amttype_id');
5016:
5017: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5018: l_debug_mode := NVL(l_debug_mode, 'Y');
5019:
5020: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
5021:

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

5016:
5017: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5018: l_debug_mode := NVL(l_debug_mode, 'Y');
5019:
5020: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
5021:
5022: l_amount_type_id := -99;
5023:
5024: IF l_amt_code.last IS NULL THEN

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

5037: END IF;
5038: END LOOP;
5039: END IF;
5040: IF l_amount_type_id = -99 THEN
5041: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
5042: pa_debug.write_file(pa_debug.g_err_stage);
5043: END IF;
5044: pa_debug.reset_err_stack;
5045: RETURN(l_amount_type_id);

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

5038: END LOOP;
5039: END IF;
5040: IF l_amount_type_id = -99 THEN
5041: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
5042: pa_debug.write_file(pa_debug.g_err_stage);
5043: END IF;
5044: pa_debug.reset_err_stack;
5045: RETURN(l_amount_type_id);
5046:

Line 5044: pa_debug.reset_err_stack;

5040: IF l_amount_type_id = -99 THEN
5041: pa_debug.g_err_stage := 'p_amt_typ_code ['||p_amt_typ_code ||']';
5042: pa_debug.write_file(pa_debug.g_err_stage);
5043: END IF;
5044: pa_debug.reset_err_stack;
5045: RETURN(l_amount_type_id);
5046:
5047: EXCEPTION
5048: WHEN OTHERS THEN

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

5047: EXCEPTION
5048: WHEN OTHERS THEN
5049: FND_MSG_PUB.add_exc_msg(
5050: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
5051: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
5052:
5053: pa_debug.write_file(SQLERRM);
5054: pa_debug.reset_err_stack;
5055: RAISE;

Line 5053: pa_debug.write_file(SQLERRM);

5049: FND_MSG_PUB.add_exc_msg(
5050: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
5051: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
5052:
5053: pa_debug.write_file(SQLERRM);
5054: pa_debug.reset_err_stack;
5055: RAISE;
5056: END get_amttype_id;
5057:

Line 5054: pa_debug.reset_err_stack;

5050: p_pkg_name => 'PA_FP_ORG_FCST_GEN_PUB.get_amttype_id'
5051: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
5052:
5053: pa_debug.write_file(SQLERRM);
5054: pa_debug.reset_err_stack;
5055: RAISE;
5056: END get_amttype_id;
5057:
5058:

Line 5113: pa_debug.reset_err_stack;

5109: x_msg_count := 1;
5110: x_msg_data := SQLERRM;
5111: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5112: p_procedure_name => 'check_res_assignment_exists');
5113: pa_debug.reset_err_stack;
5114: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5115: END check_res_assignment_exists;
5116:
5117:

Line 5201: pa_debug.reset_err_stack;

5197: x_resource_level := 'N';
5198: end if;
5199: -- for an ungrouped resource list only these are the possible values.
5200: -- no further processing is required
5201: pa_debug.reset_err_stack;
5202: return;
5203: end if; -- l_group_resource_type_id = 0
5204:
5205: -- fetch proj_fp_options_id and planning level of the version

Line 5237: pa_debug.reset_err_stack;

5233: when no_data_found then
5234: -- no planning elements returned: return 'N'
5235: x_resource_level := 'N';
5236: l_prj_rlm_id := null;
5237: pa_debug.reset_err_stack;
5238: return;
5239: end;
5240: if nvl(l_prj_rlm_id,0) > 0 then
5241: select decode(parent_member_id,null,'G','R')

Line 5253: pa_debug.reset_err_stack;

5249: fetch c1 into c1_rec;
5250: if c1%NOTFOUND then
5251: -- no planning elements returned: return 'N'
5252: x_resource_level := 'N';
5253: pa_debug.reset_err_stack;
5254: return;
5255: else
5256: /* loop through the records, checking the 'resource_planning_level' attribute
5257: * if they are ALL 'R', then x_resource_level := 'R'

Line 5282: pa_debug.reset_err_stack;

5278:
5279: if x_resource_level = 'R' and l_group_resource_type_id <> 0 then
5280: x_resource_level := 'M';
5281: end if;
5282: pa_debug.reset_err_stack;
5283: EXCEPTION
5284: WHEN OTHERS THEN
5285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5286: x_msg_count := 1;

Line 5290: pa_debug.reset_err_stack;

5286: x_msg_count := 1;
5287: x_msg_data := SQLERRM;
5288: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5289: p_procedure_name => 'get_plan_version_res_level');
5290: pa_debug.reset_err_stack;
5291: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_plan_version_res_level;
5293:
5294: end pa_fp_view_plans_util;