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.

[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on FND_API

Line 728: x_return_status := FND_API.G_RET_STS_ERROR;

724: -- IF WE FIND NO AMOUNT SET, then we cannot query amount sets table, so throw error
725: if l_amount_set_id = -1 then
726: PA_UTILS.ADD_MESSAGE(p_app_short_name => 'PA',
727: p_msg_name => 'PA_FP_NO_AMOUNT_SET_ID');
728: x_return_status := FND_API.G_RET_STS_ERROR;
729: l_msg_count := l_msg_count + 1;
730: x_msg_count := l_msg_count;
731: return;
732: else

Line 795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

791: x_default_amount_type_code := l_default_amount_type_code;
792: x_default_amount_subtype_code := l_default_amount_subtype_code;
793: EXCEPTION
794: when others then
795: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
796: x_msg_count := 1;
797: x_msg_data := SQLERRM;
798: FND_MSG_PUB.add_exc_msg( p_pkg_name => 'PA_FP_VIEW_PLANS_PUB',
799: p_procedure_name => 'Assign_Default_Amount');

Line 963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

959: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
960: to_char(p_resource_assignment_id));
961: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
962: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: WHEN OTHERS THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: end get_period_n_value;
967:

Line 965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

961: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
962: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
963: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
964: WHEN OTHERS THEN
965: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
966: end get_period_n_value;
967:
968: /* Ends changes for 7514054 */
969:

Line 1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1898: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1899: to_char(p_resource_assignment_id));
1900: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1901: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: WHEN OTHERS THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: end get_period_n_value;
1906:

Line 1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1900: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1901: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1902: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1903: WHEN OTHERS THEN
1904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1905: end get_period_n_value;
1906:
1907: Ends commented for 7514054 */
1908:

Line 4846: x_return_status := FND_API.G_RET_STS_SUCCESS;

4842: current_flag ='Y';
4843: PA_ppId_rec GL_ppId%ROWTYPE;
4844:
4845: BEGIN
4846: x_return_status := FND_API.G_RET_STS_SUCCESS;
4847: -- RETRIEVE the current period_profile_id's for GL
4848: open GL_ppId;
4849: fetch GL_ppId into GL_ppId_rec;
4850: if GL_ppId%NOTFOUND then

Line 4884: x_return_status := FND_API.G_RET_STS_ERROR;

4880: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4881: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4882: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4883: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4884: x_return_status := FND_API.G_RET_STS_ERROR;
4885: ROLLBACK;
4886: RETURN;
4887: ELSE
4888: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||

Line 4911: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

4907: record_version_number = record_version_number + 1,
4908: request_id = x_conc_req_id,
4909: locked_by_person_id = -98
4910: where budget_version_id = p_budget_version_id2;
4911: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
4912: COMMIT;
4913: ELSE
4914: ROLLBACK;
4915: END IF;

Line 5072: x_return_status := FND_API.G_RET_STS_SUCCESS;

5068: l_res_assignment_exists VARCHAR2(1);
5069: l_msg_index_out NUMBER(30);
5070: BEGIN
5071: x_msg_count := 0;
5072: x_return_status := FND_API.G_RET_STS_SUCCESS;
5073: select 'Y'
5074: into l_res_assignment_exists
5075: from dual
5076: where exists

Line 5096: x_return_status := FND_API.G_RET_STS_ERROR;

5092: p_token1 => 'TASK_NAME',
5093: p_value1 => p_task_name,
5094: p_token2 => 'TASK_NUMBER',
5095: p_value2 => p_task_number);
5096: x_return_status := FND_API.G_RET_STS_ERROR;
5097: x_msg_count := FND_MSG_PUB.Count_Msg;
5098: if x_msg_count = 1 then
5099: PA_INTERFACE_UTILS_PUB.get_messages
5100: (p_encoded => FND_API.G_TRUE,

Line 5100: (p_encoded => FND_API.G_TRUE,

5096: x_return_status := FND_API.G_RET_STS_ERROR;
5097: x_msg_count := FND_MSG_PUB.Count_Msg;
5098: if x_msg_count = 1 then
5099: PA_INTERFACE_UTILS_PUB.get_messages
5100: (p_encoded => FND_API.G_TRUE,
5101: p_msg_index => 1,
5102: p_data => x_msg_data,
5103: p_msg_index_out => l_msg_index_out);
5104: end if;

Line 5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5104: end if;
5105: return;
5106: */
5107: WHEN OTHERS THEN
5108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5109: x_msg_count := 1;
5110: x_msg_data := SQLERRM;
5111: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5112: p_procedure_name => 'check_res_assignment_exists');

Line 5114: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5110: x_msg_data := SQLERRM;
5111: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5112: p_procedure_name => 'check_res_assignment_exists');
5113: pa_debug.reset_err_stack;
5114: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5115: END check_res_assignment_exists;
5116:
5117:
5118: -- FP L: used in View/Edit Plan page to determine if a plan version is planned

Line 5175: x_return_status := FND_API.G_RET_STS_SUCCESS;

5171: fpe.plannable_flag = 'Y';
5172: c1_rec c1%ROWTYPE;
5173:
5174: BEGIN
5175: x_return_status := FND_API.G_RET_STS_SUCCESS;
5176: x_msg_count := 0;
5177:
5178: /* If group_resource_type_id is 0, then version could be planned by Resources,
5179: or the resource list could be None. Therefore, we need to check the

Line 5285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5281: end if;
5282: pa_debug.reset_err_stack;
5283: EXCEPTION
5284: WHEN OTHERS THEN
5285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5286: x_msg_count := 1;
5287: x_msg_data := SQLERRM;
5288: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5289: p_procedure_name => 'get_plan_version_res_level');

Line 5291: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5287: x_msg_data := SQLERRM;
5288: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5289: p_procedure_name => 'get_plan_version_res_level');
5290: pa_debug.reset_err_stack;
5291: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5292: END get_plan_version_res_level;
5293:
5294: end pa_fp_view_plans_util;