eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_BUDGET_PVT dependencies on PA_FP_CONSTANTS_PKG

Line 85: IF (nvl(p_pv_project_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND

81: END IF;
82:
83: x_is_rate_type_valid := TRUE;
84:
85: IF (nvl(p_pv_project_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
86: nvl(p_pt_project_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
87:
88: x_is_rate_type_valid := FALSE;
89:

Line 86: nvl(p_pt_project_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN

82:
83: x_is_rate_type_valid := TRUE;
84:
85: IF (nvl(p_pv_project_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
86: nvl(p_pt_project_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
87:
88: x_is_rate_type_valid := FALSE;
89:
90: END IF;

Line 92: IF (nvl(p_pv_project_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND

88: x_is_rate_type_valid := FALSE;
89:
90: END IF;
91:
92: IF (nvl(p_pv_project_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
93: nvl(p_pt_project_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
94:
95: x_is_rate_type_valid := FALSE;
96:

Line 93: nvl(p_pt_project_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN

89:
90: END IF;
91:
92: IF (nvl(p_pv_project_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
93: nvl(p_pt_project_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
94:
95: x_is_rate_type_valid := FALSE;
96:
97: END IF;

Line 99: IF (nvl(p_pv_projfunc_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND

95: x_is_rate_type_valid := FALSE;
96:
97: END IF;
98:
99: IF (nvl(p_pv_projfunc_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
100: nvl(p_pt_projfunc_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
101:
102: x_is_rate_type_valid := FALSE;
103:

Line 100: nvl(p_pt_projfunc_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN

96:
97: END IF;
98:
99: IF (nvl(p_pv_projfunc_cost_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
100: nvl(p_pt_projfunc_cost_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
101:
102: x_is_rate_type_valid := FALSE;
103:
104: END IF;

Line 106: IF (nvl(p_pv_projfunc_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND

102: x_is_rate_type_valid := FALSE;
103:
104: END IF;
105:
106: IF (nvl(p_pv_projfunc_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
107: nvl(p_pt_projfunc_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
108:
109: x_is_rate_type_valid := FALSE;
110:

Line 107: nvl(p_pt_projfunc_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN

103:
104: END IF;
105:
106: IF (nvl(p_pv_projfunc_rev_rate_type,'-99') = PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER AND
107: nvl(p_pt_projfunc_rev_rate_type,'-99') <> PA_FP_CONSTANTS_PKG.G_RATE_TYPE_USER ) THEN
108:
109: x_is_rate_type_valid := FALSE;
110:
111: END IF;

Line 245: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

241: FROM pa_proj_fp_options
242: WHERE project_id=c_project_id
243: AND fin_plan_type_id=c_fin_plan_type_id
244: AND fin_plan_version_id IS NULL
245: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
246:
247: l_proj_fp_options_rec l_proj_fp_options_csr%ROWTYPE;
248:
249: -- Cursot to get the segment 1 of the project. Added baseline funding flag as part

Line 270: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,

266: ,c_version_type VARCHAR2)
267:
268: IS
269: SELECT decode(c_version_type,
270: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

Line 271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,

267:
268: IS
269: SELECT decode(c_version_type,
270: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,

Line 272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code

268: IS
269: SELECT decode(c_version_type,
270: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id

Line 274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

270: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,

Line 275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,

271: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,

Line 276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id

272: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
273: ,decode(c_version_type,
274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code

Line 278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,

274: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
281: FROM pa_proj_fp_options
282: WHERE project_id=c_project_id

Line 279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,

275: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
281: FROM pa_proj_fp_options
282: WHERE project_id=c_project_id
283: AND fin_plan_type_id=c_fin_plan_type_id

Line 280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code

276: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
277: ,decode(c_version_type,
278: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
279: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
280: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
281: FROM pa_proj_fp_options
282: WHERE project_id=c_project_id
283: AND fin_plan_type_id=c_fin_plan_type_id
284: AND fin_plan_version_id IS NULL

Line 285: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

281: FROM pa_proj_fp_options
282: WHERE project_id=c_project_id
283: AND fin_plan_type_id=c_fin_plan_type_id
284: AND fin_plan_version_id IS NULL
285: AND fin_plan_option_level_code= PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
286:
287: l_plan_type_settings_rec l_plan_type_settings_csr%ROWTYPE;
288:
289:

Line 336: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE --AMG UT2

332: IS
333: SELECT 'X'
334: FROM pa_fin_plan_types_b fin ,pa_proj_fp_options pfo
335: WHERE pfo.project_id=c_project_id
336: AND pfo.fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE --AMG UT2
337: AND pfo.fin_plan_type_id = fin.fin_plan_type_id
338: AND fin.migrated_frm_bdgt_typ_code = c_budget_type_code;
339:
340: l_budget_type_upgraded_rec is_budget_type_upgraded_csr%ROWTYPE;

Line 497: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

493: pa_debug.g_err_stage:= 'Fin Plan type info and budget type info are missing';
494: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
495: END IF;
496:
497: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
498:
499: END IF;
500:
501: -- Both Budget Type Code and Fin Plan Type Id should not be not null

Line 517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

513: pa_debug.g_err_stage:= 'Fin Plan type info and budget type info both are provided';
514: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
515: END IF;
516:
517: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
518:
519: END IF;
520:
521: --dbms_output.put_line('After validating budget and finplan ids');

Line 680: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

676: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
677: END IF;
678:
679: --RAISE FND_API.G_EXC_ERROR; --AMG UT2
680: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
681:
682: END IF;
683:
684: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;

Line 761: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET

757: --Check for the security
758: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (
759: p_api_version_number => p_api_version_number
760: ,p_project_id => px_pa_project_id
761: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET
762: ,p_function_name => p_calling_module
763: ,p_version_type => null
764: ,x_return_status => x_return_status
765: ,x_ret_code => l_security_ret_code );

Line 778: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

774: pa_debug.g_err_stage:= 'Security API Failed';
775: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
776: END IF;
777:
778: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
779: END IF;
780:
781: --dbms_output.put_line('About to validate the budget type');
782: -- Get the budget amount code. Check whether the project type allows the

Line 822: IF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C THEN

818:
819: CLOSE l_budget_amount_code_csr;
820:
821:
822: IF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C THEN
823:
824: IF NVL(l_allow_cost_budget_entry_flag,'N') = 'N' THEN
825: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
826: THEN

Line 845: ELSIF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_R THEN

841:
842: -- RAISE FND_API.G_EXC_ERROR;
843: END IF;
844:
845: ELSIF l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_R THEN
846:
847: IF NVL(l_allow_rev_budget_entry_flag,'N') = 'N' THEN
848: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
849: THEN

Line 868: END IF; --End of l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C

864:
865: -- RAISE FND_API.G_EXC_ERROR;
866: END IF;
867:
868: END IF; --End of l_budget_amount_code = PA_FP_CONSTANTS_PKG.G_BUDGET_AMOUNT_CODE_C
869:
870: END IF; --End of l_budget_amount_code_csr%NOTFOUND
871:
872: --Added this for bug#4460139

Line 886: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

882: pa_debug.g_err_stage := 'Budget of type FORECASTING_BUDGET_TYPE' ;
883: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
884: END IF;
885: x_return_status := FND_API.G_RET_STS_ERROR;
886: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
887: END IF;
888:
889: -- Budget Integration Validation ---------------------------------------
890:

Line 1174: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706

1170:
1171: -- If autobaselining is enabled for the project and If the budget type code is 'AR' then the
1172: -- version can not be created thru AMG
1173:
1174: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706
1175:
1176: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1177: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1178: END IF;

Line 1176: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN

1172: -- version can not be created thru AMG
1173:
1174: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706
1175:
1176: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1177: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1178: END IF;
1179:
1180: IF ( (NVL(l_amg_project_rec.baseline_funding_flag,'N')='Y')

Line 1177: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706

1173:
1174: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706
1175:
1176: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1177: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1178: END IF;
1179:
1180: IF ( (NVL(l_amg_project_rec.baseline_funding_flag,'N')='Y')
1181: AND (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR)

Line 1181: AND (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR)

1177: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1178: END IF;
1179:
1180: IF ( (NVL(l_amg_project_rec.baseline_funding_flag,'N')='Y')
1181: AND (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR)
1182: AND (NVL(l_called_from_agr_pub,'N') = 'N')) THEN -- Bug 3099706
1183:
1184: -- Added the param p_called_from_baseline to skip the autobaseline validation if
1185: -- the create_draft_budget API is called to create a draft budget while creating

Line 1203: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1199: p_value1 => l_amg_project_rec.segment1);
1200: x_return_status := FND_API.G_RET_STS_ERROR;
1201: l_any_error_occurred_flag := 'Y';
1202:
1203: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1204: --dbms_output.put_line('Autobaseline error');
1205:
1206: END IF;
1207:

Line 1238: IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC) THEN

1234: END IF;
1235:
1236: -- If an Approved Cost plan version exists for the project in new model then a budget version
1237: -- for budget type 'AC' can not be created for that project.
1238: IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC) THEN
1239:
1240: -- Call the utility function that gives the id of the approved cost plan type, if exists,
1241: -- that is added to the project
1242: pa_fin_plan_utils.Get_Appr_Cost_Plan_Type_Info(

Line 1256: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1252: IF l_debug_mode = 'Y' THEN
1253: pa_debug.g_err_stage := 'Get_Appr_Cost_Plan_Type_Info API returned error' ;
1254: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1255: END IF;
1256: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1257:
1258: -- The Get_Appr_Cost_Plan_Type_Info api got executed successfully.Approved cost version
1259: -- is already added to the project
1260: ELSIF (l_approved_fin_plan_type_id IS NOT NULL) THEN

Line 1276: END IF; --IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC)

1272: l_any_error_occurred_flag := 'Y';
1273:
1274: END IF; --IF x_return_status <> FND_API.G_RET_STS_SUCCESS
1275:
1276: END IF; --IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC)
1277:
1278: -- If an Approved Revenue plan version exists for the project in new model then a budget
1279: -- version of budget type 'AR' can not be created for that project.
1280: IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR) THEN

Line 1280: IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR) THEN

1276: END IF; --IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC)
1277:
1278: -- If an Approved Revenue plan version exists for the project in new model then a budget
1279: -- version of budget type 'AR' can not be created for that project.
1280: IF (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR) THEN
1281:
1282: -- Call the utility function that gives the id of the approved revenue plan type, if exists,
1283: -- that is added to the project
1284: pa_fin_plan_utils.Get_Appr_Rev_Plan_Type_Info(

Line 1298: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1294: IF l_debug_mode = 'Y' THEN
1295: pa_debug.g_err_stage := 'Get_Appr_Cost_Plan_Type_Info API returned error' ;
1296: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1297: END IF;
1298: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1299:
1300: -- The Get_Appr_Cost_Plan_Type_Info api got executed successfully.Approved cost version
1301: -- is already added to the project
1302: ELSIF( l_approved_fin_plan_type_id IS NOT NULL) THEN

Line 1370: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1366: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1367: END IF;
1368:
1369:
1370: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1371:
1372: END IF;
1373:
1374: -- Get the plan type level settings

Line 1431: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1427: pa_debug.g_err_stage:= 'Plan type is not yet added to the project';
1428: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1429: END IF;
1430:
1431: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1432:
1433: ELSE
1434:
1435: CLOSE l_proj_fp_options_csr;

Line 1442: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706

1438:
1439: -- If autobaselining is enabled for the project and If the budget type code is 'AR' then the
1440: -- version can not be created thru AMG
1441:
1442: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706
1443:
1444: ---- Bug # 3507156
1445: --PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB should be reset to N even in case of errors.
1446:

Line 1445: --PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB should be reset to N even in case of errors.

1441:
1442: l_called_from_agr_pub := PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB; -- Bug # 3099706
1443:
1444: ---- Bug # 3507156
1445: --PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB should be reset to N even in case of errors.
1446:
1447: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1448: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1449: END IF;

Line 1447: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN

1443:
1444: ---- Bug # 3507156
1445: --PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB should be reset to N even in case of errors.
1446:
1447: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1448: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1449: END IF;
1450:
1451: ---- Bug # 3507156

Line 1448: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706

1444: ---- Bug # 3507156
1445: --PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB should be reset to N even in case of errors.
1446:
1447: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1448: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1449: END IF;
1450:
1451: ---- Bug # 3507156
1452: -- To check whether finplan is auto baselined by calling the api.

Line 1476: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1472: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
1473: END IF;
1474: --dbms_output.put_line('Exc in getting ver type');
1475:
1476: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1477:
1478: END IF;
1479:
1480: IF l_autobaseline_flag = 'N' THEN

Line 1503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1499: pa_debug.g_err_stage := 'Can not check if plan type is editable' ;
1500: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1501: END IF;
1502:
1503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1504: END IF;
1505:
1506: -- -- Bug # 3507156
1507: --If it returns N, then raise PA_FP_PLAN_TYPE_NON_EDITABLE.

Line 1536: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN

1532:
1533: ---- Bug # 3507156
1534: -- Commented out as it is redundant over here.
1535: /*
1536: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1537: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1538: END IF;
1539: */
1540:

Line 1537: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706

1533: ---- Bug # 3507156
1534: -- Commented out as it is redundant over here.
1535: /*
1536: IF (nvl(PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB,'N') = 'Y') THEN
1537: PA_FP_CONSTANTS_PKG.G_CALLED_FROM_AGREEMENT_PUB := 'N'; -- reset the value bug 3099706
1538: END IF;
1539: */
1540:
1541:

Line 1543: AND (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR)

1539: */
1540:
1541:
1542: IF ( (NVL(l_amg_project_rec.baseline_funding_flag,'N')='Y')
1543: AND (p_budget_type_code = PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR)
1544: AND (NVL(l_called_from_agr_pub,'N') = 'N')) THEN -- Bug 3099706
1545:
1546:
1547: -- Added the param p_called_from_baseline to skip the autobaseline validation if

Line 1567: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1563:
1564: x_return_status := FND_API.G_RET_STS_ERROR;
1565: l_any_error_occurred_flag := 'Y';
1566:
1567: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1568: --dbms_output.put_line('Autobaseline error');
1569:
1570: END IF;
1571:

Line 1576: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN

1572: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (
1573: p_api_version_number => p_api_version_number
1574: ,p_project_id => px_pa_project_id
1575: ,p_fin_plan_type_id => px_fin_plan_type_id /* Bug 3139924 */
1576: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN
1577: ,p_function_name => p_calling_module
1578: ,p_version_type => px_version_type
1579: ,x_return_status => x_return_status
1580: ,x_ret_code => l_security_ret_code );

Line 1585: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1581:
1582: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS OR
1583: l_security_ret_code='N') THEN
1584: --dbms_output.put_line('Exc in security');
1585: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1586: END IF;
1587:
1588:
1589: /* Bug 3133930- Version name validation is included */

Line 1596: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1592: p_budget_version_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR THEN
1593: PA_UTILS.ADD_MESSAGE(
1594: p_app_short_name => 'PA'
1595: ,p_msg_name => 'PA_VERSION_NAME_IS_MISSING');
1596: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1597: END IF;
1598:
1599: --dbms_output.put_line('DONE with sec');
1600: -- Added the check to skip the autobaseline validation if

Line 1606: AND (px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)

1602: -- a baselined budget. --4738996
1603: -- Auto Baseline check. If auto baselining is enabled for the project the user can not
1604: -- create an approved revenue plan version thru AMG
1605: IF ((NVL(l_amg_project_rec.baseline_funding_flag,'N')='Y')
1606: AND (px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE)
1607: AND (l_proj_fp_options_rec.approved_rev_plan_type_flag = 'Y')
1608: AND (NVL(l_called_from_agr_pub,'N') = 'N')) THEN -- Added for bug 4738996
1609:
1610: IF l_debug_mode = 'Y' THEN

Line 1623: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1619: p_value1 => l_amg_project_rec.segment1);
1620:
1621: x_return_status := FND_API.G_RET_STS_ERROR;
1622: l_any_error_occurred_flag := 'Y';
1623: --RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1624:
1625: END IF;
1626:
1627: -- Validate planning level, resource list id and time phasing if they are passed. If they

Line 1643: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1639: pa_debug.g_err_stage := 'l_plan_type_settings_csr returned 0 rows' ;
1640: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level3);
1641: END IF;
1642: CLOSE l_plan_type_settings_csr;
1643: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1644:
1645: ELSE
1646:
1647: CLOSE l_plan_type_settings_csr;

Line 1867: IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,

1863: /*
1864: -- The time phasing passed is valid. Time phasing can not be 'PA' or 'GL' if the
1865: -- period profile is not defined for the project.
1866: ELSE
1867: IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1868: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1869: -- If the time phasing is either PA or GL check whether a period profile for that project
1870: -- exists or not
1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN

Line 1868: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN

1864: -- The time phasing passed is valid. Time phasing can not be 'PA' or 'GL' if the
1865: -- period profile is not defined for the project.
1866: ELSE
1867: IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1868: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1869: -- If the time phasing is either PA or GL check whether a period profile for that project
1870: -- exists or not
1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
1872: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA;

Line 1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN

1867: IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1868: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1869: -- If the time phasing is either PA or GL check whether a period profile for that project
1870: -- exists or not
1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
1872: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA;
1873: ELSE
1874: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL;
1875: END IF;

Line 1872: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA;

1868: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1869: -- If the time phasing is either PA or GL check whether a period profile for that project
1870: -- exists or not
1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
1872: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA;
1873: ELSE
1874: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL;
1875: END IF;
1876:

Line 1874: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL;

1870: -- exists or not
1871: IF px_time_phased_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P THEN
1872: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_PA;
1873: ELSE
1874: l_period_type := PA_FP_CONSTANTS_PKG.G_PERIOD_TYPE_GL;
1875: END IF;
1876:
1877: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1878: ( p_project_id => px_pa_project_id,

Line 1880: p_period_profile_type => PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING,

1876:
1877: Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1878: ( p_project_id => px_pa_project_id,
1879: p_period_type => l_period_type,
1880: p_period_profile_type => PA_FP_CONSTANTS_PKG.G_PD_PROFILE_FIN_PLANNING,
1881: x_period_profile_id => l_period_profile_id,
1882: x_start_period => l_start_period,
1883: x_end_period => l_end_period,
1884: x_return_status => x_return_status,

Line 1895: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1891: pa_debug.g_err_stage:= 'get current period profile gave error' ||px_pa_project_id;
1892: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1893:
1894: END IF;
1895: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1896:
1897: END IF;
1898:
1899: IF(l_period_profile_id IS NULL) THEN

Line 1912: END IF; --IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,

1908:
1909: END IF;
1910:
1911: END IF;
1912: END IF; --IF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1913: */
1914:
1915: ---- Bug # 3507156
1916: -- Replaced the call to Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info

Line 1919: ELSIF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,

1915: ---- Bug # 3507156
1916: -- Replaced the call to Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1917: -- by a check for existence of record in pa_period_masks_b
1918:
1919: ELSIF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1920: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1921: BEGIN
1922: SELECT 'Y'
1923: INTO l_exists

Line 1920: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN

1916: -- Replaced the call to Pa_Prj_Period_Profile_Utils.Get_Curr_Period_Profile_Info
1917: -- by a check for existence of record in pa_period_masks_b
1918:
1919: ELSIF px_time_phased_code IN (PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P,
1920: PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_G) THEN
1921: BEGIN
1922: SELECT 'Y'
1923: INTO l_exists
1924: FROM dual

Line 1948: IF (px_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN

1944:
1945: -- Multi currency flag validation.
1946:
1947: -- Depending on px_version_type initialise l_conv_attrs_to_be_validated
1948: IF (px_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
1949: l_conv_attrs_to_be_validated := px_version_type;
1950: ELSE
1951: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
1952: END IF;

Line 1951: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;

1947: -- Depending on px_version_type initialise l_conv_attrs_to_be_validated
1948: IF (px_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
1949: l_conv_attrs_to_be_validated := px_version_type;
1950: ELSE
1951: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
1952: END IF;
1953:
1954:
1955: -- Get the project and project functional currencies.

Line 1976: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

1972: pa_debug.g_err_stage:= 'pa_fin_plan_utils.Get_Project_Curr_Attributes errored out for project' ||px_pa_project_id;
1973: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
1974:
1975: END IF;
1976: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
1977:
1978: END IF;
1979:
1980:

Line 2039: px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN

2035: -- when plan type is approved revenue and PC = PFC then its not allowed
2036: -- to enable MC for revenue versions
2037: IF l_proj_fp_options_rec.approved_rev_plan_type_flag = 'Y' AND
2038: l_project_currency_code = l_projfunc_currency_code AND
2039: px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
2040:
2041: IF l_debug_mode = 'Y' THEN
2042: pa_debug.g_err_stage := 'mc is wrongly enabled at version level';
2043: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);

Line 2162: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN

2158: -- Conversion attributes are passed. Validate them
2159: ELSE
2160:
2161: -- Null out the cost attributes for revenue version and vice versa AMG UT2
2162: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN
2163:
2164: px_project_rev_rate_type :=NULL;
2165: px_project_rev_rate_date_typ :=NULL;
2166: px_project_rev_rate_date :=NULL;

Line 2172: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN

2168: px_projfunc_rev_rate_type :=NULL;
2169: px_projfunc_rev_rate_date_typ :=NULL;
2170: px_projfunc_rev_rate_date :=NULL;
2171:
2172: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
2173:
2174: px_project_cost_rate_type :=NULL;
2175: px_project_cost_rate_date_typ :=NULL;
2176: px_project_cost_rate_date :=NULL;

Line 2209: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2205: pa_debug.g_err_stage:= 'valid_rate_type returned error';
2206: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2207: END IF;
2208:
2209: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2210:
2211: END IF;
2212:
2213: IF NOT l_is_rate_type_valid THEN

Line 2253: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_HEADER

2249: ,px_projfunc_rev_rate_date =>px_projfunc_rev_rate_date
2250: ,px_projfunc_rev_exchange_rate =>l_projfunc_rev_exchange_rate
2251: ,p_project_currency_code =>l_project_currency_code
2252: ,p_projfunc_currency_code =>l_projfunc_currency_code
2253: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_HEADER
2254: ,p_attrs_to_be_validated =>l_conv_attrs_to_be_validated
2255: ,x_return_status =>x_return_status
2256: ,x_msg_count =>x_msg_count
2257: ,x_msg_data =>x_msg_data);

Line 2287: IF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN

2283: -- Addeed for Bug#5510196 END
2284:
2285:
2286: -- Validate amount and quantity flags
2287: IF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
2288:
2289: px_raw_cost_flag:= nvl(px_raw_cost_flag,'N');
2290: px_burdened_cost_flag := nvl(px_burdened_cost_flag,'N');
2291: px_cost_qty_flag := nvl(px_cost_qty_flag,'N');

Line 2328: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE ) THEN

2324: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2325: END IF;
2326: END IF;
2327:
2328: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE ) THEN
2329:
2330: px_revenue_flag := nvl(px_revenue_flag,'N');
2331: px_revenue_qty_flag := nvl(px_revenue_qty_flag,'N');
2332:

Line 2368: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN

2364: END IF;
2365:
2366: END IF;
2367:
2368: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN
2369:
2370: px_raw_cost_flag:= nvl(px_raw_cost_flag,'N');
2371: px_burdened_cost_flag := nvl(px_burdened_cost_flag,'N');
2372: px_revenue_flag := nvl(px_revenue_flag,'N');

Line 2585: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2581: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
2582: END IF;
2583: x_return_status := FND_API.G_RET_STS_ERROR;
2584: l_any_error_occurred_flag := 'Y';
2585: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2586: END IF;
2587:
2588: IF l_debug_mode = 'Y' THEN
2589: pa_debug.reset_curr_function;

Line 2593: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

2589: pa_debug.reset_curr_function;
2590: END IF;
2591: EXCEPTION
2592:
2593: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
2594: IF x_return_status IS NULL OR
2595: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
2596: x_return_status := FND_API.G_RET_STS_ERROR;
2597: END IF;

Line 2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,

2749: ,c_fin_plan_version_id pa_budget_versions.budget_version_id%TYPE)
2750: IS
2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag
2752: ,decode(c_version_type,
2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

Line 2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,

2750: IS
2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag
2752: ,decode(c_version_type,
2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,

Line 2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code

2751: SELECT nvl(plan_in_multi_curr_flag,'N') multi_curr_flag
2752: ,decode(c_version_type,
2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id

Line 2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,

2753: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_fin_plan_level_code,
2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,

Line 2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,

2754: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_fin_plan_level_code,
2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,

Line 2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id

2755: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_fin_plan_level_code) fin_plan_level_code
2756: ,decode(c_version_type,
2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code

Line 2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,

2757: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_resource_list_id,
2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
2764: FROM pa_proj_fp_options
2765: WHERE project_id=c_project_id

Line 2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,

2758: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_resource_list_id,
2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
2764: FROM pa_proj_fp_options
2765: WHERE project_id=c_project_id
2766: AND fin_plan_type_id=c_fin_plan_type_id

Line 2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code

2759: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_resource_list_id) resource_list_id
2760: ,decode(c_version_type,
2761: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST, cost_time_phased_code,
2762: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE, revenue_time_phased_code,
2763: PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL, all_time_phased_code) time_phased_code
2764: FROM pa_proj_fp_options
2765: WHERE project_id=c_project_id
2766: AND fin_plan_type_id=c_fin_plan_type_id
2767: AND fin_plan_version_id = c_fin_plan_version_id;

Line 2938: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2934: pa_debug.g_err_stage:= 'Fin Plan type info and budget type info are missing';
2935: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
2936: END IF;
2937:
2938: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2939:
2940: END IF;
2941:
2942: -- Both Budget Type Code and Fin Plan Type Id should not be not null

Line 2958: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2954: pa_debug.g_err_stage:= 'Fin Plan type info and budget type info both are provided';
2955: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
2956: END IF;
2957:
2958: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2959:
2960: END IF;
2961:
2962: --product_code is mandatory

Line 2985: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

2981: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
2982: END IF;
2983:
2984: x_return_status := FND_API.G_RET_STS_ERROR;
2985: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2986:
2987: ELSE --p_pm_product_code is not null
2988:
2989: OPEN p_product_code_csr (p_pm_product_code);

Line 3013: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3009: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3010: END IF;
3011:
3012: x_return_status := FND_API.G_RET_STS_ERROR;
3013: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3014: END IF;
3015: END IF;-- p_pm_product_code IS NULL
3016:
3017:

Line 3044: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3040: pa_debug.g_err_stage:= 'Error while deriving project id';
3041: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3042: END IF;
3043:
3044: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3045:
3046: END IF;
3047:
3048: PA_INTERFACE_UTILS_PUB.G_PROJECT_ID := px_pa_project_id;

Line 3079: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET

3075: --Check for the security
3076: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (
3077: p_api_version_number => p_api_version_number
3078: ,p_project_id => px_pa_project_id
3079: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET
3080: ,p_function_name => p_function_name
3081: ,p_version_type => null
3082: ,x_return_status => x_return_status
3083: ,x_ret_code => l_security_ret_code );

Line 3096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3092: pa_debug.g_err_stage:= 'Security API Failed';
3093: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3094: END IF;
3095:
3096: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3097: END IF;
3098:
3099: --Verify Budget Type and get the budget amount code.
3100: OPEN l_budget_amount_code_csr( px_budget_type_code );

Line 3127: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3123: pa_debug.g_err_stage:= 'Budget type is invalid';
3124: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3125: END IF;
3126:
3127: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3128: ELSE
3129: CLOSE l_budget_amount_code_csr;
3130: END IF; --End of l_budget_amount_code_csr%NOTFOUND
3131:

Line 3145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3141: IF l_debug_mode = 'Y' THEN
3142: pa_debug.g_err_stage := 'Budget of type FORECASTING_BUDGET_TYPE' ;
3143: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3144: END IF;
3145: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3146: END IF;
3147:
3148: -- Budgetary Control Check
3149: -- Bug 4588279, 27-SEP-05, jwhite -----------------------------------------

Line 3281: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3277: ,p_attribute5 => '');
3278: END IF;
3279:
3280: CLOSE l_budget_version_csr;
3281: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3282:
3283: END IF;--l_budget_version_csr%NOTFOUND
3284:
3285: CLOSE l_budget_version_csr;

Line 3366: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3362: IF l_debug_mode = 'Y' THEN
3363: pa_debug.g_err_stage := 'Cannot get the value of Fin Plan Type Id' ;
3364: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3365: END IF;
3366: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3367: END IF;
3368:
3369: --We need to check use_for_workplan_flag as workplan versions
3370: --cannot be edited using this AMG interface.

Line 3390: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3386: pa_debug.g_err_stage := 'Fin Plan Type Id is used for WP' ;
3387: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3388: END IF;
3389:
3390: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3391:
3392: END IF;
3393:
3394:

Line 3411: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3407: IF l_debug_mode = 'Y' THEN
3408: pa_debug.g_err_stage := 'Failed in get_Version_type' ;
3409: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3410: END IF;
3411: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3412: END IF;
3413:
3414: --if the budget version belongs to an org forecasting project then throw an error
3415: IF px_version_type = 'ORG_FORECAST' THEN

Line 3428: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3424: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3425: END IF;
3426:
3427: x_return_status := FND_API.G_RET_STS_ERROR;
3428: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3429: END IF; --org_forecast
3430:
3431: --Check function security
3432: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (

Line 3436: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN

3432: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (
3433: p_api_version_number => p_api_version_number
3434: ,p_project_id => px_pa_project_id
3435: ,p_fin_plan_type_id => px_fin_plan_type_id
3436: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN
3437: ,p_function_name => p_function_name
3438: ,p_version_type => px_version_type
3439: ,x_return_status => x_return_status
3440: ,x_ret_code => l_security_ret_code );

Line 3444: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3440: ,x_ret_code => l_security_ret_code );
3441:
3442: IF (x_return_status <>FND_API.G_RET_STS_SUCCESS OR
3443: l_security_ret_code='N') THEN
3444: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3445: END IF;
3446:
3447: --Derive the fin plan version id based on the unique combination of
3448: --project id, fin plan type id, version type and version number

Line 3503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3499: IF l_debug_mode = 'Y' THEN
3500: pa_debug.g_err_stage := 'Budget Version does not exist' ;
3501: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3502: END IF;
3503: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3504:
3505: END IF;--x_budget_version_id IS NULL
3506:
3507: --Calling PA_FIN_PLAN_UTILS.validate_editable_bv API to check

Line 3515: p_context => PA_FP_CONSTANTS_PKG.G_AMG_API,

3511:
3512: pa_fin_plan_utils.validate_editable_bv
3513: (p_budget_version_id => x_budget_version_id,
3514: p_user_id => FND_GLOBAL.user_id,
3515: p_context => PA_FP_CONSTANTS_PKG.G_AMG_API,
3516: x_locked_by_person_id => l_locked_by_persion_id,
3517: x_err_code => l_val_err_code,
3518: x_return_status => x_return_status,
3519: x_msg_count => x_msg_count,

Line 3527: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3523: IF l_debug_mode = 'Y' THEN
3524: pa_debug.g_err_stage := 'This budget version can not be edited';
3525: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3526: END IF;
3527: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3528: END IF;
3529:
3530: -- Get the plan type level settings so that they can be passed as out parameters
3531: OPEN l_proj_fp_options_csr( px_pa_project_id

Line 3559: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3555: IF l_debug_mode = 'Y' THEN
3556: pa_debug.g_err_stage:= 'Plan type is not yet added to the project';
3557: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3558: END IF;
3559: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3560: ELSE
3561: CLOSE l_proj_fp_options_csr;
3562: END IF;--(l_proj_fp_options_csr%NOTFOUND)
3563:

Line 3640: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3636: ,p_token1 => 'PROJECT'
3637: ,p_value1 => x_project_number);
3638: END IF;
3639:
3640: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3641: END IF;
3642:
3643: --Check if the Budget version has any processing errors.
3644: PA_FIN_PLAN_UTILS.return_and_vldt_plan_prc_code

Line 3707: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3703:
3704: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3705: THEN
3706: -- RAISE FND_API.G_EXC_ERROR;
3707: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3708: END IF;
3709:
3710: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3711: px_raw_cost_flag := lx_raw_cost_flag;

Line 3747: IF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN

3743: px_burden_rate_flag := lx_burden_rate_flag;
3744: END IF ;
3745:
3746:
3747: IF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
3748:
3749: IF( px_raw_cost_flag NOT IN ('Y','N')) OR
3750: ( px_burdened_cost_flag NOT IN ('Y','N')) OR
3751: ( px_cost_qty_flag NOT IN ('Y','N')) OR

Line 3788: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE ) THEN

3784: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3785: END IF;
3786: END IF;
3787:
3788: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE ) THEN
3789:
3790: IF( px_revenue_flag NOT IN ('Y','N')) OR
3791: ( px_revenue_qty_flag NOT IN ('Y','N')) OR
3792: ( px_bill_rate_flag NOT IN ('Y','N')) OR

Line 3828: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN

3824: END IF;
3825:
3826: END IF;
3827:
3828: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN
3829:
3830: IF( px_raw_cost_flag NOT IN ('Y','N')) OR
3831: ( px_burdened_cost_flag NOT IN ('Y','N')) OR
3832: ( px_revenue_flag NOT IN ('Y','N')) OR

Line 3889: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3885: pa_debug.write( l_module_name,pa_debug.g_err_stage,l_debug_level5);
3886: END IF;
3887: x_return_status := FND_API.G_RET_STS_ERROR;
3888: l_any_error_occurred_flag := 'Y';
3889: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3890: END IF;
3891:
3892: IF(l_debug_mode='Y') THEN
3893: pa_debug.g_err_stage := 'Leaving validate_header_info';

Line 3903: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3899: END IF;
3900:
3901: EXCEPTION
3902:
3903: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3904: IF x_return_status IS NULL
3905: OR x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3906: x_return_status := FND_API.G_RET_STS_ERROR;
3907: END IF;

Line 5834: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

5830: proj_fp_options_id
5831: FROM pa_proj_fp_options
5832: WHERE project_id=c_project_id
5833: AND fin_plan_type_id=c_fin_plan_type_id
5834: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
5835:
5836: /* Bug 4224464: FP M Changes Start */
5837: --Cursor to derive plan_class_code and etc_start_date for a budget version
5838: CURSOR budget_version_info_cur (c_budget_version_id IN NUMBER)

Line 6042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6038: THEN
6039: PA_UTILS.ADD_MESSAGE
6040: (p_app_short_name => 'PA',
6041: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6043: END IF;
6044: Bug 3717093 */
6045:
6046: /*============================================================+

Line 6054: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6050: THEN
6051: PA_UTILS.ADD_MESSAGE
6052: (p_app_short_name => 'PA',
6053: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6054: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6055: END IF;
6056:
6057: IF(p_fin_plan_type_id IS NULL) AND (p_budget_type_code IS NOT NULL) THEN
6058:

Line 6087: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6083:
6084: PA_UTILS.ADD_MESSAGE
6085: (p_app_short_name => 'PA',
6086: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6087: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6088:
6089: END IF;
6090: END IF;
6091:

Line 6133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6129: END IF;
6130: PA_UTILS.ADD_MESSAGE
6131: (p_app_short_name => 'PA',
6132: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6133: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6134:
6135: END IF;
6136: END IF;
6137:

Line 6150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6146: (p_app_short_name => 'PA',
6147: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6148: p_token1 => 'PROCEDURENAME',
6149: p_value1 => l_module_name);
6150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6151: END IF;
6152: IF px_budget_lines_in.COUNT <> p_raw_cost_rate_tbl.COUNT OR
6153: px_budget_lines_in.COUNT <> p_burd_cost_rate_tbl.COUNT OR
6154: px_budget_lines_in.COUNT <> p_bill_rate_tbl.COUNT OR

Line 6172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6168: (p_app_short_name => 'PA',
6169: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6170: p_token1 => 'PROCEDURENAME',
6171: p_value1 => l_module_name);
6172: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6173: END IF;
6174:
6175: -- initializing the out table type parameters
6176: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

Line 6210: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6206: (p_app_short_name => 'PA',
6207: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6208: p_token1 => 'PROCEDURENAME',
6209: p_value1 => l_module_name);
6210: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6211: END IF;
6212:
6213: -- initializing the out table type parameters
6214: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

Line 6279: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc; --AMG UT2

6275: IF l_debug_mode = 'Y' THEN
6276: pa_debug.g_err_stage:= 'Could not obtain uncategorized resource list info';
6277: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6278: END IF;
6279: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc; --AMG UT2
6280: END IF; -- IF l_err_code <> 0 THEN
6281:
6282:
6283: -- Get the budget amount code so that it can be used later

Line 6344: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6340: pa_debug.g_err_stage:= 'pa_fin_plan_utils.Get_Project_Curr_Attributes errored out for project' ||p_pa_project_id;
6341: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6342:
6343: END IF;
6344: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6345:
6346: END IF;
6347:
6348: -- Get the plan type name

Line 6504: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6500: -- exception is raised here because we cannot go ahead and do further validations
6501: -- as other validations depend upon task id to be correct.
6502: --RAISE FND_API.G_EXC_ERROR; AMG UT2
6503: x_budget_lines_out(i).return_status := x_return_status;
6504: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6505: --Changed the elsif below for bug#4488926.
6506: ELSIF (px_budget_lines_in(i).pa_task_id IS NOT NULL) THEN /*if the API above executes successfully
6507: then pa_task_id would never be null*/
6508: --If the API completes successfully then store the task_id in the l_tsk_id_tbl at the location

Line 6623: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

6619: l_top_task_planning_level := NULL;
6620:
6621: IF px_budget_lines_in(i).pa_task_id = nvl(l_top_task_id,-99) THEN
6622:
6623: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
6624:
6625: ELSE
6626: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6627: , px_budget_lines_in(i).pa_task_id);

Line 6649: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

6645: x_budget_lines_out(i).return_status := x_return_status;
6646:
6647: l_any_error_occurred_flag:='Y';
6648: ELSE--The task passed is a lowest task
6649: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
6650: END IF;
6651:
6652:
6653: END IF;--iF px_budget_lines_in(i).pa_task_id = nvl(l_top_task_id,-99) THEN

Line 7213: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;

7209:
7210: ELSE
7211:
7212: IF l_parent_member_id IS NULL THEN
7213: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
7214: ELSE
7215: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
7216: END IF;
7217:

Line 7215: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

7211:
7212: IF l_parent_member_id IS NULL THEN
7213: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
7214: ELSE
7215: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
7216: END IF;
7217:
7218: END IF;
7219: END IF;

Line 7361: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7357: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7358: l_any_error_occurred_flag := 'Y';
7359: END IF;
7360: ELSE
7361: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7362: END IF;
7363: END IF; -- uom validation
7364:
7365: --etc method validation starts

Line 7912: p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST) THEN

7908: -- check for approved rev plan type flag is made here because in case plan type is at
7909: -- cost and revenue separately then version can have currencies other than PFC.
7910: l_valid_txn_curr := FALSE;
7911: IF(l_app_rev_plan_type_flag = 'Y' AND
7912: p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST) THEN
7913:
7914: --Bug 4382980:Issue#19 - Currency Defaulting when txn_currency_code
7915: --is null done as suggested by Venkatesh Jayeraman
7916: IF (px_budget_lines_in(i).txn_currency_code IS NULL ) THEN

Line 8132: IF (p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN

8128:
8129: -- Conversion attributes are passed. Validate them
8130: ELSE
8131: -- Depending on p_version_type initialise l_conv_attrs_to_be_validated
8132: IF (p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
8133: l_conv_attrs_to_be_validated := p_version_type;
8134: ELSE
8135: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8136: END IF;

Line 8135: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;

8131: -- Depending on p_version_type initialise l_conv_attrs_to_be_validated
8132: IF (p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
8133: l_conv_attrs_to_be_validated := p_version_type;
8134: ELSE
8135: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8136: END IF;
8137:
8138: -- Null out the cost attributes for revenue version and vice versa
8139: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN

Line 8139: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN

8135: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8136: END IF;
8137:
8138: -- Null out the cost attributes for revenue version and vice versa
8139: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN
8140:
8141: px_budget_lines_in(i).project_rev_rate_type :=NULL;
8142: px_budget_lines_in(i).project_rev_rate_date_type :=NULL;
8143: px_budget_lines_in(i).project_rev_rate_date :=NULL;

Line 8151: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN

8147: px_budget_lines_in(i).projfunc_rev_rate_date_type :=NULL;
8148: px_budget_lines_in(i).projfunc_rev_rate_date :=NULL;
8149: px_budget_lines_in(i).projfunc_rev_exchange_rate :=NULL;
8150:
8151: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
8152:
8153: px_budget_lines_in(i).project_cost_rate_type :=NULL;
8154: px_budget_lines_in(i).project_cost_rate_date_type :=NULL;
8155: px_budget_lines_in(i).project_cost_rate_date :=NULL;

Line 8273: ,p_context => PA_FP_CONSTANTS_PKG.G_WEBADI

8269: ,px_projfunc_rev_rate_date => l_wa_projfunc_rev_rate_date
8270: ,px_projfunc_rev_exchange_rate => l_wa_projfunc_rev_exc_rate
8271: ,p_project_currency_code => l_project_currency_code
8272: ,p_projfunc_currency_code => l_projfunc_currency_code
8273: ,p_context => PA_FP_CONSTANTS_PKG.G_WEBADI
8274: ,p_attrs_to_be_validated => l_conv_attrs_to_be_validated
8275: ,x_return_status => x_return_status
8276: ,x_msg_count => x_msg_count
8277: ,x_msg_data => x_msg_data);

Line 8298: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_DETAIL

8294: ,px_projfunc_rev_rate_date =>px_budget_lines_in(i).projfunc_rev_rate_date
8295: ,px_projfunc_rev_exchange_rate =>px_budget_lines_in(i).projfunc_rev_exchange_rate
8296: ,p_project_currency_code =>l_project_currency_code
8297: ,p_projfunc_currency_code =>l_projfunc_currency_code
8298: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_DETAIL
8299: ,p_attrs_to_be_validated =>l_conv_attrs_to_be_validated
8300: ,x_return_status =>x_return_status
8301: ,x_msg_count =>x_msg_count
8302: ,x_msg_data =>x_msg_data);

Line 8447: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

8443: pa_debug.g_err_stage := 'Call to process_errors returned with error';
8444: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8445: END IF;
8446:
8447: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8448: END IF;
8449: END IF; -- error tbl count > 0
8450: END IF; -- Bug 3986129
8451:

Line 8460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

8456: pa_debug.g_err_stage := 'Reporting the errors occured while validating budget lines';
8457: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8458: END IF;
8459:
8460: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8461: END IF; -- non webadi context
8462: END IF;
8463:
8464: -- Null out the global variables.

Line 8477: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

8473: l_debug_level3);
8474: pa_debug.reset_curr_function;
8475: END IF;
8476: EXCEPTION
8477: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8478:
8479: IF x_return_status IS NULL OR
8480: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8481: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8731: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

8727: END IF; -- p_calling_context <> 'CREATE_DRAFT_FINPLAN'
8728:
8729: EXCEPTION
8730:
8731: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8732:
8733: x_return_status := FND_API.G_RET_STS_ERROR;
8734: IF l_debug_mode = 'Y' THEN
8735: pa_debug.g_err_stage:= 'Invalid Arguments Passed';

Line 8736: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

8732:
8733: x_return_status := FND_API.G_RET_STS_ERROR;
8734: IF l_debug_mode = 'Y' THEN
8735: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
8736: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8737: pa_debug.reset_err_stack;
8738: END IF;
8739: RETURN;
8740:

Line 8752: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

8748: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS');
8749:
8750: IF l_debug_mode = 'Y' THEN
8751: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8752: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8753: pa_debug.reset_err_stack;
8754: END IF;
8755: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
8756: ,p_data => x_msg_data );

Line 8861: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);

8857: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
8858: ,p_procedure_name => 'GET_LATEST_BC_YEAR');
8859: IF l_debug_mode = 'Y' THEN
8860: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8861: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8862: pa_debug.reset_err_stack;
8863: END IF;
8864: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
8865: ,p_data => x_msg_data );