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_FP_CONSTANTS_PKG

Line 189: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

185: END IF;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
188: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
189: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
190:
191: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
192: l_stage := 300;
193: IF (p_target_plan_type_id IS NULL) THEN

Line 191: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN

187: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
188: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
189: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
190:
191: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
192: l_stage := 300;
193: IF (p_target_plan_type_id IS NULL) THEN
194: /* Plan Type ID cannot be NULL when Target Proj FP Option is NULL and Option Level
195: Code is PLAN_TYPE */

Line 203: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

199: END IF;
200: x_return_status := FND_API.G_RET_STS_ERROR;
201: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
202: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
203: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
204: END IF;
205: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
206: /* Plan Type ID and Pland Version ID cannot be NULL when the Option Level Code is
207: PLAN_VERSION. */

Line 205: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN

201: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
202: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
203: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
204: END IF;
205: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
206: /* Plan Type ID and Pland Version ID cannot be NULL when the Option Level Code is
207: PLAN_VERSION. */
208: l_stage := 320;
209: IF (p_target_plan_type_id IS NULL) THEN

Line 218: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

214: END IF;
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
217: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
218: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
219: ELSIF (p_target_fin_plan_version_id IS NULL) THEN
220: IF P_PA_DEBUG_MODE = 'Y' THEN
221: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Plan Version ID cannot be NULL.';
222: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);

Line 227: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

223: END IF;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
226: p_msg_name => 'PA_FP_INV_PARAM_PASSED' );
227: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
228: END IF;
229: END IF;
230:
231: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 279: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

275: END IF;
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
278: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
279: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
280: END IF;
281: ELSE
282: /* get this from source option. As the validation is already done source cannot be null
283: at this point */

Line 319: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

315: END IF;
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
318: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
319: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
320: END IF;
321:
322: IF (l_plan_type_id IS NOT NULL) THEN
323:

Line 350: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

346:
347: /* Added the following check for the NOCOPY changes. */
348:
349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
351: END IF;
352: /* populate fp_cols_rec */
353: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) AND
354: (p_target_plan_type_id IS NOT NULL) AND

Line 353: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) AND

349: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
350: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
351: END IF;
352: /* populate fp_cols_rec */
353: ELSIF (p_target_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) AND
354: (p_target_plan_type_id IS NOT NULL) AND
355: (plan_type_info_rec.use_for_workplan_flag = 'Y')
356: THEN
357: -- Control comes here if workplan plan type is being added for the project

Line 375: IF (l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN

371: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Target is null so Get higher level option';
372: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
373: END IF;
374:
375: IF (l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
376:
377: IF P_PA_DEBUG_MODE = 'Y' THEN
378: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': getting project level option';
379: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);

Line 383: ELSIF (l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN

379: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
380: END IF;
381:
382: l_par_Proj_FP_Options_ID := get_fp_option_id(p_target_project_id, NULL,NULL);
383: ELSIF (l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
384: IF P_PA_DEBUG_MODE = 'Y' THEN
385: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': getting plan type level option';
386: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
387: END IF;

Line 460: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

456:
457: /* Added the following check for the NOCOPY changes. */
458:
459: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
460: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
461: END IF;
462:
463: /* Bug # 2702000 */
464: IF l_baseline_funding_flag = 'Y' AND l_approved_rev_plan_type_flag = 'Y' THEN

Line 506: IF (l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT) AND

502: -- if target is ci version and source is version, genearation columns should be nulled out
503: -- if target is version and source is version, take care that gen src version id for target version is
504: -- not same as the target version if so null out the column (this could happen through copy_plan api)
505:
506: IF (l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT) AND
507: (nvl(plan_type_info_rec.use_for_workplan_flag,'N') <> 'Y')
508: THEN
509:
510: -- Fetch source option level code if null using parent option

Line 541: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN

537:
538: END IF;
539:
540: -- Target option plan type context
541: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN
542:
543: -- If source option is project
544: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN
545:

Line 544: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN

540: -- Target option plan type context
541: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN
542:
543: -- If source option is project
544: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN
545:
546: IF P_PA_DEBUG_MODE = 'Y' THEN
547: pa_debug.g_err_stage := 'inside target plan type and source project case if';
548: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);

Line 607: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

603: FP_Cols_Rec.def_bill_rate_currency_code := l_default_gen_options_rec.def_bill_rate_currency_code ;
604: --CBS
605: IF NVL(l_webadi_profile,'N') = 'Y' THEN
606:
607: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
608: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
609:
610: IF P_PA_DEBUG_MODE = 'Y' THEN
611: pa_debug.g_err_stage := 'inside cost only preference code FP_Cols_Rec.cost_time_phased_code :: '||FP_Cols_Rec.cost_time_phased_code;

Line 608: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN

604: --CBS
605: IF NVL(l_webadi_profile,'N') = 'Y' THEN
606:
607: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
608: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
609:
610: IF P_PA_DEBUG_MODE = 'Y' THEN
611: pa_debug.g_err_stage := 'inside cost only preference code FP_Cols_Rec.cost_time_phased_code :: '||FP_Cols_Rec.cost_time_phased_code;
612: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);

Line 633: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

629: FP_Cols_Rec.cost_layout_code := l_default_gen_options_rec.cost_layout_code;
630: END IF;
631: END IF;
632:
633: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
634: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
635:
636: IF FP_Cols_Rec.revenue_time_phased_code in ('G','P') THEN
637:

Line 634: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN

630: END IF;
631: END IF;
632:
633: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
634: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
635:
636: IF FP_Cols_Rec.revenue_time_phased_code in ('G','P') THEN
637:
638: IF plan_type_info_rec.plan_class_code = 'BUDGET' THEN

Line 648: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

644: FP_Cols_Rec.revenue_layout_code := l_default_gen_options_rec.revenue_layout_code ;
645: END IF;
646: END IF;
647:
648: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
649:
650: IF FP_Cols_Rec.all_time_phased_code in ('G','P') THEN
651: IF plan_type_info_rec.plan_class_code = 'BUDGET' THEN
652: FP_Cols_Rec.all_layout_code := 'PE_BUDGET';

Line 668: ELSIF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

664: END IF;
665:
666: END IF;
667:
668: ELSIF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
669: THEN
670:
671: -- Check if target is a control document
672:

Line 676: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;

672:
673: OPEN plan_version_info_cur(l_plan_version_id);
674: FETCH plan_version_info_cur INTO plan_version_info_rec;
675: IF plan_version_info_cur%NOTFOUND THEN
676: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
677: END IF;
678: CLOSE plan_version_info_cur;
679:
680: IF (plan_version_info_rec.ci_id IS NOT NULL) THEN

Line 756: IF (l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE AND

752: FP_Cols_Rec.copy_etc_from_plan_flag := null ; --bug#8318932
753: ELSE -- target is not ci version
754:
755: -- If source option is plan type
756: IF (l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE AND
757: nvl(plan_type_info_rec.use_for_workplan_flag,'N') <>'Y' )
758: THEN
759:
760: -- Gen Src Version Id should be initialized using Gen Src Version Code

Line 761: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND

757: nvl(plan_type_info_rec.use_for_workplan_flag,'N') <>'Y' )
758: THEN
759:
760: -- Gen Src Version Id should be initialized using Gen Src Version Code
761: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND
762: (FP_Cols_Rec.gen_src_cost_plan_type_id IS NOT NULL ) AND
763: (FP_Cols_Rec.gen_src_cost_plan_ver_code IS NOT NULL)
764: THEN
765:

Line 776: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND

772:
773: -- Null out generation source plan version code
774: FP_Cols_Rec.gen_src_cost_plan_ver_code := NULL;
775:
776: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND
777: (FP_Cols_Rec.gen_src_rev_plan_type_id IS NOT NULL ) AND
778: (FP_Cols_Rec.gen_src_rev_plan_ver_code IS NOT NULL)
779: THEN
780:

Line 791: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND

787:
788: -- Null out generation source plan version code
789: FP_Cols_Rec.gen_src_rev_plan_ver_code := NULL;
790:
791: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND
792: (FP_Cols_Rec.gen_src_all_plan_type_id IS NOT NULL ) AND
793: (FP_Cols_Rec.gen_src_all_plan_ver_code IS NOT NULL)
794: THEN
795:

Line 808: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND

804: FP_Cols_Rec.gen_src_all_plan_ver_code := NULL;
805: END IF;
806:
807: -- Gen Src Workplan Version Id should be initialized using Gen Src Wp version code
808: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND
809: (FP_Cols_Rec.gen_src_cost_wp_ver_code IS NOT NULL)
810: THEN
811:
812: -- Call private method fetch Gen_Src_WP_Version_Id

Line 820: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND

816:
817: -- Null out generation source workplan version code
818: FP_Cols_Rec.gen_src_cost_wp_ver_code := NULL;
819:
820: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND
821: (FP_Cols_Rec.gen_src_rev_wp_ver_code IS NOT NULL)
822: THEN
823:
824: -- Call private method fetch Gen_Src_WP_Version_Id

Line 832: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND

828:
829: -- Null out generation source workplan version code
830: FP_Cols_Rec.gen_src_rev_wp_ver_code := NULL;
831:
832: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND
833: (FP_Cols_Rec.gen_src_all_wp_ver_code IS NOT NULL)
834: THEN
835:
836: -- Call private method fetch Gen_Src_WP_Version_Id

Line 844: ELSIF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

840:
841: -- Null out generation source workplan version code
842: FP_Cols_Rec.gen_src_all_wp_ver_code := NULL;
843: END IF;
844: ELSIF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
845: THEN
846:
847: -- 3/28/2004 FP M Phase II Dev Effort Copy Project Impact
848: IF l_source_project_id <> p_target_project_id

Line 865: END IF; -- l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT

861: END IF; -- target version is ci/other kind of version
862:
863: END IF; -- l_target_option_level_code
864:
865: END IF; -- l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT
866:
867: -- End of FP M Dev effort
868:
869: /* MC Options need to be copied only in the context of plan type or plan version.

Line 872: IF l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN

868:
869: /* MC Options need to be copied only in the context of plan type or plan version.
870: The logic of copying mc options is common and hence done outside all IFs. */
871:
872: IF l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN
873: /* While copying project, the MC options should be inherited from the source option
874: i.e., from the source project's plan type or plan version */
875: IF p_source_proj_fp_option_id IS NOT NULL THEN
876: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 891: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN

887:
888: ELSE
889: /* MC Options are always inherited from the Plan Type MC options. In this case
890: plan type id cannot be null (validation done) */
891: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN
892: IF P_PA_DEBUG_MODE = 'Y' THEN
893: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': getting mc options from plan type';
894: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
895: END IF;

Line 921: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

917: END IF;
918: END IF;
919: /* Bug# 2637789 */
920: /* Bug 2747255 - Set the Cost conv attributes null if pref cost is REVENUE_ONLY and vice versa */
921: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
922: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := 'N';
923: FP_Mc_Cols_Rec.primary_rev_forecast_flag := 'N';
924: FP_Mc_Cols_Rec.project_rev_rate_type := Null;
925: FP_Mc_Cols_Rec.project_rev_rate_date_type := Null;

Line 930: ELSIF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

926: FP_Mc_Cols_Rec.project_rev_rate_date := Null;
927: FP_Mc_Cols_Rec.projfunc_rev_rate_type := Null;
928: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := Null;
929: FP_Mc_Cols_Rec.projfunc_rev_rate_date := Null;
930: ELSIF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
931: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := 'N';
932: FP_Mc_Cols_Rec.primary_cost_forecast_flag := 'N';
933: FP_Mc_Cols_Rec.projfunc_cost_rate_type := Null;
934: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := Null;

Line 1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

1025: END IF;
1026:
1027: /* Bug 3149010 - Logic of not overwritting attribs when the target is ALL */
1028:
1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;

Line 1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1026:
1027: /* Bug 3149010 - Logic of not overwritting attribs when the target is ALL */
1028:
1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;

Line 1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND

1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;

Line 1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;

Line 1072: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND

1068: existing version do not over write primary forecast columns, rate schedule
1069: setup if target is AR version, generation options set up if plan class codes
1070: differ for source and target versions
1071: */
1072: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1073: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1074:
1075: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;

Line 1073: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN

1069: setup if target is AR version, generation options set up if plan class codes
1070: differ for source and target versions
1071: */
1072: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1073: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1074:
1075: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1077:

Line 1459: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

1455: -- End, jwhite, 26-JUN-2003: Plannable Task Effort --------------------------------
1456:
1457: --Adding the code for attaching the layout codes to the plan type if they are being attached from a project or from a plan type.
1458: --For the ms-excel options tab
1459: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
1460: AND (nvl(plan_type_info_rec.use_for_workplan_flag,'N') <> 'Y') THEN
1461:
1462: IF NVL(l_webadi_profile,'N') = 'Y' THEN
1463:

Line 1477: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1473: ,x_msg_count => x_msg_count
1474: ,x_msg_data => x_msg_data);
1475:
1476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1477: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1478: END IF;
1479:
1480: ELSE
1481: copy_amt_types (

Line 1492: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1488: ,x_msg_data => x_msg_data );
1489:
1490:
1491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1492: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1493: END IF;
1494: END IF; -- source project is null
1495: END IF; -- web adi profile
1496: END IF;

Line 1505: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1501: pa_debug.reset_err_stack;
1502: END IF;
1503:
1504: EXCEPTION
1505: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1506: l_msg_count := FND_MSG_PUB.count_msg;
1507: IF l_msg_count = 1 THEN
1508: PA_INTERFACE_UTILS_PUB.get_messages
1509: (p_encoded => FND_API.G_TRUE,

Line 1644: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND

1640: REVENUE_ONLY COST_ONLY
1641: */
1642:
1643: /* M22-AUG: these validations are not required. These are not invalid combinations.
1644: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

Line 1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR

1641: */
1642:
1643: /* M22-AUG: these validations are not required. These are not invalid combinations.
1644: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

Line 1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND

1643: /* M22-AUG: these validations are not required. These are not invalid combinations.
1644: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR

Line 1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

1644: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR
1652: */

Line 1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

1645: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR
1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

Line 1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))

1646:
1647: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1648: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR
1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR

Line 1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

1649: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR
1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1655: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1656: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1657:

Line 1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR

1650: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1651: OR
1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1655: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1656: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1657:
1658: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1655: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND

1651: OR
1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1655: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1656: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1657:
1658: IF P_PA_DEBUG_MODE = 'Y' THEN
1659: pa_debug.g_err_stage := 'Err- Invalid Combination of Source and Target Preference code';

Line 1656: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN

1652: */
1653: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1654: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1655: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1656: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1657:
1658: IF P_PA_DEBUG_MODE = 'Y' THEN
1659: pa_debug.g_err_stage := 'Err- Invalid Combination of Source and Target Preference code';
1660: pa_debug.write('Get_FP_Options: ' || l_module_name,pa_debug.g_err_stage,5);

Line 1665: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1661: END IF;
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1664: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1665: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1666:
1667: END IF;
1668:
1669: -- Initializing all the cost/quantity flags to 'N'

Line 1692: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1688: amount set flags as the case may be for the target option which is having the pref
1689: code as Null */
1690:
1691: IF p_target_fp_options_id IS NOT NULL AND
1692: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1693:
1694: IF P_PA_DEBUG_MODE = 'Y' THEN
1695: pa_debug.g_err_stage := 'Inside target opt id not null ' || p_target_fp_options_id ||
1696: ' and target pref code is ALL';

Line 1814: IF ( l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

1810: l_cost_amount_set_id := null;
1811: l_revenue_amount_set_id := null;
1812: l_all_amount_set_id := null;
1813:
1814: IF ( l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
1815:
1816: /* If the FP Preference Code is Cost and Revenue Separately, then the
1817: COST and REVENUE columns have to be returned for all the valid combinations
1818: of Source and Target Fin_Plan_Preference_Code.

Line 1844: ,nvl(report_labor_hrs_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) report_labor_hrs_from_code

1840: ,revenue_resource_list_id
1841: ,NULL all_fin_plan_level_code
1842: ,NULL all_time_phased_code
1843: ,NULL all_resource_list_id
1844: ,nvl(report_labor_hrs_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) report_labor_hrs_from_code
1845: ,plan_in_multi_curr_flag
1846: ,factor_by_code
1847: ,default_amount_type_code
1848: ,default_amount_subtype_code

Line 1927: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,cost_layout_code,null)

1923: ,NULL gen_src_all_wp_version_id
1924: ,NULL gen_src_all_wp_ver_code
1925: -- end of FP M dev phase II changes
1926: -- Added for ms-excel options in webadi
1927: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,cost_layout_code,null)
1928: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,revenue_layout_code,null)
1929: ,NULL all_layout_code
1930: ,revenue_derivation_method -- Bug 5462471
1931: ,copy_etc_from_plan_flag -- bug#8318932

Line 1928: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,revenue_layout_code,null)

1924: ,NULL gen_src_all_wp_ver_code
1925: -- end of FP M dev phase II changes
1926: -- Added for ms-excel options in webadi
1927: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,cost_layout_code,null)
1928: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,revenue_layout_code,null)
1929: ,NULL all_layout_code
1930: ,revenue_derivation_method -- Bug 5462471
1931: ,copy_etc_from_plan_flag -- bug#8318932
1932: ,default_raw_cost --CBS

Line 1943: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN

1939: WHERE proj_fp_options_id = p_proj_fp_options_id;
1940:
1941: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
1942:
1943: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN
1944:
1945: /* If the FP Preference Code is COST_ONLY, only the Cost Columns have to be sent
1946: and the other columns have to be returned as NULL. */
1947:

Line 1981: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1977: ,x_message_data => l_msg_data);
1978:
1979: --added for bug 2708782
1980: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1981: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1982: END IF;
1983:
1984: IF P_PA_DEBUG_MODE = 'Y' THEN
1985: pa_debug.g_err_stage := 'Target Fin Plan Pref Code is Cost Only.';

Line 2011: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code

2007: ,plan_in_multi_curr_flag plan_in_multi_curr_flag
2008: ,factor_by_code factor_by_code
2009: ,default_amount_type_code default_amount_type_code
2010: ,default_amount_subtype_code default_amount_subtype_code
2011: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code
2012: /* Bug 2920954 start of new record parameters for post fp-k oneoff patch */
2013: ,nvl(select_cost_res_auto_flag, select_all_res_auto_flag) select_cost_res_auto_flag
2014: ,NULL cost_res_planning_level
2015: ,NULL select_rev_res_auto_flag

Line 2096: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(cost_layout_code, all_layout_code ),null) cost_layout_code

2092: ,NULL gen_src_all_wp_version_id
2093: ,NULL gen_src_all_wp_ver_code
2094: -- end of FP M dev phase II changes
2095: -- Added for ms-excel options in webadi
2096: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(cost_layout_code, all_layout_code ),null) cost_layout_code
2097: ,NULL revenue_layout_code
2098: ,NULL all_layout_code
2099: ,NULL -- Bug 5462471 For cost only version revenue_derivation_method should be null always
2100: ,copy_etc_from_plan_flag --bug#8318932

Line 2115: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN

2111:
2112:
2113: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2114:
2115: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
2116:
2117: /* If the FP Preference Code is REVENUE_ONLY, only the Revenue Columns have to be sent
2118: and the other columns have to be returned as NULL. */
2119:

Line 2153: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2149: ,x_return_status => x_return_status
2150: ,x_message_data => l_msg_data);
2151:
2152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2153: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2154: END IF;
2155:
2156: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2157:

Line 2262: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(revenue_layout_code, all_layout_code ) ,null) revenue_layout_code

2258: ,NULL gen_src_all_wp_ver_code
2259: -- end of FP M dev phase II changes
2260: -- Added for ms-excel options in webadi
2261: ,NULL cost_layout_code
2262: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(revenue_layout_code, all_layout_code ) ,null) revenue_layout_code
2263: ,NULL all_layout_code
2264: ,revenue_derivation_method -- Bug 5462471
2265: ,NULL copy_etc_from_plan_flag -- bug 8318932
2266: ,default_raw_cost --CBS

Line 2277: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN

2273: WHERE proj_fp_options_id = p_proj_fp_options_id;
2274:
2275: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2276:
2277: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
2278:
2279: /* If the FP Preference Code is COST_AND_REV_SAME, only the "all" Columns have to be sent
2280: and the other columns have to be returned as NULL. */
2281:

Line 2316: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2312: ,x_message_data => l_msg_data);
2313:
2314: --added for bug 2708782
2315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2316: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2317: END IF;
2318:
2319: IF P_PA_DEBUG_MODE = 'Y' THEN
2320: pa_debug.g_err_stage := 'Target Fin Plan Pref Code is Cost and Revenue together.';

Line 2343: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code

2339: ,plan_in_multi_curr_flag plan_in_multi_curr_flag
2340: ,factor_by_code factor_by_code
2341: ,default_amount_type_code default_amount_type_code
2342: ,default_amount_subtype_code default_amount_subtype_code /* manoj */
2343: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code
2344: /* Bug 2920954 start of new record parameters for post fp-k oneoff patch */
2345: ,NULL select_cost_res_auto_flag
2346: ,NULL cost_res_planning_level
2347: ,NULL select_rev_res_auto_flag

Line 2439: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(cost_layout_code, nvl(revenue_layout_code ,all_layout_code)) ,null) all_layout_code

2435: -- end of FP M dev phase II changes
2436: -- Added for ms-excel options in webadi
2437: ,NULL cost_layout_code
2438: ,NULL revenue_layout_code
2439: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,nvl(cost_layout_code, nvl(revenue_layout_code ,all_layout_code)) ,null) all_layout_code
2440: ,revenue_derivation_method -- Bug 5462471
2441: ,NULL copy_etc_from_plan_flag--bug#8318932
2442: ,default_raw_cost --CBS
2443: ,default_bill_rate --CBS

Line 2460: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2456: pa_debug.reset_err_stack;
2457: END IF;
2458:
2459: EXCEPTION
2460: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2461: l_msg_count := FND_MSG_PUB.count_msg;
2462: IF l_msg_count = 1 THEN
2463: PA_INTERFACE_UTILS_PUB.get_messages
2464: (p_encoded => FND_API.G_TRUE,

Line 2530: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN

2526:
2527: /* To get the Parent Option of a PLAN_VERSION, PLAN_TYPE option for the
2528: Project and Plan Type has to be selected. */
2529:
2530: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2531:
2532: IF P_PA_DEBUG_MODE = 'Y' THEN
2533: pa_debug.g_err_stage := 'Option Level Code is PLAN_VERSION.';
2534: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2540: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

2536:
2537: SELECT proj_fp_options_id
2538: INTO x_proj_fp_options_id
2539: FROM pa_proj_fp_options
2540: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
2541: AND project_id = l_proj_id
2542: AND fin_plan_type_id = l_fp_type_id;
2543:
2544: /* To get the Parent Option of a PLAN_TYPE, PROJECT option for the

Line 2552: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN

2548: pa_debug.g_err_stage := 'Option Level Code is PLAN_TYPE.';
2549: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,pa_debug.g_err_stage,3);
2550: END IF;
2551:
2552: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2553: SELECT proj_fp_options_id
2554: INTO x_proj_fp_options_id
2555: FROM pa_proj_fp_options
2556: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT

Line 2556: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT

2552: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2553: SELECT proj_fp_options_id
2554: INTO x_proj_fp_options_id
2555: FROM pa_proj_fp_options
2556: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT
2557: AND project_id = l_proj_id;
2558:
2559: END IF;
2560:

Line 2628: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;

2624:
2625: IF p_project_id IS NOT NULL THEN
2626: IF p_plan_type_id IS NOT NULL THEN
2627: IF p_plan_version_id IS NOT NULL THEN
2628: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2629: ELSE
2630: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2631: END IF;
2632: ELSE

Line 2630: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

2626: IF p_plan_type_id IS NOT NULL THEN
2627: IF p_plan_version_id IS NOT NULL THEN
2628: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2629: ELSE
2630: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2631: END IF;
2632: ELSE
2633: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2634: END IF;

Line 2633: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;

2629: ELSE
2630: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2631: END IF;
2632: ELSE
2633: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2634: END IF;
2635: END IF;
2636:
2637: /* Following are the Select statements to get the Proj_FP_Options_ID depending on the Option Level

Line 2642: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT) THEN

2638: Code. If the Option_Level_Code is Project, then only Project_ID has to be checked for. For
2639: 'Plan_Type', both Project_ID and Plan_Type_ID have to be checked and for PLAN_VERSION, all the
2640: three - Project_ID,Plan_Type_ID,Plan_Version_ID have to be checked for. */
2641:
2642: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT) THEN
2643:
2644: SELECT proj_fp_options_id
2645: INTO x_proj_fp_options_id
2646: FROM pa_proj_fp_options

Line 2648: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;

2644: SELECT proj_fp_options_id
2645: INTO x_proj_fp_options_id
2646: FROM pa_proj_fp_options
2647: WHERE project_id = p_project_id
2648: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2649:
2650: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2651:
2652: SELECT proj_fp_options_id

Line 2650: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN

2646: FROM pa_proj_fp_options
2647: WHERE project_id = p_project_id
2648: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2649:
2650: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2651:
2652: SELECT proj_fp_options_id
2653: INTO x_proj_fp_options_id
2654: FROM pa_proj_fp_options

Line 2657: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

2653: INTO x_proj_fp_options_id
2654: FROM pa_proj_fp_options
2655: WHERE project_id = p_project_id
2656: AND fin_plan_type_id = p_plan_type_id
2657: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2658:
2659: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2660:
2661: SELECT proj_fp_options_id

Line 2659: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN

2655: WHERE project_id = p_project_id
2656: AND fin_plan_type_id = p_plan_type_id
2657: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2658:
2659: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2660:
2661: SELECT proj_fp_options_id
2662: INTO x_proj_fp_options_id
2663: FROM pa_proj_fp_options

Line 2667: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;

2663: FROM pa_proj_fp_options
2664: WHERE project_id = p_project_id
2665: AND fin_plan_type_id = p_plan_type_id
2666: AND fin_plan_version_id = p_plan_version_id
2667: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2668:
2669: END IF;
2670:
2671: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2847: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2843: IF p_plan_type_id IS NOT NULL THEN
2844: OPEN plan_type_info_cur (p_plan_type_id);
2845: FETCH plan_type_info_cur INTO plan_type_info_rec;
2846: IF plan_type_info_cur%NOTFOUND THEN
2847: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2848: END IF;
2849: CLOSE plan_type_info_cur;
2850: END IF;
2851:

Line 2875: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2871: WHEN NO_DATA_FOUND THEN
2872: IF P_PA_DEBUG_MODE = 'Y' THEN
2873: pa_debug.g_err_stage := 'No uncat resource list found corresponding to the org_id';
2874: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);
2875: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2876: END IF;
2877: END;
2878:
2879: PA_FIN_PLAN_UTILS.GET_OR_CREATE_AMOUNT_SET_ID(

Line 2899: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2895: X_MESSAGE_DATA => l_msg_data);
2896:
2897: --added for bug 2708782
2898: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2899: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2900: END IF;
2901:
2902: /* Following code is added in context of autobaseline */
2903: /* Bug#2619022 */

Line 2958: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2954: || to_char(l_err_code) || ':Err_stage:' || l_err_stage
2955: || ':Err_stack' || l_err_stack;
2956: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,5);
2957: END IF;
2958: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2959: END IF;
2960:
2961: IF l_proj_level_funding = 'P' THEN
2962: l_rev_fin_plan_level_code := 'P';

Line 2990: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

2986: , x_return_status => l_return_status);
2987:
2988: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2989: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
2990: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2991: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2992: END IF;
2993:
2994: -- If the project and project func currencies aren't equal

Line 2991: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2987:
2988: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2989: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
2990: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2991: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2992: END IF;
2993:
2994: -- If the project and project func currencies aren't equal
2995: -- set the multi currency flag to 'Y'

Line 3033: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN

3029:
3030: -- Initialize plan settings tab related values that are preferene code
3031: -- dependent
3032:
3033: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN
3034:
3035: IF P_PA_DEBUG_MODE = 'Y' THEN
3036: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost Only.';
3037: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3045: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;

3041: l_fp_cols_rec.cost_fin_plan_level_code := l_fin_plan_level_code;
3042: l_fp_cols_rec.cost_time_phased_code := l_time_phased_code;
3043: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
3044:
3045: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3046: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3047: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3048:
3049: IF p_plan_type_id IS NOT NULL THEN

Line 3046: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;

3042: l_fp_cols_rec.cost_time_phased_code := l_time_phased_code;
3043: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
3044:
3045: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3046: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3047: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3048:
3049: IF p_plan_type_id IS NOT NULL THEN
3050: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;

Line 3047: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;

3043: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
3044:
3045: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3046: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3047: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3048:
3049: IF p_plan_type_id IS NOT NULL THEN
3050: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3051: END IF;

Line 3050: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;

3046: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3047: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3048:
3049: IF p_plan_type_id IS NOT NULL THEN
3050: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3051: END IF;
3052:
3053: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
3054:

Line 3053: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN

3049: IF p_plan_type_id IS NOT NULL THEN
3050: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3051: END IF;
3052:
3053: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
3054:
3055: IF P_PA_DEBUG_MODE = 'Y' THEN
3056: pa_debug.g_err_stage := 'Fin Plan Preference code is Revenue Only.';
3057: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3065: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

3061: l_fp_cols_rec.revenue_fin_plan_level_code := l_rev_fin_plan_level_code;
3062: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3063: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3064:
3065: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3066: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3067: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3068:
3069: --Bug 5462471

Line 3066: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;

3062: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3063: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3064:
3065: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3066: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3067: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3068:
3069: --Bug 5462471
3070: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);

Line 3067: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;

3063: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3064:
3065: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3066: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3067: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3068:
3069: --Bug 5462471
3070: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);
3071:

Line 3088: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN

3084: IF p_plan_type_id IS NOT NULL THEN
3085: l_fp_cols_rec.margin_derived_from_code := null; -- not applicable in this case
3086: END IF;
3087:
3088: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
3089:
3090: IF P_PA_DEBUG_MODE = 'Y' THEN
3091: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost and Revenue together.';
3092: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3100: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;

3096: l_fp_cols_rec.all_fin_plan_level_code := l_fin_plan_level_code;
3097: l_fp_cols_rec.all_time_phased_code := l_time_phased_code;
3098: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3099:
3100: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3101: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3102: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3103:
3104: --Bug 5462471

Line 3101: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;

3097: l_fp_cols_rec.all_time_phased_code := l_time_phased_code;
3098: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3099:
3100: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3101: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3102: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3103:
3104: --Bug 5462471
3105: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);

Line 3102: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;

3098: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3099:
3100: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3101: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3102: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3103:
3104: --Bug 5462471
3105: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);
3106:

Line 3120: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;

3116:
3117:
3118:
3119: IF p_plan_type_id IS NOT NULL THEN
3120: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3121: END IF;
3122:
3123: ELSIF ( p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
3124:

Line 3123: ELSIF ( p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

3119: IF p_plan_type_id IS NOT NULL THEN
3120: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3121: END IF;
3122:
3123: ELSIF ( p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
3124:
3125: IF P_PA_DEBUG_MODE = 'Y' THEN
3126: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost and Revenue separately.';
3127: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

Line 3140: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;

3136: l_fp_cols_rec.revenue_fin_plan_level_code := l_rev_fin_plan_level_code;
3137: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3138: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3139:
3140: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3141: l_fp_cols_rec.default_amount_type_code := null; /* Open Issue */
3142: l_fp_cols_rec.default_amount_subtype_code := null; /* Open Issue */
3143:
3144: --Bug 5462471

Line 3159: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;

3155: end if;
3156:
3157:
3158: IF p_plan_type_id IS NOT NULL THEN
3159: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3160: END IF;
3161:
3162: END IF;
3163:

Line 3187: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR

3183: IF (p_plan_type_id IS NOT NULL) AND (plan_type_info_rec.use_for_workplan_flag <> 'Y' ) THEN
3184:
3185: -- For both cost and cost and rev sep cases, cost generation options should be defaulted
3186:
3187: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
3188: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3189: THEN
3190:
3191: -- Separate processing based on plan class code

Line 3188: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )

3184:
3185: -- For both cost and cost and rev sep cases, cost generation options should be defaulted
3186:
3187: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
3188: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3189: THEN
3190:
3191: -- Separate processing based on plan class code
3192: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

Line 3192: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

3188: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3189: THEN
3190:
3191: -- Separate processing based on plan class code
3192: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3193: THEN
3194:
3195: IF P_PA_DEBUG_MODE = 'Y' THEN
3196: pa_debug.g_err_stage := 'fetching generation columns for cost';

Line 3309: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) OR

3305:
3306: END IF; -- End of BUDGET/FORECAST
3307: END IF; -- cost or cost and rev sep case
3308:
3309: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) OR
3310: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3311: THEN
3312:
3313: -- Separate processing based on plan class code

Line 3310: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )

3306: END IF; -- End of BUDGET/FORECAST
3307: END IF; -- cost or cost and rev sep case
3308:
3309: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) OR
3310: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3311: THEN
3312:
3313: -- Separate processing based on plan class code
3314: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

Line 3314: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

3310: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3311: THEN
3312:
3313: -- Separate processing based on plan class code
3314: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3315: THEN
3316:
3317: -- Estimate to completion source code should be null
3318:

Line 3403: IF p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

3399: WHERE ROWNUM = 1;
3400: Exception
3401: When NO_DATA_FOUND then
3402: -- Bug 3666398 revenue-only plan type can not be generation source
3403: IF p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
3404: -- When there is no other plan type set to the same plan type id being created
3405: l_fp_cols_rec.gen_src_rev_plan_type_id := p_plan_type_id;
3406: l_fp_cols_rec.gen_src_rev_plan_ver_code := 'CURRENT_BASELINED'; -- Bug 3572548
3407: END IF;

Line 3426: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)

3422: Raise;
3423: End;
3424: END IF; -- revenue or cost and rev sep
3425:
3426: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)
3427: THEN
3428:
3429: -- Separate processing based on plan class code
3430: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

Line 3430: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

3426: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)
3427: THEN
3428:
3429: -- Separate processing based on plan class code
3430: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3431: THEN
3432:
3433: -- Estimate to completion source code should be null
3434:

Line 3564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3560:
3561: RETURN l_fp_cols_rec;
3562:
3563: EXCEPTION
3564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3565: l_msg_count := FND_MSG_PUB.count_msg;
3566: IF l_msg_count = 1 THEN
3567: PA_INTERFACE_UTILS_PUB.get_messages
3568: (p_encoded => FND_API.G_TRUE

Line 3767: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3763:
3764: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
3765: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3766:
3767: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3768:
3769: END IF;
3770:
3771: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3783: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3779:
3780: OPEN version_option_info_cur;
3781: FETCH version_option_info_cur INTO version_option_info_rec;
3782: IF version_option_info_cur%NOTFOUND THEN
3783: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3784: END IF;
3785: CLOSE version_option_info_cur;
3786:
3787:

Line 3835: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,

3831:
3832:
3833: -- obtain the period type corresponding to the time phased code
3834: select decode(l_time_phased_code,
3835: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3836: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,l_time_phased_code)
3837: into l_curr_period_type
3838: from dual;
3839:

Line 3836: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,l_time_phased_code)

3832:
3833: -- obtain the period type corresponding to the time phased code
3834: select decode(l_time_phased_code,
3835: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3836: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,l_time_phased_code)
3837: into l_curr_period_type
3838: from dual;
3839:
3840: --Select the period profile for this version. Get the period profile period type

Line 3864: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3860:
3861: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
3862: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3863:
3864: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3865: END;
3866:
3867: IF P_PA_DEBUG_MODE = 'Y' THEN
3868: pa_debug.g_err_stage := 'Determine if period profile to be updated.If yes get the id';

Line 3873: IF (l_curr_period_type in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,

3869: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,3);
3870: END IF;
3871:
3872: IF (l_period_profile_id is NULL) THEN
3873: IF (l_curr_period_type in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3874: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3875:
3876: pa_prj_period_profile_utils.get_curr_period_profile_info(
3877: p_project_id => l_project_id

Line 3874: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN

3870: END IF;
3871:
3872: IF (l_period_profile_id is NULL) THEN
3873: IF (l_curr_period_type in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3874: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3875:
3876: pa_prj_period_profile_utils.get_curr_period_profile_info(
3877: p_project_id => l_project_id
3878: ,p_period_type => l_curr_period_type

Line 3879: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING

3875:
3876: pa_prj_period_profile_utils.get_curr_period_profile_info(
3877: p_project_id => l_project_id
3878: ,p_period_type => l_curr_period_type
3879: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING
3880: ,x_period_profile_id => l_curr_period_profile_id
3881: ,x_start_period => l_start_period
3882: ,x_end_period => l_end_period
3883: ,x_return_status => l_return_status

Line 3898: IF (l_curr_period_type not in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,

3894: END IF; -- check for period type.
3895:
3896: ELSE -- period profile id is not null
3897:
3898: IF (l_curr_period_type not in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3899: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3900:
3901: l_curr_period_profile_id := NULL;
3902: l_update_flag := 'Y';

Line 3899: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN

3895:
3896: ELSE -- period profile id is not null
3897:
3898: IF (l_curr_period_type not in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3899: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3900:
3901: l_curr_period_profile_id := NULL;
3902: l_update_flag := 'Y';
3903:

Line 3929: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING

3925:
3926: pa_prj_period_profile_utils.get_curr_period_profile_info(
3927: p_project_id => l_project_id
3928: ,p_period_type => l_curr_period_type
3929: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING
3930: ,x_period_profile_id => l_curr_period_profile_id
3931: ,x_start_period => l_start_period
3932: ,x_end_period => l_end_period
3933: ,x_return_status => l_return_status

Line 3961: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3957: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,2);
3958: pa_debug.reset_err_stack;
3959: END IF;
3960: EXCEPTION
3961: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3962: l_msg_count := FND_MSG_PUB.count_msg;
3963: IF l_msg_count = 1 THEN
3964: PA_INTERFACE_UTILS_PUB.get_messages
3965: (p_encoded => FND_API.G_TRUE

Line 4060: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4056:
4057: OPEN src_plan_type_info_cur(p_gen_src_plan_type_id, p_target_project_id);
4058: FETCH src_plan_type_info_cur INTO src_plan_type_info_rec;
4059: IF src_plan_type_info_cur%NOTFOUND THEN
4060: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4061: END IF;
4062: CLOSE src_plan_type_info_cur;
4063:
4064: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 4071: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR

4067: pa_debug.g_err_stage:='src_plan_type_info_rec.fin_plan_preference_code = = '||src_plan_type_info_rec.fin_plan_preference_code;
4068: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,pa_debug.g_err_stage,5);
4069: END IF;
4070:
4071: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4072: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4073: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4074: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4075: THEN

Line 4072: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR

4068: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,pa_debug.g_err_stage,5);
4069: END IF;
4070:
4071: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4072: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4073: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4074: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4075: THEN
4076: -- For all these cases, preference code need not be passed as they

Line 4074: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )

4070:
4071: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4072: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4073: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4074: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4075: THEN
4076: -- For all these cases, preference code need not be passed as they
4077: -- can be derived in the called util apis
4078:

Line 4092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4088: ,x_return_status => l_return_status
4089: ,x_msg_count => l_msg_count
4090: ,x_msg_data => l_msg_data );
4091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4093: END IF;
4094:
4095: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4096:

Line 4108: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4104: ,x_return_status => l_return_status
4105: ,x_msg_count => l_msg_count
4106: ,x_msg_data => l_msg_data );
4107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4108: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4109: END IF;
4110:
4111: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4112:

Line 4124: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4120: ,x_return_status => l_return_status
4121: ,x_msg_count => l_msg_count
4122: ,x_msg_data => l_msg_data );
4123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4124: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4125: END IF;
4126:
4127: END IF; -- p_gen_src_plan_ver_code
4128:

Line 4156: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4152: ,x_return_status => l_return_status
4153: ,x_msg_count => l_msg_count
4154: ,x_msg_data => l_msg_data );
4155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4156: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4157: END IF;
4158:
4159: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4160:

Line 4172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4168: ,x_return_status => l_return_status
4169: ,x_msg_count => l_msg_count
4170: ,x_msg_data => l_msg_data );
4171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4173: END IF;
4174:
4175: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4176:

Line 4188: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4184: ,x_return_status => l_return_status
4185: ,x_msg_count => l_msg_count
4186: ,x_msg_data => l_msg_data );
4187: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4188: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4189: END IF;
4190:
4191: END IF; -- p_gen_src_plan_ver_code
4192:

Line 4213: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4209: pa_debug.reset_err_stack;
4210: END IF;
4211:
4212: EXCEPTION
4213: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4214: l_msg_count := FND_MSG_PUB.count_msg;
4215: IF l_msg_count = 1 THEN
4216: PA_INTERFACE_UTILS_PUB.get_messages
4217: (p_encoded => FND_API.G_TRUE

Line 4339: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4335:
4336: RETURN l_gen_src_wp_ver_id;
4337:
4338: EXCEPTION
4339: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4340: l_msg_count := FND_MSG_PUB.count_msg;
4341: IF l_msg_count = 1 THEN
4342: PA_INTERFACE_UTILS_PUB.get_messages
4343: (p_encoded => FND_API.G_TRUE

Line 4450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4446: x_return_status := FND_API.G_RET_STS_ERROR;
4447: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4448: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4449: PA_DEBUG.Reset_Curr_Function;
4450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4451: END IF;
4452:
4453: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4454: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES

Line 4472: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

4468:
4469:
4470: --populating the seeded views
4471:
4472: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
4473: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4474:
4475: BEGIN
4476: IF p_cost_layout_code IS NULL THEN

Line 4473: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

4469:
4470: --populating the seeded views
4471:
4472: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
4473: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4474:
4475: BEGIN
4476: IF p_cost_layout_code IS NULL THEN
4477:

Line 4482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4478: x_return_status := FND_API.G_RET_STS_ERROR;
4479: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4480: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4481: PA_DEBUG.Reset_Curr_Function;
4482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4483: ELSE
4484: OPEN layout_details_cur FOR l_sql USING p_cost_layout_code;
4485: FETCH layout_details_cur INTO l_integrator_code;
4486:

Line 4515: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4511: -- ,x_msg_data => l_msg_data );
4512: --
4513: --
4514: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4515: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4516: -- END IF;
4517: END IF;
4518: IF l_cost_layout_type_code = 'PERIODIC_BUDGET' THEN
4519:

Line 4539: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

4535: END IF;
4536: END;
4537: END IF;
4538:
4539: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
4540: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4541:
4542: BEGIN
4543: IF p_revenue_layout_code IS NULL THEN

Line 4540: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

4536: END;
4537: END IF;
4538:
4539: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
4540: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4541:
4542: BEGIN
4543: IF p_revenue_layout_code IS NULL THEN
4544:

Line 4549: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4545: x_return_status := FND_API.G_RET_STS_ERROR;
4546: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4547: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4548: PA_DEBUG.Reset_Curr_Function;
4549: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4550: ELSE
4551: OPEN layout_details_cur FOR l_sql USING p_revenue_layout_code;
4552: FETCH layout_details_cur INTO l_integrator_code;
4553:

Line 4574: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4570: -- ,x_msg_count => l_msg_count
4571: -- ,x_msg_data => l_msg_data );
4572: --
4573: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4574: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4575: -- END IF;
4576: END IF;
4577: IF l_revenue_layout_type_code = 'PERIODIC_BUDGET' THEN
4578:

Line 4595: IF p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

4591: END IF;
4592: END;
4593: END IF;
4594:
4595: IF p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
4596:
4597: BEGIN
4598: IF p_all_layout_code IS NULL THEN
4599:

Line 4605: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4601: x_return_status := FND_API.G_RET_STS_ERROR;
4602: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4603: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4604: PA_DEBUG.Reset_Curr_Function;
4605: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4606: ELSE
4607:
4608: OPEN layout_details_cur FOR l_sql USING p_all_layout_code;
4609: FETCH layout_details_cur INTO l_integrator_code;

Line 4642: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4638: -- ,x_msg_count => l_msg_count
4639: -- ,x_msg_data => l_msg_data );
4640: --
4641: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4642: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4643: -- END IF;
4644: END IF;
4645: IF l_all_layout_type_code = 'PERIODIC_BUDGET' THEN
4646:

Line 4693: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

4689: )
4690: VALUES
4691: ( p_project_id
4692: , p_fin_plan_type_id
4693: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
4694: , l_cost_amount_types_tbl(j)
4695: , 1
4696: , sysdate
4697: , fnd_global.user_id

Line 4731: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

4727: )
4728: VALUES
4729: ( p_project_id
4730: , p_fin_plan_type_id
4731: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
4732: , l_rev_amount_types_tbl(j)
4733: , 1
4734: , sysdate
4735: , fnd_global.user_id

Line 4771: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

4767: )
4768: VALUES
4769: ( p_project_id
4770: , p_fin_plan_type_id
4771: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
4772: , l_all_amount_types_tbl(j)
4773: , 1
4774: , sysdate
4775: , fnd_global.user_id

Line 4799: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4795: pa_debug.Reset_Curr_Function;
4796:
4797: EXCEPTION
4798:
4799: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4800: l_msg_count := FND_MSG_PUB.count_msg;
4801: IF l_msg_count = 1 THEN
4802: PA_INTERFACE_UTILS_PUB.get_messages
4803: (p_encoded => FND_API.G_TRUE

Line 4904: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4900:
4901: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4902: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4903:
4904: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4905:
4906: END IF;
4907:
4908: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(

Line 4937: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4933: PA_DEBUG.Reset_Curr_Function;
4934:
4935: EXCEPTION
4936:
4937: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4938: l_msg_count := FND_MSG_PUB.count_msg;
4939: IF l_msg_count = 1 THEN
4940: PA_INTERFACE_UTILS_PUB.get_messages
4941: (p_encoded => FND_API.G_TRUE

Line 5032: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

5028:
5029: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
5030: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
5031:
5032: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
5033:
5034: END IF;
5035:
5036: IF p_add_cost_amt_types_tbl.COUNT > 0 THEN

Line 5058: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

5054: ,last_update_login )
5055: VALUES
5056: ( p_project_id
5057: ,p_fin_plan_type_id
5058: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
5059: ,p_add_cost_amt_types_tbl(j)
5060: ,1
5061: ,sysdate
5062: ,fnd_global.user_id

Line 5079: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND

5075:
5076: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5077: project_id = p_project_id AND
5078: fin_plan_type_id = p_fin_plan_type_id AND
5079: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND
5080: amount_type_code = p_del_cost_amt_types_tbl(j) ;
5081: END IF;
5082:
5083: IF p_add_rev_amt_types_tbl.COUNT > 0 THEN

Line 5105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

5101: ,last_update_login )
5102: VALUES
5103: ( p_project_id
5104: ,p_fin_plan_type_id
5105: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
5106: ,p_add_rev_amt_types_tbl(j)
5107: ,1
5108: ,sysdate
5109: ,fnd_global.user_id

Line 5125: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE AND

5121:
5122: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5123: project_id = p_project_id AND
5124: fin_plan_type_id = p_fin_plan_type_id AND
5125: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE AND
5126: amount_type_code = p_del_rev_amt_types_tbl(j) ;
5127: END IF;
5128:
5129: IF p_add_all_amt_types_tbl.COUNT > 0 THEN

Line 5157: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

5153: ,last_update_login )
5154: VALUES
5155: ( p_project_id
5156: ,p_fin_plan_type_id
5157: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
5158: ,p_add_all_amt_types_tbl(j)
5159: ,1
5160: ,sysdate
5161: ,fnd_global.user_id

Line 5179: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND

5175:
5176: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5177: project_id = p_project_id AND
5178: fin_plan_type_id = p_fin_plan_type_id AND
5179: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND
5180: amount_type_code = p_del_all_amt_types_tbl(j) ;
5181: END IF;
5182: PA_DEBUG.Reset_Curr_Function;
5183: EXCEPTION

Line 5185: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5181: END IF;
5182: PA_DEBUG.Reset_Curr_Function;
5183: EXCEPTION
5184:
5185: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5186: l_msg_count := FND_MSG_PUB.count_msg;
5187: IF l_msg_count = 1 THEN
5188: PA_INTERFACE_UTILS_PUB.get_messages
5189: (p_encoded => FND_API.G_TRUE