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.16.12020000.5 2013/05/04 11:18:03 bpottipa 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.16.12020000.5 2013/05/04 11:18:03 bpottipa 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 2024: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS',

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

Line 2406: pa_planning_element_utils.get_initial_budget_line_info

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

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

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

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

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

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

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

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

3079:
3080: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3081: IF l_debug_mode = 'Y' THEN
3082: pa_debug.g_err_stage:='ADD PLAN TXN Returned Error';
3083: pa_debug.write('PA_PLANNING_ELEMENT_UTILS.add_new_resource_assignments',pa_debug.g_err_stage,3);
3084: END IF;
3085:
3086: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
3087: END IF;

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

3111:
3112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3113: x_msg_count := 1;
3114: x_msg_data := SQLERRM;
3115: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_PLANNING_ELEMENT_UTILS'
3116: ,p_procedure_name => 'add_new_resource_assignments');
3117:
3118: IF l_debug_mode = 'Y' THEN
3119: pa_debug.g_err_stage:='Unexpected Error'||SQLERRM;

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

3293: --hr_utility.trace_on(null, 'dlai');
3294: --hr_utility.trace('ENTERING GET PERCENT COMPLETE API');
3295: l_return_value := null;
3296: l_structure_version_id :=
3297: pa_planning_element_utils.get_fin_struct_id(p_project_id,p_budget_version_id);
3298: l_structure_status_flag :=
3299: PA_PROJECT_STRUCTURE_UTILS.Check_Struc_Ver_Published(
3300: p_project_id,
3301: l_structure_version_id);

Line 3599: END pa_planning_element_utils;

3595: when no_data_found then
3596: RETURN NULL;
3597: END get_prior_forecast_version_id;
3598:
3599: END pa_planning_element_utils;