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_PROJECT_SEARCH_UTILS dependencies on FND_API

Line 32: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then

28: WHERE upper(customer_name) = upper(p_customer_name) and status = 'A';
29:
30: BEGIN
31:
32: if (p_customer_id = FND_API.G_MISS_NUM) OR (p_customer_id is NULL) then
33: if (p_customer_name is not NULL) then
34:
35: OPEN c_ids;
36: LOOP

Line 53: x_return_status := FND_API.G_RET_STS_SUCCESS;

49: x_customer_id := NULL;
50: end if;
51:
52: end if;
53: x_return_status := FND_API.G_RET_STS_SUCCESS;
54:
55: EXCEPTION
56: when NO_DATA_FOUND then
57: x_customer_id := NULL;

Line 58: x_return_status := FND_API.G_RET_STS_ERROR;

54:
55: EXCEPTION
56: when NO_DATA_FOUND then
57: x_customer_id := NULL;
58: x_return_status := FND_API.G_RET_STS_ERROR;
59: x_error_msg_code := 'PA_CUSTOMER_ID_INVALID';
60:
61: when OTHERS then
62: x_customer_id := NULL;

Line 63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

59: x_error_msg_code := 'PA_CUSTOMER_ID_INVALID';
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;

Line 116: IF (p_resource_id IS NULL) OR (p_resource_id = FND_API.G_MISS_NUM) THEN

112: WHERE user_id = FND_GLOBAL.user_id;
113:
114: BEGIN
115:
116: IF (p_resource_id IS NULL) OR (p_resource_id = FND_API.G_MISS_NUM) THEN
117:
118: if (p_resource_name IS NOT NULL) then
119:
120: OPEN r_ids;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: EXCEPTION
169: when NO_DATA_FOUND then
170: x_resource_id := NULL;
171: x_resource_type_id := NULL;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_error_msg_code := 'PA_RESOURCE_INVALID_AMBIGUOUS';
174:
175: when OTHERS then
176: x_resource_id := NULL;

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174:
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;

Line 219: IF (p_person_id IS NULL) OR (p_person_id = FND_API.G_MISS_NUM) THEN

215: WHERE user_id = FND_GLOBAL.user_id;
216:
217: BEGIN
218:
219: IF (p_person_id IS NULL) OR (p_person_id = FND_API.G_MISS_NUM) THEN
220:
221: if (p_person_name IS NOT NULL) then
222:
223: OPEN r_ids;

Line 252: x_return_status := FND_API.G_RET_STS_ERROR;

248:
249: EXCEPTION
250: when NO_DATA_FOUND then
251: x_person_id := NULL;
252: x_return_status := FND_API.G_RET_STS_ERROR;
253: x_error_msg_code := 'PA_RESOURCE_INVALID_AMBIGUOUS';
254:
255: when OTHERS then
256: x_person_id := NULL;

Line 257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

253: x_error_msg_code := 'PA_RESOURCE_INVALID_AMBIGUOUS';
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;

Line 283: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

279: ,x_msg_data OUT NOCOPY VARCHAR2
280: )
281: IS
282:
283: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
284: l_msg_count NUMBER;
285: l_msg_data VARCHAR2(200);
286: l_param_type_tbl SYSTEM.pa_varchar2_30_tbl_type := p_param_type_tbl;
287: l_param_value_tbl SYSTEM.pa_varchar2_240_tbl_type := p_param_value_tbl;

Line 295: x_return_status := FND_API.G_RET_STS_SUCCESS;

291:
292: BEGIN
293:
294: -- initialize return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: IF p_init_msg_list = FND_API.G_TRUE THEN
298: fnd_msg_pub.initialize;
299: END IF;

Line 297: IF p_init_msg_list = FND_API.G_TRUE THEN

293:
294: -- initialize return status to success
295: x_return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: IF p_init_msg_list = FND_API.G_TRUE THEN
298: fnd_msg_pub.initialize;
299: END IF;
300:
301: -- if there is at least one item in the array, process the name to id

Line 369: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

365:
366: END IF;
367:
368:
369: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
370: x_param_id_tbl(i) := -999;
371: -- also add message to error stack
372: PA_UTILS.Add_Message ( p_app_short_name => 'PA'
373: ,p_msg_name => l_msg_data);

Line 386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

382: END IF;
383:
384: EXCEPTION
385: WHEN OTHERS THEN
386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387: RAISE;
388:
389: END Convert_NameToId;
390:

Line 413: l_sec_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

409: x_msg_count OUT NOCOPY NUMBER,
410: x_msg_data OUT NOCOPY VARCHAR2
411: )
412: IS
413: l_sec_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
414: l_sec_msg_count NUMBER := 0;
415: l_sec_msg_data VARCHAR2(1) := NULL;
416:
417: BEGIN