APPS.PA_FP_CONTROL_ITEMS_IMPACT_PKG dependencies on PA_FP_CONTROL_ITEMS_IMPACT_PKG

Line 1: PACKAGE BODY Pa_Fp_Control_Items_Impact_Pkg AS

1: PACKAGE BODY Pa_Fp_Control_Items_Impact_Pkg AS
2: /* $Header: PAFPCIIB.pls 120.4.12010000.5 2009/06/29 08:12:25 vgovvala ship $ */
3: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4: PROCEDURE Maintain_Ctrl_Item_Version(
5: p_project_id IN Pa_Projects_All.Project_Id%TYPE,

Line 144: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.approved_plan_types'

140:
141: IF l_no_of_app_plan_types = 0 THEN
142: IF p_pa_debug_mode = 'Y' THEN
143: PA_DEBUG.write_log (x_module =>
144: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.approved_plan_types'
145: ,x_msg => 'no of approved plan types is zero'
146: ,x_log_level => 5);
147: END IF;
148:

Line 232: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'

228: NVL(p_agreement_id,0) <> NVL(est_amt_rec.agreement_id,0) OR --Impact should be created even when only agreement is entered and saved
229: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
230: IF p_pa_debug_mode = 'Y' THEN
231: PA_DEBUG.write_log (x_module =>
232: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
233: ,x_msg => 'inside edit buttons check'
234: ,x_log_level => 5);
235: END IF;
236: /* FP.M -The following function call is used to get the impact information

Line 240: PA_DEBUG.write_log (x_module => 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.calling_ci_impact_pkg'

236: /* FP.M -The following function call is used to get the impact information
237: */
238: l_impact_type_code := Pa_Fp_Control_Items_Utils.is_impact_exists(p_ci_id);
239: IF p_pa_debug_mode = 'Y' THEN
240: PA_DEBUG.write_log (x_module => 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.calling_ci_impact_pkg'
241: ,x_msg => 'calling create ci impact '
242: ,x_log_level => 5);
243: END IF;
244: /* FP.M - Apart from the record with Impact_type_code of FINPLAN

Line 610: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',

606: EXCEPTION
607: WHEN OTHERS THEN
608:
609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
610: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
611: p_procedure_name => 'MAINTAIN_CTRL_ITEM_VERSION',
612: p_error_text => SUBSTRB(SQLERRM,1,240));
613:
614: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',

893: EXCEPTION
894: WHEN OTHERS THEN
895:
896: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
897: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
898: p_procedure_name => 'Maintain_Plan_Version',
899: p_error_text => SUBSTRB(SQLERRM,1,240));
900:
901: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';

920: l_msg_index_out NUMBER:=0;
921: l_msg_count NUMBER;
922: l_module VARCHAR2(255);
923: BEGIN
924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
925:
926: IF p_pa_debug_mode = 'Y' THEN
927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
928: PA_DEBUG.write_log (x_module => l_module

Line 927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');

923: BEGIN
924: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
925:
926: IF p_pa_debug_mode = 'Y' THEN
927: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
928: PA_DEBUG.write_log (x_module => l_module
929: ,x_msg => 'inside del API call'
930: ,x_log_level => 5);
931: END IF;

Line 1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',

1008: PA_DEBUG.Reset_Err_stack;
1009: END IF;
1010:
1011: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1012: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
1013: p_procedure_name => 'DELETE_CI_PLAN_VERSIONS',
1014: p_error_text => SUBSTRB(SQLERRM,1,240));
1015:
1016: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 1023: END Pa_Fp_Control_Items_Impact_Pkg;

1019:
1020:
1021: END delete_ci_plan_versions;
1022:
1023: END Pa_Fp_Control_Items_Impact_Pkg;