[Home] [Help]
547:
548: IF P_PROJECT_ID is null or p_budget_version_id is null THEN
549: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
550: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
551: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
552: END IF;
553:
554: l_rev_gen_method := nvl(P_FP_COLS_REC.X_REVENUE_DERIVATION_METHOD,PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id)); --Bug 5462471
555: --l_rev_gen_method := PA_FP_GEN_FCST_PG_PKG.GET_REV_GEN_METHOD(p_project_id);
670: p_log_level => 5);
671: END IF;
672: --dbms_output.put_line('After calling pji api: '||x_return_status);
673: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
674: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
675: END IF;
676:
677: IF l_count = 0 THEN
678: IF P_PA_DEBUG_MODE = 'Y' THEN
691:
692: IF l_count_no_rlm > 0 THEN
693: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
694: p_msg_name => 'PA_FP_NO_RLM_ID_FOR_ACTUAL');
695: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
696: END IF;
697:
698: /* Update rlm_id for all rows in pji_fm_xbs_accum_tmp1 if the resource list
699: * (p_fp_cols_rec.X_RESOURCE_LIST_ID) is None - Uncategorized.
758: p_module_name => l_module_name,
759: p_log_level => 5);
760: END IF;
761: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
762: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
763: END IF;
764:
765: /**Calling update_res_asg to populate the newly created resource_assignment_id back to
766: *pa_fp_planning_res_tmp1. Then this value needs to populated back to pji_fm_xbs_accum_tmp1
785: p_module_name => l_module_name,
786: p_log_level => 5);
787: END IF;
788: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
789: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
790: END IF;
791:
792: UPDATE PJI_FM_XBS_ACCUM_TMP1 tmp1
793: SET source_id =
1029: p_module_name => l_module_name,
1030: p_log_level => 5);
1031: END IF;
1032: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1033: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1034: END IF;
1035:
1036: END LOOP;
1037:
1061: p_module_name => l_module_name,
1062: p_log_level => 5 );
1063: END IF;
1064: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1065: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1066: END IF;
1067:
1068: -- IPM: New Entity ER ------------------------------------------
1069: -- Actual amounts must be rolled up for non-timephased versions
1117: --P_CALLED_MODE => p_called_mode,
1118: P_MODULE_NAME => l_module_name);
1119: END IF;
1120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1121: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1122: END IF;
1123:
1124: END IF; -- IF p_fp_cols_rec.x_time_phased_code = 'N' THEN
1125: -- END OF IPM: New Entity ER ------------------------------------------
1130: IF P_PA_DEBUG_MODE = 'Y' THEN
1131: PA_DEBUG.RESET_CURR_FUNCTION;
1132: END IF;
1133: EXCEPTION
1134: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1135: l_msg_count := FND_MSG_PUB.count_msg;
1136: IF l_msg_count = 1 THEN
1137: PA_INTERFACE_UTILS_PUB.get_messages
1138: ( p_encoded => FND_API.G_TRUE,
1369: p_module_name => l_module_name,
1370: p_log_level => 5);
1371: END IF;
1372: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1373: raise PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1374: END IF;
1375: ELSE
1376: l_fp_cols_rec := P_FP_COLS_REC;
1377: END IF;
1511: p_module_name => l_module_name,
1512: p_log_level => 5);
1513: END IF;
1514: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
1515: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1516: END IF;
1517:
1518: SELECT spread_curve_id
1519: INTO l_spread_curve_id
1529: IF P_PA_DEBUG_MODE = 'Y' THEN
1530: PA_DEBUG.RESET_CURR_FUNCTION;
1531: END IF;
1532: EXCEPTION
1533: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1534: l_msg_count := FND_MSG_PUB.count_msg;
1535: IF l_msg_count = 1 THEN
1536: PA_INTERFACE_UTILS_PUB.get_messages
1537: ( p_encoded => FND_API.G_TRUE,
1688: IF P_PA_DEBUG_MODE = 'Y' THEN
1689: PA_DEBUG.RESET_CURR_FUNCTION;
1690: END IF;
1691: EXCEPTION
1692: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
1693: l_msg_count := FND_MSG_PUB.count_msg;
1694: IF l_msg_count = 1 THEN
1695: PA_INTERFACE_UTILS_PUB.get_messages
1696: ( p_encoded => FND_API.G_TRUE,