DBA Data[Home] [Help]

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.5 2008/11/18 18:00:05 bifernan 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.5 2008/11/18 18:00:05 bifernan 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 1977: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

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

Line 2018: Pa_Prj_Period_Profile_Utils.Maintain_Prj_Period_Profile(

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

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

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

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

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

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

2778: END LOOP;
2779: EXCEPTION
2780: WHEN OTHERS THEN
2781: FND_MSG_PUB.add_exc_msg
2782: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.wrapper_refresh_pd_profile'
2783: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
2784: IF P_PA_DEBUG_MODE = 'Y' THEN
2785: PA_DEBUG.g_err_stage := 'Unexpected error in wrapper_refresh_pd_profile ';
2786: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);

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

3173: close period_profile_csr;
3174: EXCEPTION
3175: WHEN OTHERS THEN
3176: FND_MSG_PUB.add_exc_msg
3177: ( p_pkg_name => 'PA_PRJ_PERIOD_PROFILE_UTILS.get_current_period_info'
3178: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
3179: RAISE;
3180: END get_current_period_info;
3181:

Line 3256: END PA_PRJ_PERIOD_PROFILE_UTILS;

3252: COMMIT;
3253: END;
3254:
3255:
3256: END PA_PRJ_PERIOD_PROFILE_UTILS;