[Home] [Help]
1: PACKAGE BODY pa_project_search_utils AS
2: /*$Header: PAPRSUTB.pls 120.2 2006/02/28 05:07:45 dthakker noship $*/
3:
4: ------------------------------------------------------------
5: -- Procedure: Check_Customer_Name_Or_Id
60:
61: when OTHERS then
62: x_customer_id := NULL;
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SEARCH_UTILS', p_procedure_name => 'CHECK_CUSTOMER_NAME_OR_ID');
65: raise;
66:
67: END Check_Customer_Name_Or_Id;
68:
175: when OTHERS then
176: x_resource_id := NULL;
177: x_resource_type_id := NULL;
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SEARCH_UTILS', p_procedure_name => 'Check_PersonName_Or_Id');
180: raise;
181:
182: END Check_PersonName_Or_Id;
183:
254:
255: when OTHERS then
256: x_person_id := NULL;
257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
258: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SEARCH_UTILS', p_procedure_name => 'Check_PersonName_Or_Id');
259: raise;
260:
261: END Check_ResourceName_Or_Id;
262:
329:
330: ELSIF l_param_type_tbl(i) = 'CUSTOMER' THEN
331:
332: -- call API to validate customer name
333: PA_PROJECT_SEARCH_UTILS.CHECK_CUSTOMER_NAME_OR_ID(
334: p_customer_id => null
335: ,p_customer_name => l_param_value_tbl(i)
336: ,x_customer_id => l_id
337: ,x_return_status => l_return_status
338: ,x_error_msg_code => l_msg_data);
339:
340: ELSIF l_param_type_tbl(i) = 'PERSON' OR l_param_type_tbl(i) = 'MANAGER' THEN
341: -- call API to validate person or manager name
342: PA_PROJECT_SEARCH_UTILS.Check_PersonName_Or_Id(
343: p_resource_id => null
344: ,p_resource_name => l_param_value_tbl(i)
345: ,x_resource_id => l_id
346: ,x_resource_type_id => l_type_id
471: raise;
472:
473: END Get_Perf_Measures;
474:
475: END PA_PROJECT_SEARCH_UTILS;