[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 */
1027: /* Bug 3149010 - Logic of not overwritting attribs when the target is ALL */
1028:
1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1028:
1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1029: IF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_REVENUE_ONLY AND
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1030: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1031: FP_Mc_Cols_Rec.projfunc_cost_rate_type := FND_API.G_MISS_CHAR;
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1032: FP_Mc_Cols_Rec.projfunc_cost_rate_date_type := FND_API.G_MISS_CHAR;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1033: FP_Mc_Cols_Rec.projfunc_cost_rate_date := FND_API.G_MISS_DATE;
1034: FP_Mc_Cols_Rec.project_cost_rate_type := FND_API.G_MISS_CHAR;
1035: FP_Mc_Cols_Rec.project_cost_rate_date_type := FND_API.G_MISS_CHAR;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1036: FP_Mc_Cols_Rec.project_cost_rate_date := FND_API.G_MISS_DATE;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1037: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1038:
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1039: -- Bug 3580727 do not over write cost rate schedule columns
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1040: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1041: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1042: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1043: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1044: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1045:
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1046: ELSIF l_source_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_ONLY AND
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1047: l_fp_preference_code = PA_FP_CONSTANTS_PKG.G_PREF_COST_AND_REV_SAME THEN
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1048: FP_Mc_Cols_Rec.projfunc_rev_rate_type := FND_API.G_MISS_CHAR;
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1049: FP_Mc_Cols_Rec.projfunc_rev_rate_date_type := FND_API.G_MISS_CHAR;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1050: FP_Mc_Cols_Rec.projfunc_rev_rate_date := FND_API.G_MISS_DATE;
1051: FP_Mc_Cols_Rec.project_rev_rate_type := FND_API.G_MISS_CHAR;
1052: FP_Mc_Cols_Rec.project_rev_rate_date_type := FND_API.G_MISS_CHAR;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1058: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1053: FP_Mc_Cols_Rec.project_rev_rate_date := FND_API.G_MISS_DATE;
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1058: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1059: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1060: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1061:
1054: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1058: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1059: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1060: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1061:
1062: END IF;
1055:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1058: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1059: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1060: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1061:
1062: END IF;
1063:
1056: -- Bug 3580727 do not over write revenue rate schedule columns
1057: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1058: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1059: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1060: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1061:
1062: END IF;
1063:
1064: /* Bug 3149010 - If source and target are versions we need not and should not
1071: */
1072: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1073: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1074:
1075: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1077:
1078: -- Start of FP M Phase II development changes
1079: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1072: IF l_source_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION AND
1073: l_target_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_VERSION THEN
1074:
1075: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1077:
1078: -- Start of FP M Phase II development changes
1079: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1080: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
1075: FP_Mc_Cols_Rec.approved_rev_plan_type_flag := FND_API.G_MISS_CHAR;
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1077:
1078: -- Start of FP M Phase II development changes
1079: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1080: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
1081:
1082: -- Do not over write rate schedule data if target is AR version
1083: OPEN opt_info_Cur(px_target_proj_fp_option_id);
1076: FP_Mc_Cols_Rec.approved_cost_plan_type_flag := FND_API.G_MISS_CHAR;
1077:
1078: -- Start of FP M Phase II development changes
1079: FP_Mc_Cols_Rec.primary_cost_forecast_flag := FND_API.G_MISS_CHAR;
1080: FP_Mc_Cols_Rec.primary_rev_forecast_flag := FND_API.G_MISS_CHAR;
1081:
1082: -- Do not over write rate schedule data if target is AR version
1083: OPEN opt_info_Cur(px_target_proj_fp_option_id);
1084: FETCH opt_info_Cur INTO opt_info_rec;
1085: CLOSE opt_info_Cur;
1086:
1087: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1088:
1089: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1086:
1087: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1088:
1089: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1087: IF opt_info_rec.approved_rev_plan_type_flag = 'Y' THEN
1088:
1089: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1088:
1089: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1089: FP_Cols_Rec.use_planning_rates_flag := FND_API.G_MISS_CHAR ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1090: FP_Cols_Rec.res_class_raw_cost_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1091: FP_Cols_Rec.res_class_bill_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1092: FP_Cols_Rec.cost_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1093: FP_Cols_Rec.cost_job_rate_sch_id := FND_API.G_MISS_NUM ;
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1094: FP_Cols_Rec.cost_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1095: FP_Cols_Rec.cost_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1096: FP_Cols_Rec.cost_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1097: FP_Cols_Rec.rev_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1098: FP_Cols_Rec.rev_job_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1105: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1106: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1099: FP_Cols_Rec.rev_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1105: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1106: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1107: ***/
1100: FP_Cols_Rec.rev_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1105: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1106: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1107: ***/
1108: END IF;
1101: /*** Bug 3580727
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1105: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1106: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1107: ***/
1108: END IF;
1109:
1102: FP_Cols_Rec.all_emp_rate_sch_id := FND_API.G_MISS_NUM ;
1103: FP_Cols_Rec.all_job_rate_sch_id := FND_API.G_MISS_NUM ;
1104: FP_Cols_Rec.all_non_labor_res_rate_sch_id := FND_API.G_MISS_NUM ;
1105: FP_Cols_Rec.all_res_class_rate_sch_id := FND_API.G_MISS_NUM ;
1106: FP_Cols_Rec.all_burden_rate_sch_id := FND_API.G_MISS_NUM ;
1107: ***/
1108: END IF;
1109:
1110: -- Do not over write generation options data if target and source versions
1109:
1110: -- Do not over write generation options data if target and source versions
1111: -- belong to different plan classes.
1112: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1113: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1110: -- Do not over write generation options data if target and source versions
1111: -- belong to different plan classes.
1112: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1113: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1111: -- belong to different plan classes.
1112: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1113: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1112: IF plan_type_info_rec.plan_class_code <> nvl(l_source_plan_class_code, '-9999') THEN
1113: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1113: FP_Cols_Rec.gen_cost_src_code := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1114: FP_Cols_Rec.gen_cost_etc_src_code := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1115: FP_Cols_Rec.gen_src_cost_plan_type_id := FND_API.G_MISS_NUM;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1116: FP_Cols_Rec.gen_src_cost_plan_version_id := FND_API.G_MISS_NUM;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1117: FP_Cols_Rec.gen_src_cost_plan_ver_code := FND_API.G_MISS_CHAR;
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1118: FP_Cols_Rec.gen_src_cost_wp_version_id := FND_API.G_MISS_NUM;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1119: FP_Cols_Rec.gen_src_cost_wp_ver_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1120: FP_Cols_Rec.gen_cost_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1121: FP_Cols_Rec.gen_cost_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1122: FP_Cols_Rec.gen_cost_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1123: FP_Cols_Rec.gen_cost_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1124: FP_Cols_Rec.gen_cost_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1125:
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1126: FP_Cols_Rec.gen_rev_src_code := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1127: FP_Cols_Rec.gen_rev_etc_src_code := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1128: FP_Cols_Rec.gen_src_rev_wp_version_id := FND_API.G_MISS_NUM;
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1129: FP_Cols_Rec.gen_src_rev_wp_ver_code := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1130: FP_Cols_Rec.gen_src_rev_plan_type_id := FND_API.G_MISS_NUM;
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1138: ***/
1131: FP_Cols_Rec.gen_src_rev_plan_version_id := FND_API.G_MISS_NUM;
1132: FP_Cols_Rec.gen_src_rev_plan_ver_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1138: ***/
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1133: FP_Cols_Rec.gen_rev_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1134: FP_Cols_Rec.gen_rev_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1138: ***/
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1135: FP_Cols_Rec.gen_rev_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1136: /*** Bug 3580727
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1138: ***/
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1137: FP_Cols_Rec.gen_rev_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1138: ***/
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1138: ***/
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1139: FP_Cols_Rec.gen_rev_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1140:
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1141: FP_Cols_Rec.gen_all_src_code := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1142: FP_Cols_Rec.gen_all_etc_src_code := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1143: FP_Cols_Rec.gen_src_all_plan_type_id := FND_API.G_MISS_NUM;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1144: FP_Cols_Rec.gen_src_all_plan_version_id := FND_API.G_MISS_NUM;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1145: FP_Cols_Rec.gen_src_all_plan_ver_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1146: FP_Cols_Rec.gen_src_all_wp_version_id := FND_API.G_MISS_NUM;
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1154: FP_Cols_Rec.copy_etc_from_plan_flag := FND_API.G_MISS_CHAR; --bug#8318932
1147: FP_Cols_Rec.gen_src_all_wp_ver_code := FND_API.G_MISS_CHAR;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1154: FP_Cols_Rec.copy_etc_from_plan_flag := FND_API.G_MISS_CHAR; --bug#8318932
1155: END IF;
1148: FP_Cols_Rec.gen_all_incl_change_doc_flag := FND_API.G_MISS_CHAR;
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1154: FP_Cols_Rec.copy_etc_from_plan_flag := FND_API.G_MISS_CHAR; --bug#8318932
1155: END IF;
1156: -- End of FP M Phase II development changes
1149: FP_Cols_Rec.gen_all_incl_open_comm_flag := FND_API.G_MISS_CHAR;
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1154: FP_Cols_Rec.copy_etc_from_plan_flag := FND_API.G_MISS_CHAR; --bug#8318932
1155: END IF;
1156: -- End of FP M Phase II development changes
1157:
1150: FP_Cols_Rec.gen_all_ret_manual_line_flag := FND_API.G_MISS_CHAR;
1151: FP_Cols_Rec.gen_all_incl_bill_event_flag := FND_API.G_MISS_CHAR;
1152: FP_Cols_Rec.gen_all_incl_unspent_amt_flag := FND_API.G_MISS_CHAR;
1153: FP_Cols_Rec.gen_all_actual_amts_thru_code := FND_API.G_MISS_CHAR;
1154: FP_Cols_Rec.copy_etc_from_plan_flag := FND_API.G_MISS_CHAR; --bug#8318932
1155: END IF;
1156: -- End of FP M Phase II development changes
1157:
1158: END IF;
1472: ,x_return_status => x_return_status
1473: ,x_msg_count => x_msg_count
1474: ,x_msg_data => x_msg_data);
1475:
1476: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1477: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1478: END IF;
1479:
1480: ELSE
1487: ,x_msg_count => x_msg_count
1488: ,x_msg_data => x_msg_data );
1489:
1490:
1491: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1492: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1493: END IF;
1494: END IF; -- source project is null
1495: END IF; -- web adi profile
1505: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1506: l_msg_count := FND_MSG_PUB.count_msg;
1507: IF l_msg_count = 1 THEN
1508: PA_INTERFACE_UTILS_PUB.get_messages
1509: (p_encoded => FND_API.G_TRUE,
1510: p_msg_index => 1,
1511: p_msg_count => l_msg_count,
1512: p_msg_data => l_msg_data,
1513: p_data => l_data,
1521: pa_debug.reset_err_stack;
1522: END IF;
1523: RAISE;
1524: WHEN OTHERS THEN
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526: x_msg_count := 1;
1527: x_msg_data := SQLERRM;
1528: FND_MSG_PUB.add_exc_msg
1529: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Create_FP_Option'
1615: l_debug_mode := NVL(l_debug_mode, 'Y');
1616: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
1617: END IF;
1618:
1619: x_return_status := FND_API.G_RET_STS_SUCCESS;
1620:
1621: SELECT fin_plan_preference_code,
1622: fin_plan_option_level_code,
1623: project_id
1658: IF P_PA_DEBUG_MODE = 'Y' THEN
1659: pa_debug.g_err_stage := 'Err- Invalid Combination of Source and Target Preference code';
1660: pa_debug.write('Get_FP_Options: ' || l_module_name,pa_debug.g_err_stage,5);
1661: END IF;
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1664: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
1665: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1666:
1976: ,x_return_status => x_return_status
1977: ,x_message_data => l_msg_data);
1978:
1979: --added for bug 2708782
1980: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1981: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1982: END IF;
1983:
1984: IF P_PA_DEBUG_MODE = 'Y' THEN
2148: ,x_message_count => l_msg_count
2149: ,x_return_status => x_return_status
2150: ,x_message_data => l_msg_data);
2151:
2152: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2153: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2154: END IF;
2155:
2156: -- Bug 3362316, 08-JAN-2003: Added New FP.M Columns --------------------------
2311: ,x_return_status => x_return_status
2312: ,x_message_data => l_msg_data);
2313:
2314: --added for bug 2708782
2315: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2316: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2317: END IF;
2318:
2319: IF P_PA_DEBUG_MODE = 'Y' THEN
2460: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2461: l_msg_count := FND_MSG_PUB.count_msg;
2462: IF l_msg_count = 1 THEN
2463: PA_INTERFACE_UTILS_PUB.get_messages
2464: (p_encoded => FND_API.G_TRUE,
2465: p_msg_index => 1,
2466: p_msg_count => l_msg_count,
2467: p_msg_data => l_msg_data,
2468: p_data => l_data,
2476: pa_debug.reset_err_stack;
2477: END IF;
2478: RAISE;
2479: WHEN OTHERS THEN
2480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2481: x_msg_count := 1;
2482: x_msg_data := SQLERRM;
2483: FND_MSG_PUB.add_exc_msg
2484: ( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB.Get_FP_Options'
2828: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2829: l_debug_mode := NVL(l_debug_mode, 'Y');
2830: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
2831: END IF;
2832: l_return_status := FND_API.G_RET_STS_SUCCESS;
2833: -- 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
2834: -- Bug 6413612 : Added substr to fetch only 1 character of profile value
2835: l_webadi_profile := UPPER(SUBSTR(fnd_profile.value_specific('PA_FP_WEBADI_ENABLE'),1,1));
2836: -- end: Bug 5941436
2894: X_RETURN_STATUS => l_return_status,
2895: X_MESSAGE_DATA => l_msg_data);
2896:
2897: --added for bug 2708782
2898: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2899: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2900: END IF;
2901:
2902: /* Following code is added in context of autobaseline */
2984: , x_msg_count => l_msg_count
2985: , x_msg_data => l_msg_data
2986: , x_return_status => l_return_status);
2987:
2988: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
2989: pa_debug.g_err_stage:= 'Could not obtain currency info for the project';
2990: pa_debug.write(l_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
2991: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2992: END IF;
3564: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3565: l_msg_count := FND_MSG_PUB.count_msg;
3566: IF l_msg_count = 1 THEN
3567: PA_INTERFACE_UTILS_PUB.get_messages
3568: (p_encoded => FND_API.G_TRUE
3569: ,p_msg_index => 1
3570: ,p_msg_count => l_msg_count
3571: ,p_msg_data => l_msg_data
3572: ,p_data => l_data
3743: l_debug_mode := NVL(l_debug_mode, 'Y');
3744: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
3745: END IF;
3746: x_msg_count := 0;
3747: x_return_status := FND_API.G_RET_STS_SUCCESS;
3748:
3749: -- Check if budget version id is null. if yes
3750: -- throw an error.
3751:
3961: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3962: l_msg_count := FND_MSG_PUB.count_msg;
3963: IF l_msg_count = 1 THEN
3964: PA_INTERFACE_UTILS_PUB.get_messages
3965: (p_encoded => FND_API.G_TRUE
3966: ,p_msg_index => 1
3967: ,p_msg_count => l_msg_count
3968: ,p_msg_data => l_msg_data
3969: ,p_data => l_data
3972: x_msg_count := l_msg_count;
3973: ELSE
3974: x_msg_count := l_msg_count;
3975: END IF;
3976: x_return_status := FND_API.G_RET_STS_ERROR;
3977: IF P_PA_DEBUG_MODE = 'Y' THEN
3978: pa_debug.g_err_stage:='Invalid Arguments Passed';
3979: pa_debug.write('SYNCHRONIZE_BUDGET_VERSION: ' || l_module_name,pa_debug.g_err_stage,5);
3980: pa_debug.reset_err_stack;
3981: END IF;
3982: RETURN;
3983:
3984: WHEN Others THEN
3985: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3986: x_msg_count := 1;
3987: x_msg_data := SQLERRM;
3988: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PROJ_FP_OPTIONS_PUB'
3989: ,p_procedure_name => 'SYNCHRONIZE_BUDGET_VERSION');
4087: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4088: ,x_return_status => l_return_status
4089: ,x_msg_count => l_msg_count
4090: ,x_msg_data => l_msg_data );
4091: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4092: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4093: END IF;
4094:
4095: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4103: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4104: ,x_return_status => l_return_status
4105: ,x_msg_count => l_msg_count
4106: ,x_msg_data => l_msg_data );
4107: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4108: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4109: END IF;
4110:
4111: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4119: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4120: ,x_return_status => l_return_status
4121: ,x_msg_count => l_msg_count
4122: ,x_msg_data => l_msg_data );
4123: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4124: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4125: END IF;
4126:
4127: END IF; -- p_gen_src_plan_ver_code
4151: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4152: ,x_return_status => l_return_status
4153: ,x_msg_count => l_msg_count
4154: ,x_msg_data => l_msg_data );
4155: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4156: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4157: END IF;
4158:
4159: ELSIF p_gen_src_plan_ver_code = 'CURRENT_WORKING' THEN
4167: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4168: ,x_return_status => l_return_status
4169: ,x_msg_count => l_msg_count
4170: ,x_msg_data => l_msg_data );
4171: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4173: END IF;
4174:
4175: ELSIF p_gen_src_plan_ver_code IN ('ORIGINAL_APPROVED','ORIGINAL_BASELINED') THEN
4183: ,x_fin_plan_version_id => l_gen_src_plan_version_id
4184: ,x_return_status => l_return_status
4185: ,x_msg_count => l_msg_count
4186: ,x_msg_data => l_msg_data );
4187: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4188: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4189: END IF;
4190:
4191: END IF; -- p_gen_src_plan_ver_code
4213: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4214: l_msg_count := FND_MSG_PUB.count_msg;
4215: IF l_msg_count = 1 THEN
4216: PA_INTERFACE_UTILS_PUB.get_messages
4217: (p_encoded => FND_API.G_TRUE
4218: ,p_msg_index => 1
4219: ,p_msg_count => l_msg_count
4220: ,p_msg_data => l_msg_data
4221: ,p_data => l_data
4339: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4340: l_msg_count := FND_MSG_PUB.count_msg;
4341: IF l_msg_count = 1 THEN
4342: PA_INTERFACE_UTILS_PUB.get_messages
4343: (p_encoded => FND_API.G_TRUE
4344: ,p_msg_index => 1
4345: ,p_msg_count => l_msg_count
4346: ,p_msg_data => l_msg_data
4347: ,p_data => l_data
4433: l_debug_mode := NVL(l_debug_mode, 'Y');
4434: pa_debug.set_process('PLSQL','LOG',l_debug_mode);
4435: END IF;
4436:
4437: x_return_status := FND_API.G_RET_STS_SUCCESS;
4438:
4439: IF p_project_id IS NULL OR p_fin_plan_type_id IS NULL OR p_plan_preference_code IS NULL THEN
4440:
4441: l_stage := 340;
4442: IF P_PA_DEBUG_MODE = 'Y' THEN
4443: pa_debug.g_err_stage := TO_CHAR(l_Stage)||': Err - projectid or plan types id or pref code id is NULL';
4444: pa_debug.write('Create_FP_Option: ' || l_module_name,pa_debug.g_err_stage,5);
4445: END IF;
4446: x_return_status := FND_API.G_RET_STS_ERROR;
4447: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4448: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4449: PA_DEBUG.Reset_Curr_Function;
4450: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4474:
4475: BEGIN
4476: IF p_cost_layout_code IS NULL THEN
4477:
4478: x_return_status := FND_API.G_RET_STS_ERROR;
4479: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4480: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4481: PA_DEBUG.Reset_Curr_Function;
4482: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4510: -- ,x_msg_count => l_msg_count
4511: -- ,x_msg_data => l_msg_data );
4512: --
4513: --
4514: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4515: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4516: -- END IF;
4517: END IF;
4518: IF l_cost_layout_type_code = 'PERIODIC_BUDGET' THEN
4541:
4542: BEGIN
4543: IF p_revenue_layout_code IS NULL THEN
4544:
4545: x_return_status := FND_API.G_RET_STS_ERROR;
4546: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4547: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4548: PA_DEBUG.Reset_Curr_Function;
4549: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4569: -- ,x_return_status => l_return_status
4570: -- ,x_msg_count => l_msg_count
4571: -- ,x_msg_data => l_msg_data );
4572: --
4573: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4574: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4575: -- END IF;
4576: END IF;
4577: IF l_revenue_layout_type_code = 'PERIODIC_BUDGET' THEN
4597: BEGIN
4598: IF p_all_layout_code IS NULL THEN
4599:
4600:
4601: x_return_status := FND_API.G_RET_STS_ERROR;
4602: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
4603: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
4604: PA_DEBUG.Reset_Curr_Function;
4605: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4637: -- ,x_return_status => l_return_status
4638: -- ,x_msg_count => l_msg_count
4639: -- ,x_msg_data => l_msg_data );
4640: --
4641: -- IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4642: -- raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
4643: -- END IF;
4644: END IF;
4645: IF l_all_layout_type_code = 'PERIODIC_BUDGET' THEN
4799: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4800: l_msg_count := FND_MSG_PUB.count_msg;
4801: IF l_msg_count = 1 THEN
4802: PA_INTERFACE_UTILS_PUB.get_messages
4803: (p_encoded => FND_API.G_TRUE
4804: ,p_msg_index => 1
4805: ,p_msg_count => l_msg_count
4806: ,p_msg_data => l_msg_data
4807: ,p_data => l_data
4815: IF p_pa_debug_mode = 'Y' THEN
4816: pa_debug.g_err_stage:='Invalid Arguments Passed';
4817: pa_debug.write('Create_amt_types: ' || l_module_name,pa_debug.g_err_stage,5);
4818: END IF;
4819: x_return_status := FND_API.G_RET_STS_ERROR;
4820: pa_debug.reset_curr_function;
4821: RAISE;
4822:
4823: WHEN OTHERS THEN
4826: 'Create_amt_types'
4827: ,p_procedure_name => PA_DEBUG.G_Err_Stack);
4828: pa_debug.g_err_stage := 'Unexpected error in Create_amt_types:';
4829: pa_debug.write('Create_amt_types: ' || l_module_name,pa_debug.g_err_stage,5);
4830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4831: pa_debug.Reset_Curr_Function;
4832: RAISE;
4833:
4834: END Create_amt_types;
4870: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
4871: p_debug_mode => l_debug_mode );
4872:
4873: x_msg_count := 0;
4874: x_return_status := FND_API.G_RET_STS_SUCCESS;
4875:
4876: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
4877: l_debug_mode := NVL(l_debug_mode, 'Y');
4878:
4937: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
4938: l_msg_count := FND_MSG_PUB.count_msg;
4939: IF l_msg_count = 1 THEN
4940: PA_INTERFACE_UTILS_PUB.get_messages
4941: (p_encoded => FND_API.G_TRUE
4942: ,p_msg_index => 1
4943: ,p_msg_count => l_msg_count
4944: ,p_msg_data => l_msg_data
4945: ,p_data => l_data
4952: END IF;
4953: pa_debug.reset_curr_function();
4954:
4955: WHEN OTHERS THEN
4956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4957: x_msg_count := 1;
4958: x_msg_data := SQLERRM;
4959:
4960: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'
5004: PA_DEBUG.Set_Curr_Function( p_function => l_module_name,
5005: p_debug_mode => l_debug_mode );
5006:
5007: x_msg_count := 0;
5008: x_return_status := FND_API.G_RET_STS_SUCCESS;
5009:
5010: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
5011: l_debug_mode := NVL(l_debug_mode, 'Y');
5012:
5185: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
5186: l_msg_count := FND_MSG_PUB.count_msg;
5187: IF l_msg_count = 1 THEN
5188: PA_INTERFACE_UTILS_PUB.get_messages
5189: (p_encoded => FND_API.G_TRUE
5190: ,p_msg_index => 1
5191: ,p_msg_count => l_msg_count
5192: ,p_msg_data => l_msg_data
5193: ,p_data => l_data
5200: END IF;
5201: pa_debug.reset_curr_function();
5202:
5203: WHEN OTHERS THEN
5204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5205: x_msg_count := 1;
5206: x_msg_data := SQLERRM;
5207:
5208: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_proj_fp_options_pub'