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 600: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

596: -- Added the three colums for ms-excel options tab in web Adi Changes
597:
598: IF NVL(l_webadi_profile,'N') = 'Y' THEN
599:
600: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
601: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
602:
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: 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 601: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN

597:
598: IF NVL(l_webadi_profile,'N') = 'Y' THEN
599:
600: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
601: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
602:
603: IF P_PA_DEBUG_MODE = 'Y' THEN
604: pa_debug.g_err_stage := 'inside cost only preference code FP_Cols_Rec.cost_time_phased_code :: '||FP_Cols_Rec.cost_time_phased_code;
605: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);

Line 626: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

622: FP_Cols_Rec.cost_layout_code := l_default_gen_options_rec.cost_layout_code;
623: END IF;
624: END IF;
625:
626: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
627: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
628:
629: IF FP_Cols_Rec.revenue_time_phased_code in ('G','P') THEN
630:

Line 627: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN

623: END IF;
624: END IF;
625:
626: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
627: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP ) THEN
628:
629: IF FP_Cols_Rec.revenue_time_phased_code in ('G','P') THEN
630:
631: IF plan_type_info_rec.plan_class_code = 'BUDGET' THEN

Line 641: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

637: FP_Cols_Rec.revenue_layout_code := l_default_gen_options_rec.revenue_layout_code ;
638: END IF;
639: END IF;
640:
641: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
642:
643: IF FP_Cols_Rec.all_time_phased_code in ('G','P') THEN
644: IF plan_type_info_rec.plan_class_code = 'BUDGET' THEN
645: FP_Cols_Rec.all_layout_code := 'PE_BUDGET';

Line 661: ELSIF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

657: END IF;
658:
659: END IF;
660:
661: ELSIF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
662: THEN
663:
664: -- Check if target is a control document
665:

Line 669: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;

665:
666: OPEN plan_version_info_cur(l_plan_version_id);
667: FETCH plan_version_info_cur INTO plan_version_info_rec;
668: IF plan_version_info_cur%NOTFOUND THEN
669: RAISE PA_FP_CONSTANTS_PKG.INVALID_ARG_EXC;
670: END IF;
671: CLOSE plan_version_info_cur;
672:
673: IF (plan_version_info_rec.ci_id IS NOT NULL) THEN

Line 748: IF (l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE AND

744: -- End of FP M Phase II Dev changes
745: ELSE -- target is not ci version
746:
747: -- If source option is plan type
748: IF (l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE AND
749: nvl(plan_type_info_rec.use_for_workplan_flag,'N') <>'Y' )
750: THEN
751:
752: -- Gen Src Version Id should be initialized using Gen Src Version Code

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

749: nvl(plan_type_info_rec.use_for_workplan_flag,'N') <>'Y' )
750: THEN
751:
752: -- Gen Src Version Id should be initialized using Gen Src Version Code
753: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND
754: (FP_Cols_Rec.gen_src_cost_plan_type_id IS NOT NULL ) AND
755: (FP_Cols_Rec.gen_src_cost_plan_ver_code IS NOT NULL)
756: THEN
757:

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

764:
765: -- Null out generation source plan version code
766: FP_Cols_Rec.gen_src_cost_plan_ver_code := NULL;
767:
768: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND
769: (FP_Cols_Rec.gen_src_rev_plan_type_id IS NOT NULL ) AND
770: (FP_Cols_Rec.gen_src_rev_plan_ver_code IS NOT NULL)
771: THEN
772:

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

779:
780: -- Null out generation source plan version code
781: FP_Cols_Rec.gen_src_rev_plan_ver_code := NULL;
782:
783: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND
784: (FP_Cols_Rec.gen_src_all_plan_type_id IS NOT NULL ) AND
785: (FP_Cols_Rec.gen_src_all_plan_ver_code IS NOT NULL)
786: THEN
787:

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

796: FP_Cols_Rec.gen_src_all_plan_ver_code := NULL;
797: END IF;
798:
799: -- Gen Src Workplan Version Id should be initialized using Gen Src Wp version code
800: IF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) AND
801: (FP_Cols_Rec.gen_src_cost_wp_ver_code IS NOT NULL)
802: THEN
803:
804: -- Call private method fetch Gen_Src_WP_Version_Id

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

808:
809: -- Null out generation source workplan version code
810: FP_Cols_Rec.gen_src_cost_wp_ver_code := NULL;
811:
812: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) AND
813: (FP_Cols_Rec.gen_src_rev_wp_ver_code IS NOT NULL)
814: THEN
815:
816: -- Call private method fetch Gen_Src_WP_Version_Id

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

820:
821: -- Null out generation source workplan version code
822: FP_Cols_Rec.gen_src_rev_wp_ver_code := NULL;
823:
824: ELSIF (l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) AND
825: (FP_Cols_Rec.gen_src_all_wp_ver_code IS NOT NULL)
826: THEN
827:
828: -- Call private method fetch Gen_Src_WP_Version_Id

Line 836: ELSIF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION

832:
833: -- Null out generation source workplan version code
834: FP_Cols_Rec.gen_src_all_wp_ver_code := NULL;
835: END IF;
836: ELSIF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION
837: THEN
838:
839: -- 3/28/2004 FP M Phase II Dev Effort Copy Project Impact
840: IF l_source_project_id <> p_target_project_id

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

853: END IF; -- target version is ci/other kind of version
854:
855: END IF; -- l_target_option_level_code
856:
857: END IF; -- l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT
858:
859: -- End of FP M Dev effort
860:
861: /* MC Options need to be copied only in the context of plan type or plan version.

Line 864: IF l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN

860:
861: /* MC Options need to be copied only in the context of plan type or plan version.
862: The logic of copying mc options is common and hence done outside all IFs. */
863:
864: IF l_target_option_level_code <> PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT THEN
865: /* While copying project, the MC options should be inherited from the source option
866: i.e., from the source project's plan type or plan version */
867: IF p_source_proj_fp_option_id IS NOT NULL THEN
868: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 883: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN

879:
880: ELSE
881: /* MC Options are always inherited from the Plan Type MC options. In this case
882: plan type id cannot be null (validation done) */
883: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE THEN
884: IF P_PA_DEBUG_MODE = 'Y' THEN
885: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': getting mc options from plan type';
886: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
887: END IF;

Line 913: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN

909: END IF;
910: END IF;
911: /* Bug# 2637789 */
912: /* Bug 2747255 - Set the Cost conv attributes null if pref cost is REVENUE_ONLY and vice versa */
913: IF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY THEN
914: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := 'N';
915: FP_Mc_Cols_Rec.primary_rev_forecast_flag := 'N';
916: FP_Mc_Cols_Rec.project_rev_rate_type := Null;
917: FP_Mc_Cols_Rec.project_rev_rate_date_type := Null;

Line 922: ELSIF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN

918: FP_Mc_Cols_Rec.project_rev_rate_date := Null;
919: FP_Mc_Cols_Rec.projfunc_rev_rate_type := Null;
920: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := Null;
921: FP_Mc_Cols_Rec.projfunc_rev_rate_date := Null;
922: ELSIF l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY THEN
923: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := 'N';
924: FP_Mc_Cols_Rec.primary_cost_forecast_flag := 'N';
925: FP_Mc_Cols_Rec.projfunc_cost_rate_type := Null;
926: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := Null;

Line 1021: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

1017: END IF;
1018:
1019: /* Bug 3149010 - Logic of not overwritting attribs when the target is ALL */
1020:
1021: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1022: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1023: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1024: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1025: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;

Line 1022: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1018:
1019: /* Bug 3149010 - Logic of not overwritting attribs when the target is ALL */
1020:
1021: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1022: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1023: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1024: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1025: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1026: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;

Line 1038: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND

1034: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1035: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1036: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1037:
1038: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1039: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1040: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1041: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1042: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;

Line 1039: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1035: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1036: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1037:
1038: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1039: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1040: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1041: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1042: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1043: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;

Line 1064: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND

1060: existing version do not over write primary forecast columns, rate schedule
1061: setup if target is AR version, generation options set up if plan class codes
1062: differ for source and target versions
1063: */
1064: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1065: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1066:
1067: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1068: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;

Line 1065: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN

1061: setup if target is AR version, generation options set up if plan class codes
1062: differ for source and target versions
1063: */
1064: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1065: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1066:
1067: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1068: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1069:

Line 1438: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

1434: -- End, jwhite, 26-JUN-2003: Plannable Task Effort --------------------------------
1435:
1436: --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.
1437: --For the ms-excel options tab
1438: IF l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
1439: AND (nvl(plan_type_info_rec.use_for_workplan_flag,'N') <> 'Y') THEN
1440:
1441: IF NVL(l_webadi_profile,'N') = 'Y' THEN
1442:

Line 1456: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1452: ,x_msg_count => x_msg_count
1453: ,x_msg_data => x_msg_data);
1454:
1455: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1456: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1457: END IF;
1458:
1459: ELSE
1460: copy_amt_types (

Line 1471: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1467: ,x_msg_data => x_msg_data );
1468:
1469:
1470: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1471: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1472: END IF;
1473: END IF; -- source project is null
1474: END IF; -- web adi profile
1475: END IF;

Line 1484: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

1480: pa_debug.reset_err_stack;
1481: END IF;
1482:
1483: EXCEPTION
1484: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1485: l_msg_count := FND_MSG_PUB.count_msg;
1486: IF l_msg_count = 1 THEN
1487: PA_INTERFACE_UTILS_PUB.get_messages
1488: (p_encoded => FND_API.G_TRUE,

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

1619: REVENUE_ONLY COST_ONLY
1620: */
1621:
1622: /* M22-AUG: these validations are not required. These are not invalid combinations.
1623: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

Line 1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR

1620: */
1621:
1622: /* M22-AUG: these validations are not required. These are not invalid combinations.
1623: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

Line 1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND

1622: /* M22-AUG: these validations are not required. These are not invalid combinations.
1623: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR

Line 1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,

1623: IF ((l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME AND
1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR
1631: */

Line 1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,

1624: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) OR
1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR
1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

Line 1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))

1625:
1626: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP AND
1627: l_target_fin_plan_pref IN (PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY,
1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR
1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR

Line 1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND

1628: PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY,
1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR
1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1634: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1635: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1636:

Line 1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR

1629: PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME))
1630: OR
1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1634: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1635: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1636:
1637: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 1634: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND

1630: OR
1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1634: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1635: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1636:
1637: IF P_PA_DEBUG_MODE = 'Y' THEN
1638: pa_debug.g_err_stage := 'Err- Invalid Combination of Source and Target Preference code';

Line 1635: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN

1631: */
1632: IF (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1633: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
1634: (l_source_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1635: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
1636:
1637: IF P_PA_DEBUG_MODE = 'Y' THEN
1638: pa_debug.g_err_stage := 'Err- Invalid Combination of Source and Target Preference code';
1639: pa_debug.write('Get_FP_Options: ' || l_module_name,pa_debug.g_err_stage,5);

Line 1644: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1640: END IF;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1643: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1644: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1645:
1646: END IF;
1647:
1648: -- Initializing all the cost/quantity flags to 'N'

Line 1671: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

1667: amount set flags as the case may be for the target option which is having the pref
1668: code as Null */
1669:
1670: IF p_target_fp_options_id IS NOT NULL AND
1671: l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1672:
1673: IF P_PA_DEBUG_MODE = 'Y' THEN
1674: pa_debug.g_err_stage := 'Inside target opt id not null ' || p_target_fp_options_id ||
1675: ' and target pref code is ALL';

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

1789: l_cost_amount_set_id := null;
1790: l_revenue_amount_set_id := null;
1791: l_all_amount_set_id := null;
1792:
1793: IF ( l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
1794:
1795: /* If the FP Preference Code is Cost and Revenue Separately, then the
1796: COST and REVENUE columns have to be returned for all the valid combinations
1797: of Source and Target Fin_Plan_Preference_Code.

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

1819: ,revenue_resource_list_id
1820: ,NULL all_fin_plan_level_code
1821: ,NULL all_time_phased_code
1822: ,NULL all_resource_list_id
1823: ,nvl(report_labor_hrs_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) report_labor_hrs_from_code
1824: ,plan_in_multi_curr_flag
1825: ,factor_by_code
1826: ,default_amount_type_code
1827: ,default_amount_subtype_code

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

1902: ,NULL gen_src_all_wp_version_id
1903: ,NULL gen_src_all_wp_ver_code
1904: -- end of FP M dev phase II changes
1905: -- Added for ms-excel options in webadi
1906: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,cost_layout_code,null)
1907: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,revenue_layout_code,null)
1908: ,NULL all_layout_code
1909: ,revenue_derivation_method -- Bug 5462471
1910: INTO x_fp_cols_rec

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

1903: ,NULL gen_src_all_wp_ver_code
1904: -- end of FP M dev phase II changes
1905: -- Added for ms-excel options in webadi
1906: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,cost_layout_code,null)
1907: ,decode(p_target_fp_option_level_code,PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE,revenue_layout_code,null)
1908: ,NULL all_layout_code
1909: ,revenue_derivation_method -- Bug 5462471
1910: INTO x_fp_cols_rec
1911: FROM pa_proj_fp_options

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

1912: WHERE proj_fp_options_id = p_proj_fp_options_id;
1913:
1914: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
1915:
1916: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN
1917:
1918: /* If the FP Preference Code is COST_ONLY, only the Cost Columns have to be sent
1919: and the other columns have to be returned as NULL. */
1920:

Line 1954: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1950: ,x_message_data => l_msg_data);
1951:
1952: --added for bug 2708782
1953: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1954: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1955: END IF;
1956:
1957: IF P_PA_DEBUG_MODE = 'Y' THEN
1958: pa_debug.g_err_stage := 'Target Fin Plan Pref Code is Cost Only.';

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

1980: ,plan_in_multi_curr_flag plan_in_multi_curr_flag
1981: ,factor_by_code factor_by_code
1982: ,default_amount_type_code default_amount_type_code
1983: ,default_amount_subtype_code default_amount_subtype_code
1984: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code
1985: /* Bug 2920954 start of new record parameters for post fp-k oneoff patch */
1986: ,nvl(select_cost_res_auto_flag, select_all_res_auto_flag) select_cost_res_auto_flag
1987: ,NULL cost_res_planning_level
1988: ,NULL select_rev_res_auto_flag

Line 2069: ,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

2065: ,NULL gen_src_all_wp_version_id
2066: ,NULL gen_src_all_wp_ver_code
2067: -- end of FP M dev phase II changes
2068: -- Added for ms-excel options in webadi
2069: ,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
2070: ,NULL revenue_layout_code
2071: ,NULL all_layout_code
2072: ,NULL -- Bug 5462471 For cost only version revenue_derivation_method should be null always
2073: INTO x_fp_cols_rec

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

2078:
2079:
2080: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2081:
2082: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
2083:
2084: /* If the FP Preference Code is REVENUE_ONLY, only the Revenue Columns have to be sent
2085: and the other columns have to be returned as NULL. */
2086:

Line 2120: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2116: ,x_return_status => x_return_status
2117: ,x_message_data => l_msg_data);
2118:
2119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2120: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2121: END IF;
2122:
2123: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2124:

Line 2229: ,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

2225: ,NULL gen_src_all_wp_ver_code
2226: -- end of FP M dev phase II changes
2227: -- Added for ms-excel options in webadi
2228: ,NULL cost_layout_code
2229: ,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
2230: ,NULL all_layout_code
2231: ,revenue_derivation_method -- Bug 5462471
2232: INTO x_fp_cols_rec
2233: FROM pa_proj_fp_options

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

2234: WHERE proj_fp_options_id = p_proj_fp_options_id;
2235:
2236: -- END: Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2237:
2238: ELSIF (l_target_fin_plan_pref = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
2239:
2240: /* If the FP Preference Code is COST_AND_REV_SAME, only the "all" Columns have to be sent
2241: and the other columns have to be returned as NULL. */
2242:

Line 2277: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2273: ,x_message_data => l_msg_data);
2274:
2275: --added for bug 2708782
2276: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2277: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2278: END IF;
2279:
2280: IF P_PA_DEBUG_MODE = 'Y' THEN
2281: pa_debug.g_err_stage := 'Target Fin Plan Pref Code is Cost and Revenue together.';

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

2300: ,plan_in_multi_curr_flag plan_in_multi_curr_flag
2301: ,factor_by_code factor_by_code
2302: ,default_amount_type_code default_amount_type_code
2303: ,default_amount_subtype_code default_amount_subtype_code /* manoj */
2304: ,nvl(margin_derived_from_code,PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B) margin_derived_from_code
2305: /* Bug 2920954 start of new record parameters for post fp-k oneoff patch */
2306: ,NULL select_cost_res_auto_flag
2307: ,NULL cost_res_planning_level
2308: ,NULL select_rev_res_auto_flag

Line 2400: ,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

2396: -- end of FP M dev phase II changes
2397: -- Added for ms-excel options in webadi
2398: ,NULL cost_layout_code
2399: ,NULL revenue_layout_code
2400: ,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
2401: ,revenue_derivation_method -- Bug 5462471
2402: INTO x_fp_cols_rec
2403: FROM pa_proj_fp_options
2404: WHERE proj_fp_options_id = p_proj_fp_options_id;

Line 2415: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2411: pa_debug.reset_err_stack;
2412: END IF;
2413:
2414: EXCEPTION
2415: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2416: l_msg_count := FND_MSG_PUB.count_msg;
2417: IF l_msg_count = 1 THEN
2418: PA_INTERFACE_UTILS_PUB.get_messages
2419: (p_encoded => FND_API.G_TRUE,

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

2481:
2482: /* To get the Parent Option of a PLAN_VERSION, PLAN_TYPE option for the
2483: Project and Plan Type has to be selected. */
2484:
2485: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2486:
2487: IF P_PA_DEBUG_MODE = 'Y' THEN
2488: pa_debug.g_err_stage := 'Option Level Code is PLAN_VERSION.';
2489: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,pa_debug.g_err_stage,3);

Line 2495: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE

2491:
2492: SELECT proj_fp_options_id
2493: INTO x_proj_fp_options_id
2494: FROM pa_proj_fp_options
2495: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
2496: AND project_id = l_proj_id
2497: AND fin_plan_type_id = l_fp_type_id;
2498:
2499: /* To get the Parent Option of a PLAN_TYPE, PROJECT option for the

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

2503: pa_debug.g_err_stage := 'Option Level Code is PLAN_TYPE.';
2504: pa_debug.write('Get_Parent_FP_Option_ID: ' || l_module_name,pa_debug.g_err_stage,3);
2505: END IF;
2506:
2507: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2508: SELECT proj_fp_options_id
2509: INTO x_proj_fp_options_id
2510: FROM pa_proj_fp_options
2511: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT

Line 2511: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT

2507: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2508: SELECT proj_fp_options_id
2509: INTO x_proj_fp_options_id
2510: FROM pa_proj_fp_options
2511: WHERE fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT
2512: AND project_id = l_proj_id;
2513:
2514: END IF;
2515:

Line 2583: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;

2579:
2580: IF p_project_id IS NOT NULL THEN
2581: IF p_plan_type_id IS NOT NULL THEN
2582: IF p_plan_version_id IS NOT NULL THEN
2583: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2584: ELSE
2585: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2586: END IF;
2587: ELSE

Line 2585: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

2581: IF p_plan_type_id IS NOT NULL THEN
2582: IF p_plan_version_id IS NOT NULL THEN
2583: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2584: ELSE
2585: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2586: END IF;
2587: ELSE
2588: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2589: END IF;

Line 2588: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;

2584: ELSE
2585: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2586: END IF;
2587: ELSE
2588: l_fp_option_level_code := PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2589: END IF;
2590: END IF;
2591:
2592: /* Following are the Select statements to get the Proj_FP_Options_ID depending on the Option Level

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

2593: Code. If the Option_Level_Code is Project, then only Project_ID has to be checked for. For
2594: 'Plan_Type', both Project_ID and Plan_Type_ID have to be checked and for PLAN_VERSION, all the
2595: three - Project_ID,Plan_Type_ID,Plan_Version_ID have to be checked for. */
2596:
2597: IF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT) THEN
2598:
2599: SELECT proj_fp_options_id
2600: INTO x_proj_fp_options_id
2601: FROM pa_proj_fp_options

Line 2603: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;

2599: SELECT proj_fp_options_id
2600: INTO x_proj_fp_options_id
2601: FROM pa_proj_fp_options
2602: WHERE project_id = p_project_id
2603: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2604:
2605: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2606:
2607: SELECT proj_fp_options_id

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

2601: FROM pa_proj_fp_options
2602: WHERE project_id = p_project_id
2603: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PROJECT;
2604:
2605: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE) THEN
2606:
2607: SELECT proj_fp_options_id
2608: INTO x_proj_fp_options_id
2609: FROM pa_proj_fp_options

Line 2612: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

2608: INTO x_proj_fp_options_id
2609: FROM pa_proj_fp_options
2610: WHERE project_id = p_project_id
2611: AND fin_plan_type_id = p_plan_type_id
2612: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2613:
2614: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2615:
2616: SELECT proj_fp_options_id

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

2610: WHERE project_id = p_project_id
2611: AND fin_plan_type_id = p_plan_type_id
2612: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
2613:
2614: ELSIF (l_fp_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION) THEN
2615:
2616: SELECT proj_fp_options_id
2617: INTO x_proj_fp_options_id
2618: FROM pa_proj_fp_options

Line 2622: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;

2618: FROM pa_proj_fp_options
2619: WHERE project_id = p_project_id
2620: AND fin_plan_type_id = p_plan_type_id
2621: AND fin_plan_version_id = p_plan_version_id
2622: AND fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION;
2623:
2624: END IF;
2625:
2626: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 2802: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2798: IF p_plan_type_id IS NOT NULL THEN
2799: OPEN plan_type_info_cur (p_plan_type_id);
2800: FETCH plan_type_info_cur INTO plan_type_info_rec;
2801: IF plan_type_info_cur%NOTFOUND THEN
2802: Raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2803: END IF;
2804: CLOSE plan_type_info_cur;
2805: END IF;
2806:

Line 2830: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2826: WHEN NO_DATA_FOUND THEN
2827: IF P_PA_DEBUG_MODE = 'Y' THEN
2828: pa_debug.g_err_stage := 'No uncat resource list found corresponding to the org_id';
2829: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);
2830: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2831: END IF;
2832: END;
2833:
2834: PA_FIN_PLAN_UTILS.GET_OR_CREATE_AMOUNT_SET_ID(

Line 2854: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2850: X_MESSAGE_DATA => l_msg_data);
2851:
2852: --added for bug 2708782
2853: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2854: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2855: END IF;
2856:
2857: /* Following code is added in context of autobaseline */
2858: /* Bug#2619022 */

Line 2913: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2909: || to_char(l_err_code) || ':Err_stage:' || l_err_stage
2910: || ':Err_stack' || l_err_stack;
2911: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,5);
2912: END IF;
2913: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2914: END IF;
2915:
2916: IF l_proj_level_funding = 'P' THEN
2917: l_rev_fin_plan_level_code := 'P';

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

2941: , x_return_status => l_return_status);
2942:
2943: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2944: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
2945: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2946: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2947: END IF;
2948:
2949: -- If the project and project func currencies aren't equal

Line 2946: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2942:
2943: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2944: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
2945: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2946: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2947: END IF;
2948:
2949: -- If the project and project func currencies aren't equal
2950: -- set the multi currency flag to 'Y'

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

2984:
2985: -- Initialize plan settings tab related values that are preferene code
2986: -- dependent
2987:
2988: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) THEN
2989:
2990: IF P_PA_DEBUG_MODE = 'Y' THEN
2991: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost Only.';
2992: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

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

2996: l_fp_cols_rec.cost_fin_plan_level_code := l_fin_plan_level_code;
2997: l_fp_cols_rec.cost_time_phased_code := l_time_phased_code;
2998: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
2999:
3000: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3001: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3002: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3003:
3004: IF p_plan_type_id IS NOT NULL THEN

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

2997: l_fp_cols_rec.cost_time_phased_code := l_time_phased_code;
2998: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
2999:
3000: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3001: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3002: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3003:
3004: IF p_plan_type_id IS NOT NULL THEN
3005: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;

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

2998: l_fp_cols_rec.cost_resource_list_id := l_uncategorized_res_id;
2999:
3000: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3001: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3002: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3003:
3004: IF p_plan_type_id IS NOT NULL THEN
3005: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3006: END IF;

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

3001: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3002: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3003:
3004: IF p_plan_type_id IS NOT NULL THEN
3005: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3006: END IF;
3007:
3008: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
3009:

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

3004: IF p_plan_type_id IS NOT NULL THEN
3005: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3006: END IF;
3007:
3008: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) THEN
3009:
3010: IF P_PA_DEBUG_MODE = 'Y' THEN
3011: pa_debug.g_err_stage := 'Fin Plan Preference code is Revenue Only.';
3012: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

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

3016: l_fp_cols_rec.revenue_fin_plan_level_code := l_rev_fin_plan_level_code;
3017: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3018: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3019:
3020: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3021: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3022: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3023:
3024: --Bug 5462471

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

3017: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3018: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3019:
3020: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3021: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3022: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3023:
3024: --Bug 5462471
3025: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);

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

3018: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3019:
3020: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3021: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_REVENUE;
3022: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_REVENUE;
3023:
3024: --Bug 5462471
3025: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);
3026:

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

3039: IF p_plan_type_id IS NOT NULL THEN
3040: l_fp_cols_rec.margin_derived_from_code := null; -- not applicable in this case
3041: END IF;
3042:
3043: ELSIF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME) THEN
3044:
3045: IF P_PA_DEBUG_MODE = 'Y' THEN
3046: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost and Revenue together.';
3047: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

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

3051: l_fp_cols_rec.all_fin_plan_level_code := l_fin_plan_level_code;
3052: l_fp_cols_rec.all_time_phased_code := l_time_phased_code;
3053: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3054:
3055: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3056: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3057: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3058:
3059: --Bug 5462471

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

3052: l_fp_cols_rec.all_time_phased_code := l_time_phased_code;
3053: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3054:
3055: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3056: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3057: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3058:
3059: --Bug 5462471
3060: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);

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

3053: l_fp_cols_rec.all_resource_list_id := l_uncategorized_res_id;
3054:
3055: l_fp_cols_rec.default_amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_COST;
3056: l_fp_cols_rec.default_amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_BURD_COST;
3057: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3058:
3059: --Bug 5462471
3060: l_revenue_derivation_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_target_project_id);
3061:

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

3071:
3072:
3073:
3074: IF p_plan_type_id IS NOT NULL THEN
3075: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3076: END IF;
3077:
3078: ELSIF ( p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
3079:

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

3074: IF p_plan_type_id IS NOT NULL THEN
3075: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3076: END IF;
3077:
3078: ELSIF ( p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
3079:
3080: IF P_PA_DEBUG_MODE = 'Y' THEN
3081: pa_debug.g_err_stage := 'Fin Plan Preference code is Cost and Revenue separately.';
3082: pa_debug.write('Get_Default_FP_Options: ' || l_module_name,pa_debug.g_err_stage,3);

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

3091: l_fp_cols_rec.revenue_fin_plan_level_code := l_rev_fin_plan_level_code;
3092: l_fp_cols_rec.revenue_time_phased_code := l_time_phased_code;
3093: l_fp_cols_rec.revenue_resource_list_id := l_uncategorized_res_id;
3094:
3095: l_fp_cols_rec.report_labor_hrs_from_code := PA_FP_CONSTANTS_PKG.G_LABOR_HRS_FROM_CODE_COST;
3096: l_fp_cols_rec.default_amount_type_code := null; /* Open Issue */
3097: l_fp_cols_rec.default_amount_subtype_code := null; /* Open Issue */
3098:
3099: --Bug 5462471

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

3110: end if;
3111:
3112:
3113: IF p_plan_type_id IS NOT NULL THEN
3114: l_fp_cols_rec.margin_derived_from_code := PA_FP_CONSTANTS_PKG.G_MARGIN_DERIVED_FROM_CODE_B;
3115: END IF;
3116:
3117: END IF;
3118:

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

3138: IF (p_plan_type_id IS NOT NULL) AND (plan_type_info_rec.use_for_workplan_flag <> 'Y' ) THEN
3139:
3140: -- For both cost and cost and rev sep cases, cost generation options should be defaulted
3141:
3142: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
3143: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3144: THEN
3145:
3146: -- Separate processing based on plan class code

Line 3143: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )

3139:
3140: -- For both cost and cost and rev sep cases, cost generation options should be defaulted
3141:
3142: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY) OR
3143: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3144: THEN
3145:
3146: -- Separate processing based on plan class code
3147: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

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

3143: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3144: THEN
3145:
3146: -- Separate processing based on plan class code
3147: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3148: THEN
3149:
3150: IF P_PA_DEBUG_MODE = 'Y' THEN
3151: pa_debug.g_err_stage := 'fetching generation columns for cost';

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

3260:
3261: END IF; -- End of BUDGET/FORECAST
3262: END IF; -- cost or cost and rev sep case
3263:
3264: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) OR
3265: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3266: THEN
3267:
3268: -- Separate processing based on plan class code

Line 3265: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )

3261: END IF; -- End of BUDGET/FORECAST
3262: END IF; -- cost or cost and rev sep case
3263:
3264: IF ((p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY) OR
3265: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3266: THEN
3267:
3268: -- Separate processing based on plan class code
3269: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

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

3265: (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) )
3266: THEN
3267:
3268: -- Separate processing based on plan class code
3269: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3270: THEN
3271:
3272: -- Estimate to completion source code should be null
3273:

Line 3358: IF p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN

3354: WHERE ROWNUM = 1;
3355: Exception
3356: When NO_DATA_FOUND then
3357: -- Bug 3666398 revenue-only plan type can not be generation source
3358: IF p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP THEN
3359: -- When there is no other plan type set to the same plan type id being created
3360: l_fp_cols_rec.gen_src_rev_plan_type_id := p_plan_type_id;
3361: l_fp_cols_rec.gen_src_rev_plan_ver_code := 'CURRENT_BASELINED'; -- Bug 3572548
3362: END IF;

Line 3381: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)

3377: Raise;
3378: End;
3379: END IF; -- revenue or cost and rev sep
3380:
3381: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)
3382: THEN
3383:
3384: -- Separate processing based on plan class code
3385: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)

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

3381: IF (p_fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME)
3382: THEN
3383:
3384: -- Separate processing based on plan class code
3385: IF (plan_type_info_rec.plan_class_code = PA_FP_CONSTANTS_PKG.G_PLAN_CLASS_BUDGET)
3386: THEN
3387:
3388: -- Estimate to completion source code should be null
3389:

Line 3519: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3515:
3516: RETURN l_fp_cols_rec;
3517:
3518: EXCEPTION
3519: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3520: l_msg_count := FND_MSG_PUB.count_msg;
3521: IF l_msg_count = 1 THEN
3522: PA_INTERFACE_UTILS_PUB.get_messages
3523: (p_encoded => FND_API.G_TRUE

Line 3722: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3718:
3719: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
3720: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3721:
3722: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3723:
3724: END IF;
3725:
3726: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 3738: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3734:
3735: OPEN version_option_info_cur;
3736: FETCH version_option_info_cur INTO version_option_info_rec;
3737: IF version_option_info_cur%NOTFOUND THEN
3738: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3739: END IF;
3740: CLOSE version_option_info_cur;
3741:
3742:

Line 3790: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,

3786:
3787:
3788: -- obtain the period type corresponding to the time phased code
3789: select decode(l_time_phased_code,
3790: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3791: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,l_time_phased_code)
3792: into l_curr_period_type
3793: from dual;
3794:

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

3787:
3788: -- obtain the period type corresponding to the time phased code
3789: select decode(l_time_phased_code,
3790: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3791: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G,PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL,l_time_phased_code)
3792: into l_curr_period_type
3793: from dual;
3794:
3795: --Select the period profile for this version. Get the period profile period type

Line 3819: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3815:
3816: PA_UTILS.ADD_MESSAGE(p_app_short_name=> 'PA',
3817: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
3818:
3819: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3820: END;
3821:
3822: IF P_PA_DEBUG_MODE = 'Y' THEN
3823: pa_debug.g_err_stage := 'Determine if period profile to be updated.If yes get the id';

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

3824: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,3);
3825: END IF;
3826:
3827: IF (l_period_profile_id is NULL) THEN
3828: IF (l_curr_period_type in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3829: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3830:
3831: pa_prj_period_profile_utils.get_curr_period_profile_info(
3832: p_project_id => l_project_id

Line 3829: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN

3825: END IF;
3826:
3827: IF (l_period_profile_id is NULL) THEN
3828: IF (l_curr_period_type in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3829: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3830:
3831: pa_prj_period_profile_utils.get_curr_period_profile_info(
3832: p_project_id => l_project_id
3833: ,p_period_type => l_curr_period_type

Line 3834: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING

3830:
3831: pa_prj_period_profile_utils.get_curr_period_profile_info(
3832: p_project_id => l_project_id
3833: ,p_period_type => l_curr_period_type
3834: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING
3835: ,x_period_profile_id => l_curr_period_profile_id
3836: ,x_start_period => l_start_period
3837: ,x_end_period => l_end_period
3838: ,x_return_status => l_return_status

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

3849: END IF; -- check for period type.
3850:
3851: ELSE -- period profile id is not null
3852:
3853: IF (l_curr_period_type not in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3854: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3855:
3856: l_curr_period_profile_id := NULL;
3857: l_update_flag := 'Y';

Line 3854: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN

3850:
3851: ELSE -- period profile id is not null
3852:
3853: IF (l_curr_period_type not in (PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA,
3854: PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL)) THEN
3855:
3856: l_curr_period_profile_id := NULL;
3857: l_update_flag := 'Y';
3858:

Line 3884: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING

3880:
3881: pa_prj_period_profile_utils.get_curr_period_profile_info(
3882: p_project_id => l_project_id
3883: ,p_period_type => l_curr_period_type
3884: ,p_period_profile_type=> PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING
3885: ,x_period_profile_id => l_curr_period_profile_id
3886: ,x_start_period => l_start_period
3887: ,x_end_period => l_end_period
3888: ,x_return_status => l_return_status

Line 3916: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3912: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,2);
3913: pa_debug.reset_err_stack;
3914: END IF;
3915: EXCEPTION
3916: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3917: l_msg_count := FND_MSG_PUB.count_msg;
3918: IF l_msg_count = 1 THEN
3919: PA_INTERFACE_UTILS_PUB.get_messages
3920: (p_encoded => FND_API.G_TRUE

Line 4015: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4011:
4012: OPEN src_plan_type_info_cur(p_gen_src_plan_type_id, p_target_project_id);
4013: FETCH src_plan_type_info_cur INTO src_plan_type_info_rec;
4014: IF src_plan_type_info_cur%NOTFOUND THEN
4015: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4016: END IF;
4017: CLOSE src_plan_type_info_cur;
4018:
4019: IF P_PA_DEBUG_MODE = 'Y' THEN

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

4022: pa_debug.g_err_stage:='src_plan_type_info_rec.fin_plan_preference_code = = '||src_plan_type_info_rec.fin_plan_preference_code;
4023: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,pa_debug.g_err_stage,5);
4024: END IF;
4025:
4026: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4027: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4028: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4029: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4030: THEN

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

4023: pa_debug.write('Gen_Src_Plan_Version_Id: ' || l_module_name,pa_debug.g_err_stage,5);
4024: END IF;
4025:
4026: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4027: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4028: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4029: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4030: THEN
4031: -- For all these cases, preference code need not be passed as they

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

4025:
4026: IF (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY ) OR
4027: -- (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY ) OR
4028: --Commented the above condition for bug 4052619. The source plan type can never be REVENUE_ONLY
4029: (src_plan_type_info_rec.fin_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME )
4030: THEN
4031: -- For all these cases, preference code need not be passed as they
4032: -- can be derived in the called util apis
4033:

Line 4047: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4043: ,x_return_status => l_return_status
4044: ,x_msg_count => l_msg_count
4045: ,x_msg_data => l_msg_data );
4046: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4047: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4048: END IF;
4049:
4050: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4051:

Line 4063: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4059: ,x_return_status => l_return_status
4060: ,x_msg_count => l_msg_count
4061: ,x_msg_data => l_msg_data );
4062: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4063: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4064: END IF;
4065:
4066: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4067:

Line 4079: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4075: ,x_return_status => l_return_status
4076: ,x_msg_count => l_msg_count
4077: ,x_msg_data => l_msg_data );
4078: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4079: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4080: END IF;
4081:
4082: END IF; -- p_gen_src_plan_ver_code
4083:

Line 4111: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4107: ,x_return_status => l_return_status
4108: ,x_msg_count => l_msg_count
4109: ,x_msg_data => l_msg_data );
4110: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4111: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4112: END IF;
4113:
4114: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4115:

Line 4127: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4123: ,x_return_status => l_return_status
4124: ,x_msg_count => l_msg_count
4125: ,x_msg_data => l_msg_data );
4126: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4127: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4128: END IF;
4129:
4130: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4131:

Line 4143: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4139: ,x_return_status => l_return_status
4140: ,x_msg_count => l_msg_count
4141: ,x_msg_data => l_msg_data );
4142: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4143: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4144: END IF;
4145:
4146: END IF; -- p_gen_src_plan_ver_code
4147:

Line 4168: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4164: pa_debug.reset_err_stack;
4165: END IF;
4166:
4167: EXCEPTION
4168: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4169: l_msg_count := FND_MSG_PUB.count_msg;
4170: IF l_msg_count = 1 THEN
4171: PA_INTERFACE_UTILS_PUB.get_messages
4172: (p_encoded => FND_API.G_TRUE

Line 4294: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4290:
4291: RETURN l_gen_src_wp_ver_id;
4292:
4293: EXCEPTION
4294: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4295: l_msg_count := FND_MSG_PUB.count_msg;
4296: IF l_msg_count = 1 THEN
4297: PA_INTERFACE_UTILS_PUB.get_messages
4298: (p_encoded => FND_API.G_TRUE

Line 4405: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4401: x_return_status := FND_API.G_RET_STS_ERROR;
4402: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4403: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4404: PA_DEBUG.Reset_Curr_Function;
4405: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4406: END IF;
4407:
4408: --Delete the existing amount types for the project/plan types from pa_fp_proj_xl_amt_types
4409: DELETE FROM PA_FP_PROJ_XL_AMT_TYPES

Line 4427: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR

4423:
4424:
4425: --populating the seeded views
4426:
4427: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
4428: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4429:
4430: BEGIN
4431: IF p_cost_layout_code IS NULL THEN

Line 4428: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

4424:
4425: --populating the seeded views
4426:
4427: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY OR
4428: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4429:
4430: BEGIN
4431: IF p_cost_layout_code IS NULL THEN
4432:

Line 4437: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4433: x_return_status := FND_API.G_RET_STS_ERROR;
4434: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4435: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4436: PA_DEBUG.Reset_Curr_Function;
4437: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4438: ELSE
4439: OPEN layout_details_cur FOR l_sql USING p_cost_layout_code;
4440: FETCH layout_details_cur INTO l_integrator_code;
4441:

Line 4470: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4466: -- ,x_msg_data => l_msg_data );
4467: --
4468: --
4469: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4470: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4471: -- END IF;
4472: END IF;
4473: IF l_cost_layout_type_code = 'PERIODIC_BUDGET' THEN
4474:

Line 4494: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR

4490: END IF;
4491: END;
4492: END IF;
4493:
4494: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
4495: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4496:
4497: BEGIN
4498: IF p_revenue_layout_code IS NULL THEN

Line 4495: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN

4491: END;
4492: END IF;
4493:
4494: IF (p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY OR
4495: p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SEP) THEN
4496:
4497: BEGIN
4498: IF p_revenue_layout_code IS NULL THEN
4499:

Line 4504: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4500: x_return_status := FND_API.G_RET_STS_ERROR;
4501: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4502: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4503: PA_DEBUG.Reset_Curr_Function;
4504: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4505: ELSE
4506: OPEN layout_details_cur FOR l_sql USING p_revenue_layout_code;
4507: FETCH layout_details_cur INTO l_integrator_code;
4508:

Line 4529: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4525: -- ,x_msg_count => l_msg_count
4526: -- ,x_msg_data => l_msg_data );
4527: --
4528: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4529: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4530: -- END IF;
4531: END IF;
4532: IF l_revenue_layout_type_code = 'PERIODIC_BUDGET' THEN
4533:

Line 4550: IF p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN

4546: END IF;
4547: END;
4548: END IF;
4549:
4550: IF p_plan_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
4551:
4552: BEGIN
4553: IF p_all_layout_code IS NULL THEN
4554:

Line 4560: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4556: x_return_status := FND_API.G_RET_STS_ERROR;
4557: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4558: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4559: PA_DEBUG.Reset_Curr_Function;
4560: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4561: ELSE
4562:
4563: OPEN layout_details_cur FOR l_sql USING p_all_layout_code;
4564: FETCH layout_details_cur INTO l_integrator_code;

Line 4597: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4593: -- ,x_msg_count => l_msg_count
4594: -- ,x_msg_data => l_msg_data );
4595: --
4596: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4597: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4598: -- END IF;
4599: END IF;
4600: IF l_all_layout_type_code = 'PERIODIC_BUDGET' THEN
4601:

Line 4648: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

4644: )
4645: VALUES
4646: ( p_project_id
4647: , p_fin_plan_type_id
4648: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
4649: , l_cost_amount_types_tbl(j)
4650: , 1
4651: , sysdate
4652: , fnd_global.user_id

Line 4686: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

4682: )
4683: VALUES
4684: ( p_project_id
4685: , p_fin_plan_type_id
4686: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
4687: , l_rev_amount_types_tbl(j)
4688: , 1
4689: , sysdate
4690: , fnd_global.user_id

Line 4726: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

4722: )
4723: VALUES
4724: ( p_project_id
4725: , p_fin_plan_type_id
4726: , PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
4727: , l_all_amount_types_tbl(j)
4728: , 1
4729: , sysdate
4730: , fnd_global.user_id

Line 4754: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4750: pa_debug.Reset_Curr_Function;
4751:
4752: EXCEPTION
4753:
4754: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4755: l_msg_count := FND_MSG_PUB.count_msg;
4756: IF l_msg_count = 1 THEN
4757: PA_INTERFACE_UTILS_PUB.get_messages
4758: (p_encoded => FND_API.G_TRUE

Line 4859: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4855:
4856: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4857: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4858:
4859: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4860:
4861: END IF;
4862:
4863: INSERT INTO PA_FP_PROJ_XL_AMT_TYPES(

Line 4892: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

4888: PA_DEBUG.Reset_Curr_Function;
4889:
4890: EXCEPTION
4891:
4892: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4893: l_msg_count := FND_MSG_PUB.count_msg;
4894: IF l_msg_count = 1 THEN
4895: PA_INTERFACE_UTILS_PUB.get_messages
4896: (p_encoded => FND_API.G_TRUE

Line 4987: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

4983:
4984: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4985: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4986:
4987: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4988:
4989: END IF;
4990:
4991: IF p_add_cost_amt_types_tbl.COUNT > 0 THEN

Line 5013: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST

5009: ,last_update_login )
5010: VALUES
5011: ( p_project_id
5012: ,p_fin_plan_type_id
5013: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST
5014: ,p_add_cost_amt_types_tbl(j)
5015: ,1
5016: ,sysdate
5017: ,fnd_global.user_id

Line 5034: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND

5030:
5031: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5032: project_id = p_project_id AND
5033: fin_plan_type_id = p_fin_plan_type_id AND
5034: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST AND
5035: amount_type_code = p_del_cost_amt_types_tbl(j) ;
5036: END IF;
5037:
5038: IF p_add_rev_amt_types_tbl.COUNT > 0 THEN

Line 5060: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE

5056: ,last_update_login )
5057: VALUES
5058: ( p_project_id
5059: ,p_fin_plan_type_id
5060: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE
5061: ,p_add_rev_amt_types_tbl(j)
5062: ,1
5063: ,sysdate
5064: ,fnd_global.user_id

Line 5080: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE AND

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

Line 5112: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL

5108: ,last_update_login )
5109: VALUES
5110: ( p_project_id
5111: ,p_fin_plan_type_id
5112: ,PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL
5113: ,p_add_all_amt_types_tbl(j)
5114: ,1
5115: ,sysdate
5116: ,fnd_global.user_id

Line 5134: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND

5130:
5131: DELETE FROM pa_fp_proj_xl_amt_types WHERE
5132: project_id = p_project_id AND
5133: fin_plan_type_id = p_fin_plan_type_id AND
5134: option_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL AND
5135: amount_type_code = p_del_all_amt_types_tbl(j) ;
5136: END IF;
5137: PA_DEBUG.Reset_Curr_Function;
5138: EXCEPTION

Line 5140: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

5136: END IF;
5137: PA_DEBUG.Reset_Curr_Function;
5138: EXCEPTION
5139:
5140: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5141: l_msg_count := FND_MSG_PUB.count_msg;
5142: IF l_msg_count = 1 THEN
5143: PA_INTERFACE_UTILS_PUB.get_messages
5144: (p_encoded => FND_API.G_TRUE