eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJ_FP_OPTIONS_PUB dependencies on PA_PROJ_FP_OPTIONS_PUB

Line 1: package body PA_PROJ_FP_OPTIONS_PUB as

1: package body PA_PROJ_FP_OPTIONS_PUB as
2: /* $Header: PAFPOPPB.pls 120.10 2007/11/26 15:50:53 rthumma ship $ */
3:
4: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');

Line 4: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';

1: package body PA_PROJ_FP_OPTIONS_PUB as
2: /* $Header: PAFPOPPB.pls 120.10 2007/11/26 15:50:53 rthumma ship $ */
3:
4: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
5: P_PA_DEBUG_MODE varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
6:
7: /*==================================================================================================
8: CREATE_FP_OPTION: This procedure inserts or updates records in 3 table depending

Line 67: FP_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;

63: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
64: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_msg_data OUT NOCOPY VARCHAR2 ) is --File.Sql.39 bug 4440895
66:
67: FP_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
68: FP_Mc_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;
69: l_par_Proj_FP_Options_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
70: l_source_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
71: l_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;

Line 68: FP_Mc_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;

64: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
65: ,x_msg_data OUT NOCOPY VARCHAR2 ) is --File.Sql.39 bug 4440895
66:
67: FP_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
68: FP_Mc_Cols_Rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;
69: l_par_Proj_FP_Options_id pa_proj_fp_options.PROJ_FP_OPTIONS_ID%TYPE;
70: l_source_project_id pa_proj_fp_options.PROJECT_ID%TYPE;
71: l_plan_type_id pa_proj_fp_options.FIN_PLAN_TYPE_ID%TYPE;
72: l_plan_version_id pa_proj_fp_options.FIN_PLAN_VERSION_ID%TYPE;

Line 83: FP_Cols_Rec_Rev_Def PA_PROJ_FP_OPTIONS_PUB.FP_COLS;

79: l_approved_rev_plan_type_flag pa_proj_fp_options.APPROVED_REV_PLAN_TYPE_FLAG%TYPE;
80: l_source_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
81:
82: /* Bug # 2702000 */
83: FP_Cols_Rec_Rev_Def PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
84:
85: l_debug_mode VARCHAR2(30);
86: l_msg_count NUMBER := 0;
87: l_data VARCHAR2(2000);

Line 104: l_default_gen_options_rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;

100: -- -------------------------------------------------------
101:
102: -- FP M Dev Effort new variables
103:
104: l_default_gen_options_rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
105: l_source_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
106:
107: -- 3/30/2004 FP M Phase II Dev Effort
108:

Line 158: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option');

154:
155: BEGIN
156: FND_MSG_PUB.initialize;
157: IF P_PA_DEBUG_MODE = 'Y' THEN
158: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option');
159: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
160: l_debug_mode := NVL(l_debug_mode, 'Y');
161: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
162: END IF;

Line 1508: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option'

1504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: x_msg_count := 1;
1506: x_msg_data := SQLERRM;
1507: FND_MSG_PUB.add_exc_msg
1508: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option'
1509: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
1510: IF P_PA_DEBUG_MODE = 'Y' THEN
1511: pa_debug.write('Create_FP_Option: ' || l_module_name,SQLERRM,5);
1512: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 1592: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');

1588: l_target_burd_rate_flag pa_fin_plan_amount_sets.burden_rate_flag%TYPE;
1589:
1590: BEGIN
1591: IF P_PA_DEBUG_MODE = 'Y' THEN
1592: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options');
1593: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
1594: l_debug_mode := NVL(l_debug_mode, 'Y');
1595: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1596: END IF;

Line 2439: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options'

2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: x_msg_count := 1;
2437: x_msg_data := SQLERRM;
2438: FND_MSG_PUB.add_exc_msg
2439: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options'
2440: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2441: IF P_PA_DEBUG_MODE = 'Y' THEN
2442: pa_debug.write('Get_FP_Options: ' || l_module_name,SQLERRM,5);
2443: pa_debug.write('Get_FP_Options: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 2471: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID');

2467: l_debug_mode VARCHAR2(30);
2468:
2469: BEGIN
2470: IF P_PA_DEBUG_MODE = 'Y' THEN
2471: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID');
2472: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2473: l_debug_mode := NVL(l_debug_mode, 'Y');
2474: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2475: END IF;

Line 2537: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID'

2533: RETURN NULL;
2534:
2535: WHEN OTHERS THEN
2536: FND_MSG_PUB.add_exc_msg
2537: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_Parent_FP_Option_ID'
2538: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2539: IF P_PA_DEBUG_MODE = 'Y' THEN
2540: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,SQLERRM,5);
2541: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 2567: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID');

2563:
2564: BEGIN
2565:
2566: IF P_PA_DEBUG_MODE = 'Y' THEN
2567: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID');
2568: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2569: l_debug_mode := NVL(l_debug_mode, 'Y');
2570: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2571: END IF;

Line 2646: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID'

2642: RETURN NULL;
2643:
2644: WHEN OTHERS THEN
2645: FND_MSG_PUB.add_exc_msg
2646: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Option_ID'
2647: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
2648: IF P_PA_DEBUG_MODE = 'Y' THEN
2649: pa_debug.write('Get_FP_Option_ID: ' || l_module_name,SQLERRM,5);
2650: pa_debug.write('Get_FP_Option_ID: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 2700: l_fp_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;

2696: l_fin_plan_level_code CONSTANT pa_proj_fp_options.ALL_FIN_PLAN_LEVEL_CODE%TYPE := 'L';
2697: l_time_phased_code CONSTANT pa_proj_fp_options.ALL_TIME_PHASED_CODE%TYPE := 'N';
2698: l_factor_by_code CONSTANT pa_proj_fp_options.FACTOR_BY_CODE%TYPE := '1';
2699:
2700: l_fp_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_COLS;
2701:
2702: l_return_status VARCHAR2(2000);
2703: l_msg_count NUMBER := 0;
2704: l_msg_data VARCHAR2(2000);

Line 2782: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options');

2778:
2779: BEGIN
2780:
2781: IF P_PA_DEBUG_MODE = 'Y' THEN
2782: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options');
2783: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2784: l_debug_mode := NVL(l_debug_mode, 'Y');
2785: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2786: END IF;

Line 3542: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options'

3538: END IF;
3539: RAISE;
3540: WHEN OTHERS THEN
3541: FND_MSG_PUB.add_exc_msg
3542: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_Default_FP_Options'
3543: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
3544: IF P_PA_DEBUG_MODE = 'Y' THEN
3545: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,SQLERRM,5);
3546: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 3559: l_fp_mc_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;

3555: passed along with the approved_cost_plan_type_flag and approved_rev_plan_type_flag
3556: ===========================================================================================*/
3557: FUNCTION Get_FP_Proj_Mc_Options (p_proj_fp_options_id IN NUMBER) Return FP_MC_COLS
3558: IS
3559: l_fp_mc_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;
3560: BEGIN
3561:
3562: SELECT approved_cost_plan_type_flag
3563: ,approved_rev_plan_type_flag

Line 3594: l_fp_mc_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;

3590: FP Option ID passed along with approved_cost_plan_type_flag and approved_rev_plan_type_flag
3591: ===========================================================================================*/
3592: FUNCTION Get_FP_Plan_Type_Mc_Options (p_fin_plan_type_id IN NUMBER) Return FP_MC_COLS
3593: IS
3594: l_fp_mc_cols_rec PA_PROJ_FP_OPTIONS_PUB.FP_MC_COLS;
3595: BEGIN
3596: SELECT approved_cost_plan_type_flag
3597: ,approved_rev_plan_type_flag
3598: ,primary_cost_forecast_flag

Line 3696: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.SYNCHRONIZE_BUDGET_VERSION');

3692: BEGIN
3693:
3694: FND_MSG_PUB.initialize;
3695: IF P_PA_DEBUG_MODE = 'Y' THEN
3696: pa_debug.init_err_stack('PA_PROJ_FP_OPTIONS_PUB.SYNCHRONIZE_BUDGET_VERSION');
3697: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3698: l_debug_mode := NVL(l_debug_mode, 'Y');
3699: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3700: END IF;

Line 3943: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB'

3939: WHEN Others THEN
3940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3941: x_msg_count := 1;
3942: x_msg_data := SQLERRM;
3943: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB'
3944: ,p_procedure_name => 'SYNCHRONIZE_BUDGET_VERSION');
3945: IF P_PA_DEBUG_MODE = 'Y' THEN
3946: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;
3947: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,5);

Line 3993: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id');

3989:
3990: BEGIN
3991:
3992: IF P_PA_DEBUG_MODE = 'Y' THEN
3993: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id');
3994: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
3995: l_debug_mode := NVL(l_debug_mode, 'Y');
3996: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3997: END IF;

Line 4191: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id'

4187: END IF;
4188: RAISE;
4189: WHEN OTHERS THEN
4190: FND_MSG_PUB.add_exc_msg
4191: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Gen_Src_Plan_Version_Id'
4192: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4193: IF P_PA_DEBUG_MODE = 'Y' THEN
4194: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,SQLERRM,5);
4195: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 4317: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Gen_Src_WP_Version_Id'

4313: pa_debug.reset_curr_function;
4314: RAISE;
4315: WHEN OTHERS THEN
4316: FND_MSG_PUB.add_exc_msg
4317: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Gen_Src_WP_Version_Id'
4318: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
4319: IF P_PA_DEBUG_MODE = 'Y' THEN
4320: pa_debug.write('Gen_Src_WP_Version_Id: ' || l_module_name,SQLERRM,5);
4321: pa_debug.write('Gen_Src_WP_Version_Id: ' || l_module_name,pa_debug.G_Err_Stack,5);

Line 4358: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';

4354: l_revenue_layout_type_code VARCHAR2(30);
4355: l_all_layout_type_code VARCHAR2(30);
4356: l_debug_mode VARCHAR2(30);
4357: l_stage NUMBER := 100;
4358: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4359: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4360: l_msg_count NUMBER :=0;
4361: l_msg_data VARCHAR2(2000);
4362: l_data VARCHAR2(2000);

Line 4386: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_amt_types');

4382: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4383: p_debug_mode => l_debug_mode );
4384:
4385: IF P_PA_DEBUG_MODE = 'Y' THEN
4386: pa_debug.set_err_stack('PA_PROJ_FP_OPTIONS_PUB.Create_amt_types');
4387: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4388: l_debug_mode := NVL(l_debug_mode, 'Y');
4389: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4390: END IF;

Line 4780: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB' ||

4776: RAISE;
4777:
4778: WHEN OTHERS THEN
4779: FND_MSG_PUB.add_exc_msg
4780: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB' ||
4781: 'Create_amt_types'
4782: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4783: pa_debug.g_err_stage := 'Unexpected error in Create_amt_types:';
4784: pa_debug.write('Create_amt_types: ' || l_module_name,pa_debug.g_err_stage,5);

Line 4811: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub.copy_amt_types';

4807: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4808: ) IS
4809:
4810: l_stage NUMBER := 100;
4811: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub.copy_amt_types';
4812: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4813: --Start of variables used for debugging
4814: l_return_status VARCHAR2(1);
4815: l_msg_count NUMBER := 0;

Line 4915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'

4911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4912: x_msg_count := 1;
4913: x_msg_data := SQLERRM;
4914:
4915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'
4916: ,p_procedure_name => 'copy_amt_types');
4917:
4918: IF l_debug_mode = 'Y' THEN
4919: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 4943: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';

4939: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4940: ) IS
4941:
4942: l_stage NUMBER := 100;
4943: l_module_name VARCHAR2(100) := 'pa.plsql.pa_proj_fp_options_pub';
4944: P_PA_DEBUG_MODE VARCHAR2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
4945: --Start of variables used for debugging
4946: l_return_status VARCHAR2(1);
4947: l_msg_count NUMBER := 0;

Line 5163: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'

5159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5160: x_msg_count := 1;
5161: x_msg_data := SQLERRM;
5162:
5163: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'
5164: ,p_procedure_name => 'update_amt_types');
5165:
5166: IF l_debug_mode = 'Y' THEN
5167: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 5176: END PA_PROJ_FP_OPTIONS_PUB;

5172: RAISE;
5173:
5174: END update_amt_types;
5175:
5176: END PA_PROJ_FP_OPTIONS_PUB;