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.3 2008/11/18 15:41:06 bnoorbha 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 141: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.approved_plan_types'

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

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

224: 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
225: NVL(p_est_proj_revenue,0) <> NVL(est_amt_rec.est_project_revenue,0)THEN
226: IF p_pa_debug_mode = 'Y' THEN
227: PA_DEBUG.write_log (x_module =>
228: 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.Maintain_Ctrl_Item_Version.check_for_fp_impact'
229: ,x_msg => 'inside edit buttons check'
230: ,x_log_level => 5);
231: END IF;
232: /* FP.M -The following function call is used to get the impact information

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

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

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

581: EXCEPTION
582: WHEN OTHERS THEN
583:
584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
585: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
586: p_procedure_name => 'MAINTAIN_CTRL_ITEM_VERSION',
587: p_error_text => SUBSTRB(SQLERRM,1,240));
588:
589: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

843: EXCEPTION
844: WHEN OTHERS THEN
845:
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
848: p_procedure_name => 'Maintain_Plan_Version',
849: p_error_text => SUBSTRB(SQLERRM,1,240));
850:
851: fnd_msg_pub.count_and_get(p_count => x_msg_count,

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

870: l_msg_index_out NUMBER:=0;
871: l_msg_count NUMBER;
872: l_module VARCHAR2(255);
873: BEGIN
874: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
875:
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
878: PA_DEBUG.write_log (x_module => l_module

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

873: BEGIN
874: l_module := 'pa.plsql.Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions';
875:
876: IF p_pa_debug_mode = 'Y' THEN
877: PA_DEBUG.init_err_stack('Pa_Fp_Control_Items_Impact_Pkg.delete_ci_plan_versions');
878: PA_DEBUG.write_log (x_module => l_module
879: ,x_msg => 'inside del API call'
880: ,x_log_level => 5);
881: END IF;

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

958: PA_DEBUG.Reset_Err_stack;
959: END IF;
960:
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
962: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_FP_CONTROL_ITEMS_IMPACT_PKG',
963: p_procedure_name => 'DELETE_CI_PLAN_VERSIONS',
964: p_error_text => SUBSTRB(SQLERRM,1,240));
965:
966: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 973: END Pa_Fp_Control_Items_Impact_Pkg;

969:
970:
971: END delete_ci_plan_versions;
972:
973: END Pa_Fp_Control_Items_Impact_Pkg;