APPS.PA_FP_VIEW_PLANS_UTIL dependencies on PA_FP_VIEW_PLANS_UTIL

Line 1: PACKAGE BODY pa_fp_view_plans_util as

1: PACKAGE BODY pa_fp_view_plans_util as
2: /* $Header: PAFPVPUB.pls 120.1 2005/08/19 16:31:38 mwasowic noship $
3: Start of Comments
4: Package name : pa_fin_plan_maint_ver_global
5: Purpose : API's for Financial Planning: View Plans Page

Line 1731: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

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;
1734: WHEN OTHERS THEN
1735: 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 4831: l_amt_code pa_fp_view_plans_util.char240_data_type_table;

4827: FUNCTION get_amttype_id
4828: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4829: is
4830: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
4831: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
4832: l_amt_id pa_fp_view_plans_util.number_data_type_table;
4833:
4834: l_debug_mode VARCHAR2(30);
4835:

Line 4832: l_amt_id pa_fp_view_plans_util.number_data_type_table;

4828: ( p_amt_typ_code IN pa_amount_types_b.amount_type_code%TYPE) RETURN NUMBER
4829: is
4830: l_amount_type_id pa_amount_types_b.amount_type_id%TYPE;
4831: l_amt_code pa_fp_view_plans_util.char240_data_type_table;
4832: l_amt_id pa_fp_view_plans_util.number_data_type_table;
4833:
4834: l_debug_mode VARCHAR2(30);
4835:
4836: CURSOR get_amt_det IS

Line 4941: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

4937: WHEN OTHERS THEN
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 5118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',

5114: WHEN OTHERS THEN
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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;

Line 5124: end pa_fp_view_plans_util;

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;