[Home] [Help]
161: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
162: END IF;
163:
164: x_msg_count := 0;
165: x_return_status := FND_API.G_RET_STS_SUCCESS;
166:
167: l_stage := 200;
168: IF P_PA_DEBUG_MODE = 'Y' THEN
169: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': entered create_fp_option';
182: IF P_PA_DEBUG_MODE = 'Y' THEN
183: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err - Option Level Code should not be NULL';
184: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
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:
196: IF P_PA_DEBUG_MODE = 'Y' THEN
197: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Plan Type ID cannot be NULL.';
198: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
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;
211: IF P_PA_DEBUG_MODE = 'Y' THEN
212: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Plan Type ID cannot be NULL.';
213: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
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);
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;
272: IF P_PA_DEBUG_MODE = 'Y' THEN
273: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err - FP Preference Code should not be NULL';
274: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
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;
312: IF P_PA_DEBUG_MODE = 'Y' THEN
313: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err- Project ID cannot be NULL.';
314: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
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;
345: ,x_msg_data => x_msg_data);
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
455: ,x_msg_data => x_msg_data);
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 */
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
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;
1027: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1028: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
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 ;
1029: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
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:
1030:
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
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
1031: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
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
1032: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
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;
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
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;
1044: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1045: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1051: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1052: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1053:
1046: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1051: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1052: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1053:
1054: END IF;
1047:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1051: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1052: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1053:
1054: END IF;
1055:
1048: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1051: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1052: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1053:
1054: END IF;
1055:
1056: /* Bug 3149010 - If source and target are versions we need not and should not
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:
1070: -- Start of FP M Phase II development changes
1071: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
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:
1070: -- Start of FP M Phase II development changes
1071: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1072: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
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:
1070: -- Start of FP M Phase II development changes
1071: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1072: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
1073:
1074: -- Do not over write rate schedule data if target is AR version
1075: OPEN opt_info_Cur(px_target_proj_fp_option_id);
1068: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1069:
1070: -- Start of FP M Phase II development changes
1071: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1072: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
1073:
1074: -- Do not over write rate schedule data if target is AR version
1075: OPEN opt_info_Cur(px_target_proj_fp_option_id);
1076: FETCH opt_info_Cur INTO opt_info_rec;
1077: CLOSE opt_info_Cur;
1078:
1079: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1080:
1081: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1078:
1079: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1080:
1081: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1079: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1080:
1081: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1080:
1081: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1081: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1082: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1083: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1084: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1085: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1086: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1087: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1088: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1099: ***/
1092: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1099: ***/
1100: END IF;
1093: /*** Bug 3580727
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1099: ***/
1100: END IF;
1101:
1094: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1099: ***/
1100: END IF;
1101:
1102: -- Do not over write generation options data if target and source versions
1101:
1102: -- Do not over write generation options data if target and source versions
1103: -- belong to different plan classes.
1104: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1105: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1102: -- Do not over write generation options data if target and source versions
1103: -- belong to different plan classes.
1104: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1105: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1103: -- belong to different plan classes.
1104: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1105: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1104: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1105: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1105: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1106: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1107: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1108: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1109: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1110: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1111: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1112: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1114: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1115: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1117:
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1121: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: ***/
1123: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: ***/
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1125: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: ***/
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: /*** Bug 3580727
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: ***/
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: ***/
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1130: ***/
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1132:
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1136: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1137: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1138: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1146: END IF;
1139: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1146: END IF;
1147: -- End of FP M Phase II development changes
1140: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1146: END IF;
1147: -- End of FP M Phase II development changes
1148:
1141: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1146: END IF;
1147: -- End of FP M Phase II development changes
1148:
1149: END IF;
1451: ,x_return_status => x_return_status
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
1466: ,x_msg_count => x_msg_count
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
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,
1489: p_msg_index => 1,
1490: p_msg_count => l_msg_count,
1491: p_msg_data => l_msg_data,
1492: p_data => l_data,
1500: pa_debug.reset_err_stack;
1501: END IF;
1502: RAISE;
1503: WHEN OTHERS THEN
1504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1505: x_msg_count := 1;
1506: x_msg_data := SQLERRM;
1507: FND_MSG_PUB.add_exc_msg
1508: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option'
1594: l_debug_mode := NVL(l_debug_mode, 'Y');
1595: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1596: END IF;
1597:
1598: x_return_status := FND_API.G_RET_STS_SUCCESS;
1599:
1600: SELECT fin_plan_preference_code,
1601: fin_plan_option_level_code,
1602: project_id
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);
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:
1949: ,x_return_status => x_return_status
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
2115: ,x_message_count => l_msg_count
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 --------------------------
2272: ,x_return_status => x_return_status
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
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,
2420: p_msg_index => 1,
2421: p_msg_count => l_msg_count,
2422: p_msg_data => l_msg_data,
2423: p_data => l_data,
2431: pa_debug.reset_err_stack;
2432: END IF;
2433: RAISE;
2434: WHEN OTHERS THEN
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436: x_msg_count := 1;
2437: x_msg_data := SQLERRM;
2438: FND_MSG_PUB.add_exc_msg
2439: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options'
2783: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2784: l_debug_mode := NVL(l_debug_mode, 'Y');
2785: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2786: END IF;
2787: l_return_status := FND_API.G_RET_STS_SUCCESS;
2788: -- begin: Bug 5941436: fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'); has been changed with fnd_profile.value('PA_FP_WEBADI_ENABLE'); to perform less sqls and use caching and therefore to improve the performance
2789: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2790: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2791: -- end: Bug 5941436
2849: X_RETURN_STATUS => l_return_status,
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 */
2939: , x_msg_count => l_msg_count
2940: , x_msg_data => l_msg_data
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;
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
3524: ,p_msg_index => 1
3525: ,p_msg_count => l_msg_count
3526: ,p_msg_data => l_msg_data
3527: ,p_data => l_data
3698: l_debug_mode := NVL(l_debug_mode, 'Y');
3699: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3700: END IF;
3701: x_msg_count := 0;
3702: x_return_status := FND_API.G_RET_STS_SUCCESS;
3703:
3704: -- Check if budget version id is null. if yes
3705: -- throw an error.
3706:
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
3921: ,p_msg_index => 1
3922: ,p_msg_count => l_msg_count
3923: ,p_msg_data => l_msg_data
3924: ,p_data => l_data
3927: x_msg_count := l_msg_count;
3928: ELSE
3929: x_msg_count := l_msg_count;
3930: END IF;
3931: x_return_status := FND_API.G_RET_STS_ERROR;
3932: IF P_PA_DEBUG_MODE = 'Y' THEN
3933: pa_debug.g_err_stage:='Invalid Arguments Passed';
3934: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,5);
3935: pa_debug.reset_err_stack;
3936: END IF;
3937: RETURN;
3938:
3939: WHEN Others THEN
3940: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3941: x_msg_count := 1;
3942: x_msg_data := SQLERRM;
3943: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB'
3944: ,p_procedure_name => 'SYNCHRONIZE_BUDGET_VERSION');
4042: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
4058: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
4074: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
4106: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
4122: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
4138: ,x_fin_plan_version_id => l_gen_src_plan_version_id
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
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
4173: ,p_msg_index => 1
4174: ,p_msg_count => l_msg_count
4175: ,p_msg_data => l_msg_data
4176: ,p_data => l_data
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
4299: ,p_msg_index => 1
4300: ,p_msg_count => l_msg_count
4301: ,p_msg_data => l_msg_data
4302: ,p_data => l_data
4388: l_debug_mode := NVL(l_debug_mode, 'Y');
4389: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4390: END IF;
4391:
4392: x_return_status := FND_API.G_RET_STS_SUCCESS;
4393:
4394: IF p_project_id IS NULL OR p_fin_plan_type_id IS NULL OR p_plan_preference_code IS NULL THEN
4395:
4396: l_stage := 340;
4397: IF P_PA_DEBUG_MODE = 'Y' THEN
4398: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err - projectid or plan types id or pref code id is NULL';
4399: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
4400: END IF;
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;
4429:
4430: BEGIN
4431: IF p_cost_layout_code IS NULL THEN
4432:
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;
4465: -- ,x_msg_count => l_msg_count
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
4496:
4497: BEGIN
4498: IF p_revenue_layout_code IS NULL THEN
4499:
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;
4524: -- ,x_return_status => l_return_status
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
4552: BEGIN
4553: IF p_all_layout_code IS NULL THEN
4554:
4555:
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;
4592: -- ,x_return_status => l_return_status
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
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
4759: ,p_msg_index => 1
4760: ,p_msg_count => l_msg_count
4761: ,p_msg_data => l_msg_data
4762: ,p_data => l_data
4770: IF p_pa_debug_mode = 'Y' THEN
4771: pa_debug.g_err_stage:='Invalid Arguments Passed';
4772: pa_debug.write('Create_amt_types: ' || l_module_name,pa_debug.g_err_stage,5);
4773: END IF;
4774: x_return_status := FND_API.G_RET_STS_ERROR;
4775: pa_debug.reset_curr_function;
4776: RAISE;
4777:
4778: WHEN OTHERS THEN
4781: 'Create_amt_types'
4782: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4783: pa_debug.g_err_stage := 'Unexpected error in Create_amt_types:';
4784: pa_debug.write('Create_amt_types: ' || l_module_name,pa_debug.g_err_stage,5);
4785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4786: pa_debug.Reset_Curr_Function;
4787: RAISE;
4788:
4789: END Create_amt_types;
4825: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4826: p_debug_mode => l_debug_mode );
4827:
4828: x_msg_count := 0;
4829: x_return_status := FND_API.G_RET_STS_SUCCESS;
4830:
4831: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4832: l_debug_mode := NVL(l_debug_mode, 'Y');
4833:
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
4897: ,p_msg_index => 1
4898: ,p_msg_count => l_msg_count
4899: ,p_msg_data => l_msg_data
4900: ,p_data => l_data
4907: END IF;
4908: pa_debug.reset_curr_function();
4909:
4910: WHEN OTHERS THEN
4911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4912: x_msg_count := 1;
4913: x_msg_data := SQLERRM;
4914:
4915: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'
4959: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4960: p_debug_mode => l_debug_mode );
4961:
4962: x_msg_count := 0;
4963: x_return_status := FND_API.G_RET_STS_SUCCESS;
4964:
4965: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4966: l_debug_mode := NVL(l_debug_mode, 'Y');
4967:
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
5145: ,p_msg_index => 1
5146: ,p_msg_count => l_msg_count
5147: ,p_msg_data => l_msg_data
5148: ,p_data => l_data
5155: END IF;
5156: pa_debug.reset_curr_function();
5157:
5158: WHEN OTHERS THEN
5159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5160: x_msg_count := 1;
5161: x_msg_data := SQLERRM;
5162:
5163: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'