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_FIN_PLAN_UTILS

Line 376: -- Added the variable l_editable_flag for call to procedure pa_fin_plan_utils.Check_if_plan_type_editable

372: l_user_id NUMBER := 0;
373: l_module_name VARCHAR2(80);
374:
375: -- -- Bug # 3507156
376: -- Added the variable l_editable_flag for call to procedure pa_fin_plan_utils.Check_if_plan_type_editable
377:
378: l_editable_flag VARCHAR2(1);
379:
380: l_copy_conv_attr boolean;

Line 1242: pa_fin_plan_utils.Get_Appr_Cost_Plan_Type_Info(

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(
1243: p_project_id => px_pa_project_id
1244: ,x_plan_type_id => l_approved_fin_plan_type_id
1245: ,x_return_status => x_return_status
1246: ,x_msg_count => x_msg_count

Line 1284: pa_fin_plan_utils.Get_Appr_Rev_Plan_Type_Info(

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(
1285: p_project_id => px_pa_project_id
1286: ,x_plan_type_id => l_approved_fin_plan_type_id
1287: ,x_return_status => x_return_status
1288: ,x_msg_count => x_msg_count

Line 1460: pa_fin_plan_utils.get_version_type

1456: --dbms_output.put_line('About to get ver type');
1457:
1458: -- Derive the version type. An error will be thrown by this api if preference code is
1459: -- COST_AND_REV_SEP and version type is not passed
1460: pa_fin_plan_utils.get_version_type
1461: ( p_project_id => px_pa_project_id
1462: ,p_fin_plan_type_id => px_fin_plan_type_id
1463: ,px_version_type => px_version_type
1464: ,x_return_status => x_return_status

Line 1483: --If validate_header_info is called for create_budget_context call pa_fin_plan_utils.allow_edit_after_baseline_flag.

1479:
1480: IF l_autobaseline_flag = 'N' THEN
1481:
1482: ---- Bug # 3507156
1483: --If validate_header_info is called for create_budget_context call pa_fin_plan_utils.allow_edit_after_baseline_flag.
1484:
1485: pa_fin_plan_utils.Check_if_plan_type_editable (
1486: P_project_id => px_pa_project_id
1487: ,P_fin_plan_type_id => px_fin_plan_type_id

Line 1485: pa_fin_plan_utils.Check_if_plan_type_editable (

1481:
1482: ---- Bug # 3507156
1483: --If validate_header_info is called for create_budget_context call pa_fin_plan_utils.allow_edit_after_baseline_flag.
1484:
1485: pa_fin_plan_utils.Check_if_plan_type_editable (
1486: P_project_id => px_pa_project_id
1487: ,P_fin_plan_type_id => px_fin_plan_type_id
1488: ,P_version_type => px_version_type
1489: ,X_editable_flag => l_editable_flag

Line 1671: IF ((pa_fin_plan_utils.get_lookup_value(l_planning_level_lookup ,px_fin_plan_level_code) IS NULL)

1667:
1668: -- -- Bug # 3507156
1669: -- Added a check to filter out budgets where fin_plan_level_code = 'M'
1670:
1671: IF ((pa_fin_plan_utils.get_lookup_value(l_planning_level_lookup ,px_fin_plan_level_code) IS NULL)
1672: OR (px_fin_plan_level_code = 'M'))
1673: THEN
1674: IF l_debug_mode = 'Y' THEN
1675: pa_debug.g_err_stage := 'Planning level passed is '|| px_fin_plan_level_code ;

Line 1839: IF ((pa_fin_plan_utils.get_lookup_value( l_time_phasing_lookup,px_time_phased_code) IS NULL) OR (px_time_phased_code = 'R'))

1835:
1836: ---- Bug # 3507156
1837: --Added the extra condition to check for time phasing as 'R'(Date Range) as date range time phasing is not supported in FP M.
1838:
1839: IF ((pa_fin_plan_utils.get_lookup_value( l_time_phasing_lookup,px_time_phased_code) IS NULL) OR (px_time_phased_code = 'R'))
1840: THEN
1841:
1842: IF l_debug_mode = 'Y' THEN
1843: pa_debug.g_err_stage := 'Time Phased Code passed is '|| px_time_phased_code ;

Line 1940: END IF; -- IF pa_fin_plan_utils.get_lookup_value

1936: p_msg_name => 'PA_FP_NO_PERIOD_MASK');
1937:
1938: x_return_status := FND_API.G_RET_STS_ERROR;
1939: END;
1940: END IF; -- IF pa_fin_plan_utils.get_lookup_value
1941:
1942: END IF; -- IF(px_time_phased_code IS NULL) THEN
1943: --dbms_output.put_line('About to start mc');
1944:

Line 1956: pa_fin_plan_utils.Get_Project_Curr_Attributes

1952: END IF;
1953:
1954:
1955: -- Get the project and project functional currencies.
1956: pa_fin_plan_utils.Get_Project_Curr_Attributes
1957: ( p_project_id => px_pa_project_id
1958: ,x_multi_currency_billing_flag => l_multi_currency_billing_flag
1959: ,x_project_currency_code => l_project_currency_code
1960: ,x_projfunc_currency_code => l_projfunc_currency_code

Line 1972: pa_debug.g_err_stage:= 'pa_fin_plan_utils.Get_Project_Curr_Attributes errored out for project' ||px_pa_project_id;

1968:
1969: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1970:
1971: IF l_debug_mode = 'Y' THEN
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;

Line 2234: pa_fin_plan_utils.validate_currency_attributes

2230:
2231: ELSE
2232: --dbms_output.put_line('The value of l_conv_attrs_to_be_validated is ' ||l_conv_attrs_to_be_validated);
2233:
2234: pa_fin_plan_utils.validate_currency_attributes
2235: (px_project_cost_rate_type =>px_project_cost_rate_type
2236: ,px_project_cost_rate_date_typ =>px_project_cost_rate_date_typ
2237: ,px_project_cost_rate_date =>px_project_cost_rate_date
2238: ,px_project_cost_exchange_rate =>l_project_cost_exchange_rate

Line 2489: pa_fin_plan_utils.return_and_vldt_plan_prc_code

2485: l_any_error_occurred_flag := 'Y';
2486:
2487: IF l_finplan_CW_ver_rec.plan_processing_code IN ('XLUE','XLUP') THEN
2488:
2489: pa_fin_plan_utils.return_and_vldt_plan_prc_code
2490: (p_plan_processing_code => l_finplan_CW_ver_rec.plan_processing_code
2491: ,x_final_plan_prc_code => l_finplan_CW_ver_rec.plan_processing_code
2492: ,x_targ_request_id => l_targ_request_id
2493: ,x_return_status => x_return_status

Line 2501: pa_debug.g_err_stage:= 'pa_fin_plan_utils.return_and_vldt_plan_prc_code returned error';

2497: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2498: x_return_status:=FND_API.G_RET_STS_ERROR;
2499:
2500: IF l_debug_mode = 'Y' THEN
2501: pa_debug.g_err_stage:= 'pa_fin_plan_utils.return_and_vldt_plan_prc_code returned error';
2502: pa_debug.write(l_module_name,pa_debug.g_err_stage,l_debug_level3);
2503: END IF;
2504: l_any_error_occurred_flag := 'Y';
2505: END IF;

Line 3402: pa_fin_plan_utils.get_version_type

3398:
3399:
3400: -- Derive the version type. An error will be thrown by this api if preference code is
3401: -- COST_AND_REV_SEP and version type is not passed
3402: pa_fin_plan_utils.get_version_type
3403: ( p_project_id => px_pa_project_id
3404: ,p_fin_plan_type_id => px_fin_plan_type_id
3405: ,px_version_type => px_version_type
3406: ,x_return_status => x_return_status

Line 3467: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(

3463:
3464: ELSE --p_budget_version_number IS NULL
3465:
3466: -- Fetch the current working version for the project, finplan type and verion type
3467: PA_FIN_PLAN_UTILS.Get_Curr_Working_Version_Info(
3468: p_project_id => px_pa_project_id
3469: ,p_fin_plan_type_id => px_fin_plan_type_id
3470: ,p_version_type => px_version_type
3471: ,x_fp_options_id => l_dummy

Line 3511: --Calling PA_FIN_PLAN_UTILS.validate_editable_bv API to check

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
3512: --if the budget version is locked by another user/process
3513: --or Edit after initial baseline setup is true and baseline
3514: --versions exist.
3515:

Line 3516: pa_fin_plan_utils.validate_editable_bv

3512: --if the budget version is locked by another user/process
3513: --or Edit after initial baseline setup is true and baseline
3514: --versions exist.
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,

Line 3546: --already made inside pa_fin_plan_utils.get_version_type before

3542: ,x_resource_list_id
3543: ,x_time_phased_code;
3544:
3545: --Control will never really enter this IF block since this check is
3546: --already made inside pa_fin_plan_utils.get_version_type before
3547: --control reaches here
3548: IF (l_proj_fp_options_csr%NOTFOUND) THEN
3549: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3550: PA_UTILS.ADD_MESSAGE

Line 3615: PA_FIN_PLAN_UTILS.PERFORM_AUTOBASLINE_CHECKS (

3611: END IF;--p_change_reason_code IS NOT NULL
3612:
3613:
3614: -- Call the api that performs the autobaseline checks
3615: PA_FIN_PLAN_UTILS.PERFORM_AUTOBASLINE_CHECKS (
3616: p_budget_version_id => x_budget_version_id
3617: ,x_result => l_result
3618: ,x_return_status => x_return_status
3619: ,x_msg_count => x_msg_count

Line 3648: PA_FIN_PLAN_UTILS.return_and_vldt_plan_prc_code

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
3649: (p_add_msg_to_stack => 'Y'
3650: ,p_calling_context => 'BUDGET'
3651: ,p_budget_version_id => x_budget_version_id
3652: ,x_final_plan_prc_code => l_plan_processing_code

Line 3691: l_amount_set_id := PA_FIN_PLAN_UTILS.get_amount_set_id(x_budget_version_id);

3687: ( px_cost_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) OR
3688: ( px_burden_rate_flag <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR) ) THEN
3689:
3690: /*Get the existing plan amount entry flags for the plan version*/
3691: l_amount_set_id := PA_FIN_PLAN_UTILS.get_amount_set_id(x_budget_version_id);
3692:
3693: PA_FIN_PLAN_UTILS.GET_PLAN_AMOUNT_FLAGS(
3694: P_AMOUNT_SET_ID => l_amount_set_id
3695: ,X_RAW_COST_FLAG => lx_raw_cost_flag

Line 3693: PA_FIN_PLAN_UTILS.GET_PLAN_AMOUNT_FLAGS(

3689:
3690: /*Get the existing plan amount entry flags for the plan version*/
3691: l_amount_set_id := PA_FIN_PLAN_UTILS.get_amount_set_id(x_budget_version_id);
3692:
3693: PA_FIN_PLAN_UTILS.GET_PLAN_AMOUNT_FLAGS(
3694: P_AMOUNT_SET_ID => l_amount_set_id
3695: ,X_RAW_COST_FLAG => lx_raw_cost_flag
3696: ,X_BURDENED_FLAG => lx_burdened_cost_flag
3697: ,X_REVENUE_FLAG => lx_revenue_flag

Line 6351: pa_fin_plan_utils.Get_Project_Curr_Attributes

6347: CLOSE l_plan_type_txn_curr_csr;
6348: END IF;
6349:
6350: --Get the project and project functional currencies so that they can be used later
6351: pa_fin_plan_utils.Get_Project_Curr_Attributes
6352: ( p_project_id => p_pa_project_id
6353: ,x_multi_currency_billing_flag => l_multi_currency_billing_flag
6354: ,x_project_currency_code => l_project_currency_code
6355: ,x_projfunc_currency_code => l_projfunc_currency_code

Line 6367: pa_debug.g_err_stage:= 'pa_fin_plan_utils.Get_Project_Curr_Attributes errored out for project' ||p_pa_project_id;

6363:
6364: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
6365:
6366: IF l_debug_mode = 'Y' THEN
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;

Line 6400: l_period_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_version_info_rec.x_budget_version_id);

6396: l_period_time_phased_code := p_time_phased_code; --Use the i/p parameter to get this value.
6397: --if p_time_phased_code was passed as null we try to derive the time phase code.
6398: IF(l_period_time_phased_code is null)
6399: THEN
6400: l_period_time_phased_code := PA_FIN_PLAN_UTILS.Get_Time_Phased_code(p_version_info_rec.x_budget_version_id);
6401: END IF;
6402:
6403:
6404: IF px_budget_lines_in.exists(px_budget_lines_in.first) THEN

Line 6872: l_period_plan_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(p_planning_start_date_tbl(i),l_period_time_phased_code);

6868: IF ( NOT(l_period_plan_start_date_tbl.exists(to_char(p_planning_start_date_tbl(i)))
6869: AND l_period_plan_end_date_tbl.exists(to_char(p_planning_end_date_tbl(i)))))
6870: THEN
6871: --For periodic case get the start and end dates.
6872: l_period_plan_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(p_planning_start_date_tbl(i),l_period_time_phased_code);
6873: l_period_plan_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (p_planning_end_date_tbl(i) , l_period_time_phased_code);
6874: l_period_plan_start_date_tbl(to_char(p_planning_start_date_tbl(i))) := l_period_plan_start_date;
6875: l_period_plan_end_date_tbl(to_char(p_planning_end_date_tbl(i))) := l_period_plan_end_date;
6876: ELSE

Line 6873: l_period_plan_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (p_planning_end_date_tbl(i) , l_period_time_phased_code);

6869: AND l_period_plan_end_date_tbl.exists(to_char(p_planning_end_date_tbl(i)))))
6870: THEN
6871: --For periodic case get the start and end dates.
6872: l_period_plan_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(p_planning_start_date_tbl(i),l_period_time_phased_code);
6873: l_period_plan_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (p_planning_end_date_tbl(i) , l_period_time_phased_code);
6874: l_period_plan_start_date_tbl(to_char(p_planning_start_date_tbl(i))) := l_period_plan_start_date;
6875: l_period_plan_end_date_tbl(to_char(p_planning_end_date_tbl(i))) := l_period_plan_end_date;
6876: ELSE
6877: l_period_plan_start_date := l_period_plan_start_date_tbl(to_char(p_planning_start_date_tbl(i)));

Line 7973: l_period_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(l_plan_start_date,l_period_time_phased_code);

7969: IF ( NOT(l_period_start_date_tbl.exists(to_char(l_plan_start_date))
7970: AND l_period_end_date_tbl.exists(to_char(l_plan_end_date))))
7971: THEN
7972: --For periodic case get the start and end dates.
7973: l_period_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(l_plan_start_date,l_period_time_phased_code);
7974: l_period_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (l_plan_end_date , l_period_time_phased_code);
7975: l_period_start_date_tbl(to_char(l_plan_start_date)) := l_period_start_date;
7976: l_period_end_date_tbl(to_char(l_plan_end_date)) := l_period_end_date;
7977: ELSE

Line 7974: l_period_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (l_plan_end_date , l_period_time_phased_code);

7970: AND l_period_end_date_tbl.exists(to_char(l_plan_end_date))))
7971: THEN
7972: --For periodic case get the start and end dates.
7973: l_period_start_date := PA_FIN_PLAN_UTILS.get_period_start_date(l_plan_start_date,l_period_time_phased_code);
7974: l_period_end_date := PA_FIN_PLAN_UTILS.get_period_end_date (l_plan_end_date , l_period_time_phased_code);
7975: l_period_start_date_tbl(to_char(l_plan_start_date)) := l_period_start_date;
7976: l_period_end_date_tbl(to_char(l_plan_end_date)) := l_period_end_date;
7977: ELSE
7978: l_period_start_date := l_period_start_date_tbl(to_char(l_plan_start_date));

Line 8372: pa_fin_plan_utils.validate_currency_attributes

8368:
8369: --Validate the conversion attributes passed
8370: IF p_calling_context = 'WEBADI' AND
8371: l_wa_val_conv_attr_flag='Y' THEN
8372: pa_fin_plan_utils.validate_currency_attributes
8373: ( px_project_cost_rate_type => l_wa_project_cost_rate_typ
8374: ,px_project_cost_rate_date_typ => l_wa_project_cost_rate_dt_typ
8375: ,px_project_cost_rate_date => l_wa_project_cost_rate_date
8376: ,px_project_cost_exchange_rate => l_wa_project_cost_exc_rate

Line 8397: pa_fin_plan_utils.validate_currency_attributes

8393: ,x_return_status => x_return_status
8394: ,x_msg_count => x_msg_count
8395: ,x_msg_data => x_msg_data);
8396: ELSE
8397: pa_fin_plan_utils.validate_currency_attributes
8398: ( px_project_cost_rate_type =>px_budget_lines_in(i).project_cost_rate_type
8399: ,px_project_cost_rate_date_typ =>px_budget_lines_in(i).project_cost_rate_date_type
8400: ,px_project_cost_rate_date =>px_budget_lines_in(i).project_cost_rate_date
8401: ,px_project_cost_exchange_rate =>px_budget_lines_in(i).project_cost_exchange_rate

Line 8429: l_webadi_err_code_tbl(l_webadi_err_code_tbl.COUNT) := l_wa_error_code_lookup(PA_FIN_PLAN_UTILS.g_first_error_code);

8425: x_budget_lines_out(i).return_status := x_return_status;
8426:
8427: ELSIF l_wa_val_conv_attr_flag='Y' THEN
8428: l_webadi_err_code_tbl.extend(1);
8429: l_webadi_err_code_tbl(l_webadi_err_code_tbl.COUNT) := l_wa_error_code_lookup(PA_FIN_PLAN_UTILS.g_first_error_code);
8430: l_webadi_err_task_id_tbl.extend(1);
8431: l_webadi_err_task_id_tbl(l_webadi_err_task_id_tbl.COUNT) := px_budget_lines_in(i).pa_task_id;
8432: l_webadi_err_rlm_id_tbl.extend(1);
8433: l_webadi_err_rlm_id_tbl(l_webadi_err_rlm_id_tbl.COUNT) := px_budget_lines_in(i).resource_list_member_id;

Line 8700: PA_FIN_PLAN_UTILS2.Get_AMG_BdgtLineRejctions

8696: p_debug_mode => l_debug_mode );
8697: END IF;
8698:
8699:
8700: PA_FIN_PLAN_UTILS2.Get_AMG_BdgtLineRejctions
8701: (p_budget_version_id => p_fin_plan_version_id
8702: ,x_budget_line_id_tab => l_fin_plan_line_id_tab
8703: ,x_cost_rejection_data_tab => l_cost_rejection_data_tab
8704: ,x_burden_rejection_data_tab => l_burden_rejection_data_tab