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 1799: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1801: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2020: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2500: if x_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 2504: (p_encoded => FND_API.G_TRUE

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

Line 2520: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2552: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 2638: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2665: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2732: x_return_status := FND_API.G_RET_STS_SUCCESS;

2728:
2729: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);
2730: l_debug_mode := NVL(l_debug_mode, 'Y');
2731: x_msg_count := 0;
2732: x_return_status := FND_API.G_RET_STS_SUCCESS;
2733: PA_DEBUG.Set_Curr_Function( p_function => 'PAFPPEUB.add_new_resource_assignments',
2734: p_debug_mode => l_debug_mode );
2735:
2736: IF l_debug_mode = 'Y' THEN

Line 3036: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3032: x_return_status => l_return_status,
3033: x_msg_count => l_msg_count,
3034: x_msg_data => l_msg_data);
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;

Line 3052: (p_encoded => FND_API.G_TRUE

3048: WHEN PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc THEN
3049: l_msg_count := FND_MSG_PUB.count_msg;
3050: IF l_msg_count = 1 THEN
3051: PA_INTERFACE_UTILS_PUB.get_messages
3052: (p_encoded => FND_API.G_TRUE
3053: ,p_msg_index => 1
3054: ,p_msg_count => l_msg_count
3055: ,p_msg_data => l_msg_data
3056: ,p_data => l_data

Line 3063: x_return_status := FND_API.G_RET_STS_ERROR;

3059: x_msg_count := l_msg_count;
3060: ELSE
3061: x_msg_count := l_msg_count;
3062: END IF;
3063: x_return_status := FND_API.G_RET_STS_ERROR;
3064: pa_debug.reset_curr_function;
3065:
3066: WHEN OTHERS THEN
3067:

Line 3068: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3064: pa_debug.reset_curr_function;
3065:
3066: WHEN OTHERS THEN
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');

Line 3085: FND_API.G_MISS_NUM (x_num)

3081: END add_new_resource_assignments;
3082:
3083:
3084: /* This procedure is used to retrieve:
3085: FND_API.G_MISS_NUM (x_num)
3086: FND_API.G_MISS_CHAR (x_char)
3087: FND_API.G_MISS_DATE (x_date)
3088: so it can be passed to the Java-side for further use
3089: */

Line 3086: FND_API.G_MISS_CHAR (x_char)

3082:
3083:
3084: /* This procedure is used to retrieve:
3085: FND_API.G_MISS_NUM (x_num)
3086: FND_API.G_MISS_CHAR (x_char)
3087: FND_API.G_MISS_DATE (x_date)
3088: so it can be passed to the Java-side for further use
3089: */
3090: PROCEDURE get_fnd_miss_constants

Line 3087: FND_API.G_MISS_DATE (x_date)

3083:
3084: /* This procedure is used to retrieve:
3085: FND_API.G_MISS_NUM (x_num)
3086: FND_API.G_MISS_CHAR (x_char)
3087: FND_API.G_MISS_DATE (x_date)
3088: so it can be passed to the Java-side for further use
3089: */
3090: PROCEDURE get_fnd_miss_constants
3091: (x_num OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3095: x_num:=FND_API.G_MISS_NUM;

3091: (x_num OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3092: x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3093: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3094: BEGIN
3095: x_num:=FND_API.G_MISS_NUM;
3096: x_char:=FND_API.G_MISS_CHAR;
3097: x_date:=FND_API.G_MISS_DATE;
3098: END get_fnd_miss_constants;
3099:

Line 3096: x_char:=FND_API.G_MISS_CHAR;

3092: x_char OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3093: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3094: BEGIN
3095: x_num:=FND_API.G_MISS_NUM;
3096: x_char:=FND_API.G_MISS_CHAR;
3097: x_date:=FND_API.G_MISS_DATE;
3098: END get_fnd_miss_constants;
3099:
3100: /* REVISION HISTORY

Line 3097: x_date:=FND_API.G_MISS_DATE;

3093: x_date OUT NOCOPY DATE) IS --File.Sql.39 bug 4440895
3094: BEGIN
3095: x_num:=FND_API.G_MISS_NUM;
3096: x_char:=FND_API.G_MISS_CHAR;
3097: x_date:=FND_API.G_MISS_DATE;
3098: END get_fnd_miss_constants;
3099:
3100: /* REVISION HISTORY
3101: * Created: 07/20/2004 by DLAI for bug 3747582