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_PLANNING_ELEMENT_UTILS dependencies on PA_PLANNING_ELEMENT_UTILS

Line 1: PACKAGE BODY pa_planning_element_utils AS

1: PACKAGE BODY pa_planning_element_utils AS
2: /* $Header: PAFPPEUB.pls 120.10.12010000.3 2008/12/26 14:05:38 bifernan ship $
3: Start of Comments
4: Package name : pa_planning_element_utils
5: Purpose : API's for Edit Plan / Task Details page

Line 4: Package name : pa_planning_element_utils

1: PACKAGE BODY pa_planning_element_utils AS
2: /* $Header: PAFPPEUB.pls 120.10.12010000.3 2008/12/26 14:05:38 bifernan ship $
3: Start of Comments
4: Package name : pa_planning_element_utils
5: Purpose : API's for Edit Plan / Task Details page
6: History :
7: NOTE :
8: End of Comments

Line 54: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',

50: when NO_DATA_FOUND then
51: x_return_status := FND_API.G_RET_STS_ERROR;
52: x_msg_count := 1;
53: x_msg_data := SQLERRM;
54: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',
55: p_procedure_name => 'get_workplan_bvids');
56: return;
57: end;
58:

Line 116: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',

112: when others then
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114: x_msg_count := 1;
115: x_msg_data := SQLERRM;
116: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',
117: p_procedure_name => 'get_workplan_bvids');
118: END get_workplan_bvids;
119:
120: /* CHANGE HISTORY

Line 353: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',

349: when others then
350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
351: x_msg_count := 1;
352: x_msg_data := SQLERRM;
353: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'pa_planning_element_utils',
354: p_procedure_name => 'get_finplan_bvids');
355: END get_finplan_bvids;
356:
357: FUNCTION get_task_name_and_number

Line 426: l_uncat_rlm_id := pa_planning_element_utils.get_project_uncat_rlmid;

422: l_top_and_lowest_task_flag VARCHAR2(1);
423:
424: BEGIN
425: l_return_value := 'INVALID VALUE';
426: l_uncat_rlm_id := pa_planning_element_utils.get_project_uncat_rlmid;
427: l_top_and_lowest_task_flag := 'N';--Bug 4057673
428: -- we have an element_version_id; need to determine what level task it is
429: BEGIN
430: select pelm.element_version_id,

Line 1181: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

1177: when NO_DATA_FOUND then
1178: x_return_status := FND_API.G_RET_STS_ERROR;
1179: x_msg_count := 1;
1180: x_msg_data := SQLERRM;
1181: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
1182: p_procedure_name => 'get_common_budget_version_info');
1183: end;
1184: else
1185: -- budget lines exist, so query pa_resource_assignment and pa_budget_lines

Line 1431: pa_planning_element_utils.get_initial_budget_line_info

1427:
1428:
1429: END IF; -- p_line_start_date IS NOT NULL AND p_line_end_date IS NOT NULL
1430: -- CALCULATE THE AVG RATES
1431: pa_planning_element_utils.get_initial_budget_line_info
1432: (p_resource_assignment_id => p_resource_assignment_id,
1433: p_txn_currency_code => p_txn_currency_code,
1434: p_line_start_date => p_line_start_date,
1435: p_line_end_date => p_line_end_date,

Line 1485: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

1481: end if;
1482: end if;
1483: EXCEPTION
1484: WHEN OTHERS THEN
1485: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
1486: p_procedure_name => 'get_common_budget_version_info');
1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1488: x_msg_data := SQLERRM;
1489: END get_common_budget_version_info;

Line 2023: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

2019: when NO_DATA_FOUND then
2020: x_return_status := FND_API.G_RET_STS_ERROR;
2021: x_msg_count := 1;
2022: x_msg_data := SQLERRM;
2023: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
2024: p_procedure_name => 'get_common_budget_version_info');
2025: end;
2026: -- Calculate the remaining OUT parameters
2027: if l_margin_derived_from_code = 'B' then

Line 2405: pa_planning_element_utils.get_initial_budget_line_info

2401: END IF; --p_line_start_date IS NOT NULL AND p_line_end_date IS NOT NULL
2402:
2403: -- CALCULATE THE RATE/MARGIN/MARGINPCT VALUES
2404:
2405: pa_planning_element_utils.get_initial_budget_line_info
2406: (p_resource_assignment_id => p_resource_assignment_id,
2407: p_txn_currency_code => p_txn_currency_code,
2408: p_line_start_date => p_line_start_date,
2409: p_line_end_date => p_line_end_date,

Line 2518: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

2514: end if;
2515: end if;
2516: EXCEPTION
2517: WHEN OTHERS THEN
2518: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
2519: p_procedure_name => 'get_common_bv_info_fcst');
2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2521: x_msg_data := SQLERRM;
2522: END get_common_bv_info_fcst;

Line 2641: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

2637: /*
2638: x_return_status := FND_API.G_RET_STS_ERROR;
2639: x_msg_count := 1;
2640: x_msg_data := SQLERRM;
2641: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
2642: p_procedure_name => 'get_initial_budget_line_info');
2643: */
2644: x_start_date := null;
2645: x_end_date := null;

Line 2663: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

2659: x_etc_init_burd_cost_rate := null;
2660: x_etc_init_revenue_rate := null;
2661: return;
2662: WHEN OTHERS THEN
2663: FND_MSG_PUB.ADD_EXC_MSG (p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',
2664: p_procedure_name => 'get_common_budget_version_info_fcst');
2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2666: x_msg_data := SQLERRM;
2667: END get_initial_budget_line_info;

Line 3039: pa_debug.write('PA_PLANNING_ELEMENT_UTILS.add_new_resource_assignments',pa_debug.g_err_stage,3);

3035:
3036: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3037: IF l_debug_mode = 'Y' THEN
3038: pa_debug.g_err_stage:='ADD PLAN TXN Returned Error';
3039: pa_debug.write('PA_PLANNING_ELEMENT_UTILS.add_new_resource_assignments',pa_debug.g_err_stage,3);
3040: END IF;
3041:
3042: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3043: END IF;

Line 3071: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS'

3067:
3068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3069: x_msg_count := 1;
3070: x_msg_data := SQLERRM;
3071: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS'
3072: ,p_procedure_name => 'add_new_resource_assignments');
3073:
3074: IF l_debug_mode = 'Y' THEN
3075: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

Line 3253: pa_planning_element_utils.get_fin_struct_id(p_project_id,p_budget_version_id);

3249: --hr_utility.trace_on(null, 'dlai');
3250: --hr_utility.trace('ENTERING GET PERCENT COMPLETE API');
3251: l_return_value := null;
3252: l_structure_version_id :=
3253: pa_planning_element_utils.get_fin_struct_id(p_project_id,p_budget_version_id);
3254: l_structure_status_flag :=
3255: PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(
3256: p_project_id,
3257: l_structure_version_id);

Line 3555: END pa_planning_element_utils;

3551: when no_data_found then
3552: RETURN NULL;
3553: END get_prior_forecast_version_id;
3554:
3555: END pa_planning_element_utils;