APPS.PA_PRJ_PERIOD_PROFILE_UTILS dependencies on PA_PRJ_PERIOD_PROFILE_UTILS

Line 1: PACKAGE BODY Pa_Prj_Period_Profile_Utils as

1: PACKAGE BODY Pa_Prj_Period_Profile_Utils as
2: /* $Header: PAPJPDPB.pls 120.1.12010000.8 2009/05/21 12:15:37 vgovvala ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_prj_period_profile_utils';

Line 5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_prj_period_profile_utils';

1: PACKAGE BODY Pa_Prj_Period_Profile_Utils as
2: /* $Header: PAPJPDPB.pls 120.1.12010000.8 2009/05/21 12:15:37 vgovvala ship $ */
3:
4: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
5: g_module_name VARCHAR2(100) := 'pa.plsql.pa_prj_period_profile_utils';
6:
7: Procedure Maintain_Prj_Period_Profile(
8: p_project_id IN NUMBER,
9: p_period_profile_type IN VARCHAR2,

Line 1452: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

1448: END IF;
1449: END IF;
1450:
1451: IF l_call_profile_gl_flag = 'Y' THEN
1452: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(
1453: p_project_id => p_project_id,
1454: p_period_profile_type => p_period_profile_type,
1455: p_plan_period_type => 'GL',
1456: p_period_set_name => l_gl_period_set_name,

Line 1477: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

1473: RETURN;
1474: END IF;
1475: END IF;
1476: IF l_call_profile_pa_flag = 'Y' THEN
1477: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(
1478: p_project_id => p_project_id,
1479: p_period_profile_type => p_period_profile_type,
1480: p_plan_period_type => 'PA',
1481: p_period_set_name => l_gl_period_set_name,

Line 1978: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

1974: pa_debug.g_err_stage := 'Calling Maintain_Prj_Period_Profile to create the PA period profile ....';
1975: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
1976: END IF;
1977:
1978: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(
1979: p_project_id => p_project_id,
1980: p_period_profile_type => 'FINANCIAL_PLANNING',
1981: p_plan_period_type => 'PA',
1982: p_period_set_name => l_period_set_name,

Line 2019: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

2015: pa_debug.g_err_stage := 'Calling Maintain_Prj_Period_Profile to create the GL period profile ....';
2016: pa_debug.write(g_module_name,pa_debug.g_err_stage,3);
2017: END IF;
2018:
2019: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(
2020: p_project_id => p_project_id,
2021: p_period_profile_type => 'FINANCIAL_PLANNING',
2022: p_plan_period_type => 'GL',
2023: p_period_set_name => l_period_set_name,

Line 2232: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_PRJ_PERIOD_PROFILE_UTILS'

2228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2229: x_msg_count := 1;
2230: x_msg_data := SQLERRM;
2231:
2232: FND_MSG_PUB.add_exc_msg( p_pkg_name=> 'PA_PRJ_PERIOD_PROFILE_UTILS'
2233: ,p_procedure_name => 'Get_Curr_Period_Profile_Info');
2234:
2235: pa_debug.g_err_stage:='Unexpected Error' || SQLERRM;
2236: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2482: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.refresh_period_profile'

2478: COMMIT;
2479: EXCEPTION
2480: WHEN OTHERS THEN
2481: FND_MSG_PUB.add_exc_msg
2482: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.refresh_period_profile'
2483: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2484: IF P_PA_DEBUG_MODE = 'Y' THEN
2485: PA_DEBUG.g_err_stage := 'Unexpected error in refresh_period_profile ';
2486: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 2839: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.wrapper_refresh_pd_profile'

2835: /*End Changes for 7563735 - unsetting the locked_by_person_id here, depending on the return_status code*/
2836: EXCEPTION
2837: WHEN OTHERS THEN
2838: FND_MSG_PUB.add_exc_msg
2839: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.wrapper_refresh_pd_profile'
2840: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2841: IF P_PA_DEBUG_MODE = 'Y' THEN
2842: PA_DEBUG.g_err_stage := 'Unexpected error in wrapper_refresh_pd_profile ';
2843: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

Line 3234: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.get_current_period_info'

3230: close period_profile_csr;
3231: EXCEPTION
3232: WHEN OTHERS THEN
3233: FND_MSG_PUB.add_exc_msg
3234: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.get_current_period_info'
3235: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3236: RAISE;
3237: END get_current_period_info;
3238:

Line 3313: END PA_PRJ_PERIOD_PROFILE_UTILS;

3309: COMMIT;
3310: END;
3311:
3312:
3313: END PA_PRJ_PERIOD_PROFILE_UTILS;