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 FND_API

Line 36: x_return_status := FND_API.G_RET_STS_SUCCESS;

32: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
33: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
34: l_wp_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
35: BEGIN
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: begin
38: -- RETRIEVE THE WORKPLAN STRUCTURE VERSION ID which is used for
39: -- join with pa_budget_versions
40: select evs.element_version_id -- changed by shyugen

Line 51: x_return_status := FND_API.G_RET_STS_ERROR;

47: ev.parent_structure_version_id = evs.element_version_id;
48:
49: exception
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');

Line 113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

109: x_published_version_id := -1;
110: end;
111: EXCEPTION
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');

Line 149: x_return_status := FND_API.G_RET_STS_SUCCESS;

145: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
146: l_plan_class_code pa_fin_plan_types_b.plan_class_code%TYPE;
147: l_fin_plan_pref_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
148: BEGIN
149: x_return_status := FND_API.G_RET_STS_SUCCESS;
150: select pt.plan_class_code,
151: po.fin_plan_preference_code
152: into l_plan_class_code,
153: l_fin_plan_pref_code

Line 350: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

346:
347: end if; -- l_plan_class_code
348: EXCEPTION
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');

Line 640: if l_return_status = FND_API.G_RET_STS_SUCCESS then

636: ,x_unit_of_measure => l_unit_of_measure
637: ,x_return_status => l_return_status
638: ,x_msg_count => l_msg_count
639: ,x_msg_data => l_msg_data);
640: if l_return_status = FND_API.G_RET_STS_SUCCESS then
641: return l_uncat_rlm_id;
642: else
643: return null;
644: end if;

Line 1005: x_return_status := FND_API.G_RET_STS_SUCCESS;

1001: l_msg_data VARCHAR2(2000);
1002: l_error_msg_code VARCHAR2(30);
1003: l_msg_index_out NUMBER;
1004: BEGIN
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: if (p_budget_version_id is null) or (p_resource_assignment_id is null) then
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1009: p_msg_name => 'PA_FP_COMMONVO_ERROR');

Line 1007: x_return_status := FND_API.G_RET_STS_ERROR;

1003: l_msg_index_out NUMBER;
1004: BEGIN
1005: x_return_status := FND_API.G_RET_STS_SUCCESS;
1006: if (p_budget_version_id is null) or (p_resource_assignment_id is null) then
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1009: p_msg_name => 'PA_FP_COMMONVO_ERROR');
1010: else
1011: x_budget_version_id := p_budget_version_id;

Line 1178: x_return_status := FND_API.G_RET_STS_ERROR;

1174: bv.budget_version_id = po.fin_plan_version_id and
1175: po.fin_plan_option_level_code = 'PLAN_VERSION';
1176: exception
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');

Line 1467: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

1463: end if; -- if l_resource_assignment_id found
1464: close raid_csr;
1465:
1466: -- Check message stack for error messages
1467: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1468: l_msg_count := FND_MSG_PUB.count_msg;
1469: if l_msg_count = 1 THEN
1470: PA_INTERFACE_UTILS_PUB.get_messages
1471: (p_encoded => FND_API.G_TRUE

Line 1471: (p_encoded => FND_API.G_TRUE

1467: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
1468: l_msg_count := FND_MSG_PUB.count_msg;
1469: if l_msg_count = 1 THEN
1470: PA_INTERFACE_UTILS_PUB.get_messages
1471: (p_encoded => FND_API.G_TRUE
1472: ,p_msg_index => 1
1473: ,p_msg_count => l_msg_count
1474: ,p_msg_data => l_msg_data
1475: ,p_data => l_data

Line 1487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
1490:
1491:

Line 1800: x_return_status := FND_API.G_RET_STS_SUCCESS;

1796: l_error_msg_code VARCHAR2(30);
1797: l_msg_index_out NUMBER;
1798:
1799: BEGIN
1800: x_return_status := FND_API.G_RET_STS_SUCCESS;
1801: if (p_budget_version_id is null) or (p_resource_assignment_id is null) then
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1804: p_msg_name => 'PA_FP_COMMONVO_ERROR');

Line 1802: x_return_status := FND_API.G_RET_STS_ERROR;

1798:
1799: BEGIN
1800: x_return_status := FND_API.G_RET_STS_SUCCESS;
1801: if (p_budget_version_id is null) or (p_resource_assignment_id is null) then
1802: x_return_status := FND_API.G_RET_STS_ERROR;
1803: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
1804: p_msg_name => 'PA_FP_COMMONVO_ERROR');
1805: else
1806: x_budget_version_id := p_budget_version_id;

Line 2021: x_return_status := FND_API.G_RET_STS_ERROR;

2017: bv.budget_version_id = po.fin_plan_version_id and
2018: po.fin_plan_option_level_code = 'PLAN_VERSION';
2019: exception
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');

Line 2501: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

2497: end if;
2498: end if; -- if l_resource_assignment_id found
2499: close raid_csr;
2500: -- Check message stack for error messages
2501: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2502: l_msg_count := FND_MSG_PUB.count_msg;
2503: if l_msg_count = 1 THEN
2504: PA_INTERFACE_UTILS_PUB.get_messages
2505: (p_encoded => FND_API.G_TRUE

Line 2505: (p_encoded => FND_API.G_TRUE

2501: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
2502: l_msg_count := FND_MSG_PUB.count_msg;
2503: if l_msg_count = 1 THEN
2504: PA_INTERFACE_UTILS_PUB.get_messages
2505: (p_encoded => FND_API.G_TRUE
2506: ,p_msg_index => 1
2507: ,p_msg_count => l_msg_count
2508: ,p_msg_data => l_msg_data
2509: ,p_data => l_data

Line 2521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2524:
2525:

Line 2553: x_return_status := FND_API.G_RET_STS_SUCCESS;

2549: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
2550: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
2551: BEGIN
2552: x_msg_count := 0;
2553: x_return_status := FND_API.G_RET_STS_SUCCESS;
2554: IF p_line_start_date IS NOT NULL AND p_line_end_date IS NOT NULL THEN
2555: select bl.start_date,
2556: bl.end_date,
2557: bl.period_name,

Line 2639: x_return_status := FND_API.G_RET_STS_ERROR;

2635: end if; -- x_txn_quantity is not null
2636: EXCEPTION
2637: WHEN NO_DATA_FOUND THEN
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');

Line 2666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
2669:
2670:

Line 2738: x_return_status := FND_API.G_RET_STS_SUCCESS;

2734:
2735: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2736: l_debug_mode := NVL(l_debug_mode, 'Y');
2737: x_msg_count := 0;
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739: PA_DEBUG.Set_Curr_Function( p_function => 'PAFPPEUB.add_new_resource_assignments',
2740: p_debug_mode => l_debug_mode );
2741:
2742: /*CBS enhancement to validate Planning Options of the budget bug#16600305*/

Line 2748: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

2744: P_BUDGET_VERSION_ID => P_BUDGET_VERSION_ID,
2745: X_RETURN_STATUS => X_RETURN_STATUS,
2746: X_MSG_COUNT => X_MSG_COUNT,
2747: X_MSG_DATA => X_MSG_DATA);
2748: IF X_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
2749: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
2750: p_msg_name => x_msg_data);
2751: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;
2752: END IF;

Line 3080: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3076: x_return_status => l_return_status,
3077: x_msg_count => l_msg_count,
3078: x_msg_data => l_msg_data);
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;

Line 3096: (p_encoded => FND_API.G_TRUE

3092: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3093: l_msg_count := FND_MSG_PUB.count_msg;
3094: IF l_msg_count = 1 THEN
3095: PA_INTERFACE_UTILS_PUB.get_messages
3096: (p_encoded => FND_API.G_TRUE
3097: ,p_msg_index => 1
3098: ,p_msg_count => l_msg_count
3099: ,p_msg_data => l_msg_data
3100: ,p_data => l_data

Line 3107: x_return_status := FND_API.G_RET_STS_ERROR;

3103: x_msg_count := l_msg_count;
3104: ELSE
3105: x_msg_count := l_msg_count;
3106: END IF;
3107: x_return_status := FND_API.G_RET_STS_ERROR;
3108: pa_debug.reset_curr_function;
3109:
3110: WHEN OTHERS THEN
3111:

Line 3112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3108: pa_debug.reset_curr_function;
3109:
3110: WHEN OTHERS THEN
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');

Line 3129: FND_API.G_MISS_NUM (x_num)

3125: END add_new_resource_assignments;
3126:
3127:
3128: /* This procedure is used to retrieve:
3129: FND_API.G_MISS_NUM (x_num)
3130: FND_API.G_MISS_CHAR (x_char)
3131: FND_API.G_MISS_DATE (x_date)
3132: so it can be passed to the Java-side for further use
3133: */

Line 3130: FND_API.G_MISS_CHAR (x_char)

3126:
3127:
3128: /* This procedure is used to retrieve:
3129: FND_API.G_MISS_NUM (x_num)
3130: FND_API.G_MISS_CHAR (x_char)
3131: FND_API.G_MISS_DATE (x_date)
3132: so it can be passed to the Java-side for further use
3133: */
3134: PROCEDURE get_fnd_miss_constants

Line 3131: FND_API.G_MISS_DATE (x_date)

3127:
3128: /* This procedure is used to retrieve:
3129: FND_API.G_MISS_NUM (x_num)
3130: FND_API.G_MISS_CHAR (x_char)
3131: FND_API.G_MISS_DATE (x_date)
3132: so it can be passed to the Java-side for further use
3133: */
3134: PROCEDURE get_fnd_miss_constants
3135: (x_num OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3139: x_num:=FND_API.G_MISS_NUM;

3135: (x_num OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3136: x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3137: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3138: BEGIN
3139: x_num:=FND_API.G_MISS_NUM;
3140: x_char:=FND_API.G_MISS_CHAR;
3141: x_date:=FND_API.G_MISS_DATE;
3142: END get_fnd_miss_constants;
3143:

Line 3140: x_char:=FND_API.G_MISS_CHAR;

3136: x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3137: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3138: BEGIN
3139: x_num:=FND_API.G_MISS_NUM;
3140: x_char:=FND_API.G_MISS_CHAR;
3141: x_date:=FND_API.G_MISS_DATE;
3142: END get_fnd_miss_constants;
3143:
3144: /* REVISION HISTORY

Line 3141: x_date:=FND_API.G_MISS_DATE;

3137: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3138: BEGIN
3139: x_num:=FND_API.G_MISS_NUM;
3140: x_char:=FND_API.G_MISS_CHAR;
3141: x_date:=FND_API.G_MISS_DATE;
3142: END get_fnd_miss_constants;
3143:
3144: /* REVISION HISTORY
3145: * Created: 07/20/2004 by DLAI for bug 3747582