DBA Data[Home] [Help]

APPS.PA_FP_VIEW_PLANS_UTIL dependencies on FND_API

Line 726: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1729: pa_debug.write_file('get_period_n_value: p_resource_assignment_id= ' ||
1730: to_char(p_resource_assignment_id));
1731: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1732: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1734: WHEN OTHERS THEN
1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1736: end get_period_n_value;
1737:

Line 1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1731: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
1732: p_procedure_name => 'get_period_n_value: TOO_MANY_ROWS');
1733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1734: WHEN OTHERS THEN
1735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1736: end get_period_n_value;
1737:
1738:
1739: /* THIS IMPLEMENTATION IS INCORRECT BECAUSE WE'RE TRYING TO INCORPORATE

Line 4676: x_return_status := FND_API.G_RET_STS_SUCCESS;

4672: current_flag ='Y';
4673: PA_ppId_rec GL_ppId%ROWTYPE;
4674:
4675: BEGIN
4676: x_return_status := FND_API.G_RET_STS_SUCCESS;
4677: -- RETRIEVE the current period_profile_id's for GL
4678: open GL_ppId;
4679: fetch GL_ppId into GL_ppId_rec;
4680: if GL_ppId%NOTFOUND then

Line 4714: x_return_status := FND_API.G_RET_STS_ERROR;

4710: PA_DEBUG.g_err_stage := 'Error while submitting Report [PAFPEXRP]';
4711: PA_DEBUG.Log_Message(p_message => PA_DEBUG.g_err_stage);
4712: PA_UTILS.ADD_MESSAGE( p_app_short_name => 'PA',
4713: p_msg_name => 'PA_FP_PP_CONC_PGM_ERR');
4714: x_return_status := FND_API.G_RET_STS_ERROR;
4715: ROLLBACK;
4716: RETURN;
4717: ELSE
4718: PA_DEBUG.g_err_stage := 'Exception Report Request Id : ' ||

Line 4741: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN

4737: record_version_number = record_version_number + 1,
4738: request_id = x_conc_req_id,
4739: locked_by_person_id = -98
4740: where budget_version_id = p_budget_version_id2;
4741: IF x_return_Status = FND_API.G_RET_STS_SUCCESS THEN
4742: COMMIT;
4743: ELSE
4744: ROLLBACK;
4745: END IF;

Line 4902: x_return_status := FND_API.G_RET_STS_SUCCESS;

4898: l_res_assignment_exists VARCHAR2(1);
4899: l_msg_index_out NUMBER(30);
4900: BEGIN
4901: x_msg_count := 0;
4902: x_return_status := FND_API.G_RET_STS_SUCCESS;
4903: select 'Y'
4904: into l_res_assignment_exists
4905: from dual
4906: where exists

Line 4926: x_return_status := FND_API.G_RET_STS_ERROR;

4922: p_token1 => 'TASK_NAME',
4923: p_value1 => p_task_name,
4924: p_token2 => 'TASK_NUMBER',
4925: p_value2 => p_task_number);
4926: x_return_status := FND_API.G_RET_STS_ERROR;
4927: x_msg_count := FND_MSG_PUB.Count_Msg;
4928: if x_msg_count = 1 then
4929: PA_INTERFACE_UTILS_PUB.get_messages
4930: (p_encoded => FND_API.G_TRUE,

Line 4930: (p_encoded => FND_API.G_TRUE,

4926: x_return_status := FND_API.G_RET_STS_ERROR;
4927: x_msg_count := FND_MSG_PUB.Count_Msg;
4928: if x_msg_count = 1 then
4929: PA_INTERFACE_UTILS_PUB.get_messages
4930: (p_encoded => FND_API.G_TRUE,
4931: p_msg_index => 1,
4932: p_data => x_msg_data,
4933: p_msg_index_out => l_msg_index_out);
4934: end if;

Line 4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

4934: end if;
4935: return;
4936: */
4937: WHEN OTHERS THEN
4938: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4939: x_msg_count := 1;
4940: x_msg_data := SQLERRM;
4941: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
4942: p_procedure_name => 'check_res_assignment_exists');

Line 4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;

4940: x_msg_data := SQLERRM;
4941: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
4942: p_procedure_name => 'check_res_assignment_exists');
4943: pa_debug.reset_err_stack;
4944: raise FND_API.G_EXC_UNEXPECTED_ERROR;
4945: END check_res_assignment_exists;
4946:
4947:
4948: -- FP L: used in View/Edit Plan page to determine if a plan version is planned

Line 5005: x_return_status := FND_API.G_RET_STS_SUCCESS;

5001: fpe.plannable_flag = 'Y';
5002: c1_rec c1%ROWTYPE;
5003:
5004: BEGIN
5005: x_return_status := FND_API.G_RET_STS_SUCCESS;
5006: x_msg_count := 0;
5007:
5008: /* If group_resource_type_id is 0, then version could be planned by Resources,
5009: or the resource list could be None. Therefore, we need to check the

Line 5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5111: end if;
5112: pa_debug.reset_err_stack;
5113: EXCEPTION
5114: WHEN OTHERS THEN
5115: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5116: x_msg_count := 1;
5117: x_msg_data := SQLERRM;
5118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5119: p_procedure_name => 'get_plan_version_res_level');

Line 5121: raise FND_API.G_EXC_UNEXPECTED_ERROR;

5117: x_msg_data := SQLERRM;
5118: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'pa_fp_view_plans_util',
5119: p_procedure_name => 'get_plan_version_res_level');
5120: pa_debug.reset_err_stack;
5121: raise FND_API.G_EXC_UNEXPECTED_ERROR;
5122: END get_plan_version_res_level;
5123:
5124: end pa_fp_view_plans_util;