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 2940: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 2960: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 2987: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3015: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3046: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3081: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_BUDGET

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

Line 3098: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3129: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3147: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3283: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3370: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3394: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3390: pa_debug.g_err_stage := 'Fin Plan Type Id is used for WP' ;
3391: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
3392: END IF;
3393:
3394: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3395:
3396: END IF;
3397:
3398:

Line 3415: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3432: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3440: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN

3436: PA_PM_FUNCTION_SECURITY_PUB.CHECK_BUDGET_SECURITY (
3437: p_api_version_number => p_api_version_number
3438: ,p_project_id => px_pa_project_id
3439: ,p_fin_plan_type_id => px_fin_plan_type_id
3440: ,p_calling_context => PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_FIN_PLAN
3441: ,p_function_name => p_function_name
3442: ,p_version_type => px_version_type
3443: ,x_return_status => x_return_status
3444: ,x_ret_code => l_security_ret_code );

Line 3448: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3507: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3519: p_context => PA_FP_CONSTANTS_PKG.G_AMG_API,

3515:
3516: pa_fin_plan_utils.validate_editable_bv
3517: (p_budget_version_id => x_budget_version_id,
3518: p_user_id => FND_GLOBAL.user_id,
3519: p_context => PA_FP_CONSTANTS_PKG.G_AMG_API,
3520: x_locked_by_person_id => l_locked_by_persion_id,
3521: x_err_code => l_val_err_code,
3522: x_return_status => x_return_status,
3523: x_msg_count => x_msg_count,

Line 3531: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3563: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3644: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3711: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

3707:
3708: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
3709: THEN
3710: -- RAISE FND_API.G_EXC_ERROR;
3711: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3712: END IF;
3713:
3714: IF ( px_raw_cost_flag = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) THEN
3715: px_raw_cost_flag := lx_raw_cost_flag;

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

3747: px_burden_rate_flag := lx_burden_rate_flag;
3748: END IF ;
3749:
3750:
3751: IF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST) THEN
3752:
3753: IF( px_raw_cost_flag NOT IN ('Y','N')) OR
3754: ( px_burdened_cost_flag NOT IN ('Y','N')) OR
3755: ( px_cost_qty_flag NOT IN ('Y','N')) OR

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

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

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

3828: END IF;
3829:
3830: END IF;
3831:
3832: ELSIF( px_version_type = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_ALL ) THEN
3833:
3834: IF( px_raw_cost_flag NOT IN ('Y','N')) OR
3835: ( px_burdened_cost_flag NOT IN ('Y','N')) OR
3836: ( px_revenue_flag NOT IN ('Y','N')) OR

Line 3893: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 3907: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

3903: END IF;
3904:
3905: EXCEPTION
3906:
3907: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3908: IF x_return_status IS NULL
3909: OR x_return_status = FND_API.G_RET_STS_SUCCESS THEN
3910: x_return_status := FND_API.G_RET_STS_ERROR;
3911: END IF;

Line 5851: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;

5847: proj_fp_options_id
5848: FROM pa_proj_fp_options
5849: WHERE project_id=c_project_id
5850: AND fin_plan_type_id=c_fin_plan_type_id
5851: AND fin_plan_option_level_code=PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE;
5852:
5853: /* Bug 4224464: FP M Changes Start */
5854: --Cursor to derive plan_class_code and etc_start_date for a budget version
5855: CURSOR budget_version_info_cur (c_budget_version_id IN NUMBER)

Line 6059: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6055: THEN
6056: PA_UTILS.ADD_MESSAGE
6057: (p_app_short_name => 'PA',
6058: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6059: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6060: END IF;
6061: Bug 3717093 */
6062:
6063: /*============================================================+

Line 6071: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6067: THEN
6068: PA_UTILS.ADD_MESSAGE
6069: (p_app_short_name => 'PA',
6070: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6071: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6072: END IF;
6073:
6074: IF(p_fin_plan_type_id IS NULL) AND (p_budget_type_code IS NOT NULL) THEN
6075:

Line 6104: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6100:
6101: PA_UTILS.ADD_MESSAGE
6102: (p_app_short_name => 'PA',
6103: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6104: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6105:
6106: END IF;
6107: END IF;
6108:

Line 6150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6146: END IF;
6147: PA_UTILS.ADD_MESSAGE
6148: (p_app_short_name => 'PA',
6149: p_msg_name => 'PA_FP_INV_PARAM_PASSED');
6150: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6151:
6152: END IF;
6153: END IF;
6154:

Line 6162: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6158: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA'
6159: ,p_msg_name => 'PA_FP_CBS_ENABLED'
6160: );
6161: l_return_status := FND_API.G_RET_STS_ERROR;
6162: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6163: END IF;
6164:
6165: -- Bug 3986129: FP.M Web ADI Dev changes:
6166: IF p_calling_context = 'WEBADI' THEN

Line 6177: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6173: (p_app_short_name => 'PA',
6174: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6175: p_token1 => 'PROCEDURENAME',
6176: p_value1 => l_module_name);
6177: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6178: END IF;
6179: IF px_budget_lines_in.COUNT <> p_raw_cost_rate_tbl.COUNT OR
6180: px_budget_lines_in.COUNT <> p_burd_cost_rate_tbl.COUNT OR
6181: px_budget_lines_in.COUNT <> p_bill_rate_tbl.COUNT OR

Line 6199: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6195: (p_app_short_name => 'PA',
6196: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6197: p_token1 => 'PROCEDURENAME',
6198: p_value1 => l_module_name);
6199: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6200: END IF;
6201:
6202: -- initializing the out table type parameters
6203: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

Line 6237: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6233: (p_app_short_name => 'PA',
6234: p_msg_name => 'PA_FP_INV_PARAM_PASSED',
6235: p_token1 => 'PROCEDURENAME',
6236: p_value1 => l_module_name);
6237: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6238: END IF;
6239:
6240: -- initializing the out table type parameters
6241: x_mfc_cost_type_id_tbl := SYSTEM.pa_num_tbl_type();

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

6302: IF l_debug_mode = 'Y' THEN
6303: pa_debug.g_err_stage:= 'Could not obtain uncategorized resource list info';
6304: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level5);
6305: END IF;
6306: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc; --AMG UT2
6307: END IF; -- IF l_err_code <> 0 THEN
6308:
6309:
6310: -- Get the budget amount code so that it can be used later

Line 6371: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

6367: pa_debug.g_err_stage:= 'pa_fin_plan_utils.Get_Project_Curr_Attributes errored out for project' ||p_pa_project_id;
6368: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
6369:
6370: END IF;
6371: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
6372:
6373: END IF;
6374:
6375: -- Get the plan type name

Line 6533: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

Line 6652: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;

6648: l_top_task_planning_level := NULL;
6649:
6650: IF px_budget_lines_in(i).pa_task_id = nvl(l_top_task_id,-99) THEN
6651:
6652: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_TOP;
6653:
6654: ELSE
6655: pa_tasks_pkg.verify_lowest_level_task( l_return_status_task
6656: , px_budget_lines_in(i).pa_task_id);

Line 6678: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;

6674: x_budget_lines_out(i).return_status := x_return_status;
6675:
6676: l_any_error_occurred_flag:='Y';
6677: ELSE--The task passed is a lowest task
6678: l_top_task_planning_level := PA_FP_CONSTANTS_PKG.G_TASK_PLAN_LEVEL_LOWEST;
6679: END IF;
6680:
6681:
6682: END IF;--iF px_budget_lines_in(i).pa_task_id = nvl(l_top_task_id,-99) THEN

Line 7290: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;

7286:
7287: ELSE
7288:
7289: IF l_parent_member_id IS NULL THEN
7290: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
7291: ELSE
7292: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
7293: END IF;
7294:

Line 7292: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;

7288:
7289: IF l_parent_member_id IS NULL THEN
7290: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_G;
7291: ELSE
7292: l_res_planning_level := PA_FP_CONSTANTS_PKG.G_RESOURCE_PLANNING_LEVEL_R;
7293: END IF;
7294:
7295: END IF;
7296: END IF;

Line 7438: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

7434: l_webadi_err_amt_type_tbl(l_webadi_err_amt_type_tbl.COUNT) := p_amount_type_tbl(i);
7435: l_any_error_occurred_flag := 'Y';
7436: END IF;
7437: ELSE
7438: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
7439: END IF;
7440: END IF; -- uom validation
7441:
7442: --etc method validation starts

Line 8030: p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST) THEN

8026: -- check for approved rev plan type flag is made here because in case plan type is at
8027: -- cost and revenue separately then version can have currencies other than PFC.
8028: l_valid_txn_curr := FALSE;
8029: IF(l_app_rev_plan_type_flag = 'Y' AND
8030: p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_COST) THEN
8031:
8032: --Bug 4382980:Issue#19 - Currency Defaulting when txn_currency_code
8033: --is null done as suggested by Venkatesh Jayeraman
8034: IF (px_budget_lines_in(i).txn_currency_code IS NULL ) THEN

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

8246:
8247: -- Conversion attributes are passed. Validate them
8248: ELSE
8249: -- Depending on p_version_type initialise l_conv_attrs_to_be_validated
8250: IF (p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
8251: l_conv_attrs_to_be_validated := p_version_type;
8252: ELSE
8253: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8254: END IF;

Line 8253: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;

8249: -- Depending on p_version_type initialise l_conv_attrs_to_be_validated
8250: IF (p_version_type <> PA_FP_CONSTANTS_PKG.G_VERSION_TYPE_ALL) THEN
8251: l_conv_attrs_to_be_validated := p_version_type;
8252: ELSE
8253: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8254: END IF;
8255:
8256: -- Null out the cost attributes for revenue version and vice versa
8257: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN

Line 8257: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN

8253: l_conv_attrs_to_be_validated := PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_BOTH;
8254: END IF;
8255:
8256: -- Null out the cost attributes for revenue version and vice versa
8257: IF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_COST THEN
8258:
8259: px_budget_lines_in(i).project_rev_rate_type :=NULL;
8260: px_budget_lines_in(i).project_rev_rate_date_type :=NULL;
8261: px_budget_lines_in(i).project_rev_rate_date :=NULL;

Line 8269: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN

8265: px_budget_lines_in(i).projfunc_rev_rate_date_type :=NULL;
8266: px_budget_lines_in(i).projfunc_rev_rate_date :=NULL;
8267: px_budget_lines_in(i).projfunc_rev_exchange_rate :=NULL;
8268:
8269: ELSIF l_conv_attrs_to_be_validated = PA_FP_CONSTANTS_PKG.G_ELEMENT_TYPE_REVENUE THEN
8270:
8271: px_budget_lines_in(i).project_cost_rate_type :=NULL;
8272: px_budget_lines_in(i).project_cost_rate_date_type :=NULL;
8273: px_budget_lines_in(i).project_cost_rate_date :=NULL;

Line 8391: ,p_context => PA_FP_CONSTANTS_PKG.G_WEBADI

8387: ,px_projfunc_rev_rate_date => l_wa_projfunc_rev_rate_date
8388: ,px_projfunc_rev_exchange_rate => l_wa_projfunc_rev_exc_rate
8389: ,p_project_currency_code => l_project_currency_code
8390: ,p_projfunc_currency_code => l_projfunc_currency_code
8391: ,p_context => PA_FP_CONSTANTS_PKG.G_WEBADI
8392: ,p_attrs_to_be_validated => l_conv_attrs_to_be_validated
8393: ,x_return_status => x_return_status
8394: ,x_msg_count => x_msg_count
8395: ,x_msg_data => x_msg_data);

Line 8416: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_DETAIL

8412: ,px_projfunc_rev_rate_date =>px_budget_lines_in(i).projfunc_rev_rate_date
8413: ,px_projfunc_rev_exchange_rate =>px_budget_lines_in(i).projfunc_rev_exchange_rate
8414: ,p_project_currency_code =>l_project_currency_code
8415: ,p_projfunc_currency_code =>l_projfunc_currency_code
8416: ,p_context =>PA_FP_CONSTANTS_PKG.G_AMG_API_DETAIL
8417: ,p_attrs_to_be_validated =>l_conv_attrs_to_be_validated
8418: ,x_return_status =>x_return_status
8419: ,x_msg_count =>x_msg_count
8420: ,x_msg_data =>x_msg_data);

Line 8565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

8561: pa_debug.g_err_stage := 'Call to process_errors returned with error';
8562: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8563: END IF;
8564:
8565: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8566: END IF;
8567: END IF; -- error tbl count > 0
8568: END IF; -- Bug 3986129
8569:

Line 8578: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

8574: pa_debug.g_err_stage := 'Reporting the errors occured while validating budget lines';
8575: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
8576: END IF;
8577:
8578: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
8579: END IF; -- non webadi context
8580: END IF;
8581:
8582: -- Null out the global variables.

Line 8595: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

8591: l_debug_level3);
8592: pa_debug.reset_curr_function;
8593: END IF;
8594: EXCEPTION
8595: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8596:
8597: IF x_return_status IS NULL OR
8598: x_return_status = FND_API.G_RET_STS_SUCCESS THEN
8599: x_return_status := FND_API.G_RET_STS_ERROR;

Line 8882: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN

8878: END IF;
8879:
8880: EXCEPTION
8881:
8882: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
8883:
8884: x_return_status := FND_API.G_RET_STS_ERROR;
8885: IF l_debug_mode = 'Y' THEN
8886: pa_debug.g_err_stage:= 'Invalid Arguments Passed';

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

8883:
8884: x_return_status := FND_API.G_RET_STS_ERROR;
8885: IF l_debug_mode = 'Y' THEN
8886: pa_debug.g_err_stage:= 'Invalid Arguments Passed';
8887: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8888: -- bug 7813303 - replaced reset_err_stack with reset_curr_function
8889: -- pa_debug.reset_err_stack;
8890: pa_debug.reset_curr_function;
8891:

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

8902: ,p_procedure_name => 'GET_FIN_PLAN_LINES_STATUS');
8903:
8904: IF l_debug_mode = 'Y' THEN
8905: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
8906: pa_debug.write('GET_FIN_PLAN_LINES_STATUS: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
8907: -- bug 7813303 - replaced reset_err_stack with reset_curr_function
8908: -- pa_debug.reset_err_stack;
8909: pa_debug.reset_curr_function;
8910:

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

9014: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_budget_pvt'
9015: ,p_procedure_name => 'GET_LATEST_BC_YEAR');
9016: IF l_debug_mode = 'Y' THEN
9017: pa_debug.g_err_stage:= 'Unexpected Error'||SQLERRM;
9018: pa_debug.write('GET_LATEST_BC_YEAR: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL5);
9019: pa_debug.reset_err_stack;
9020: END IF;
9021: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count
9022: ,p_data => x_msg_data );