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

Line 239: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

235:
236: PROCEDURE add_projects_to_proj_set
237: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
238: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type
239: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
240: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
242: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 240: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

236: PROCEDURE add_projects_to_proj_set
237: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
238: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type
239: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
240: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
242: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
244: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 241: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE

237: ( p_project_set_id IN pa_project_sets_b.project_set_id%TYPE
238: ,p_project_id_tbl IN SYSTEM.pa_num_tbl_type
239: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
240: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
241: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
242: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
243: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
244: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
245: ,x_project_list OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

247: )
248: IS
249:
250: l_msg_index_out NUMBER;
251: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
252: l_project_id_tbl SYSTEM.pa_num_tbl_type := p_project_id_tbl;
253: l_msg_count NUMBER;
254: l_msg_data VARCHAR2(200);
255: l_exists VARCHAR2(4);

Line 271: x_return_status := FND_API.G_RET_STS_SUCCESS;

267:
268: BEGIN
269:
270: -- initialize return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: IF p_init_msg_list = FND_API.G_TRUE THEN
274: fnd_msg_pub.initialize;
275: END IF;

Line 273: IF p_init_msg_list = FND_API.G_TRUE THEN

269:
270: -- initialize return status to success
271: x_return_status := FND_API.G_RET_STS_SUCCESS;
272:
273: IF p_init_msg_list = FND_API.G_TRUE THEN
274: fnd_msg_pub.initialize;
275: END IF;
276:
277: -- get the project set name to be displayed in the informational msg if necessary

Line 325: x_return_status := FND_API.G_RET_STS_ERROR;

321: EXCEPTION
322: WHEN OTHERS THEN
323: x_project_list := '';
324: x_project_set_name := '';
325: x_return_status := FND_API.G_RET_STS_ERROR;
326:
327: END add_projects_to_proj_set;
328:
329:

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: PA_DEBUG.init_err_stack('PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id');
346: END IF;
347:
348: -- Initialize the return status to success
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: IF p_party_id IS NOT NULL THEN
352: IF p_check_id_flag = 'Y' THEN
353: SELECT party_id

Line 370: x_return_status := FND_API.G_RET_STS_ERROR;

366:
367: EXCEPTION
368: WHEN NO_DATA_FOUND THEN
369: x_party_id := NULL;
370: x_return_status := FND_API.G_RET_STS_ERROR;
371: x_error_msg_code := 'PA_PARTY_INVALID';
372: WHEN TOO_MANY_ROWS then
373: x_party_id := NULL;
374: x_return_status := FND_API.G_RET_STS_ERROR;

Line 374: x_return_status := FND_API.G_RET_STS_ERROR;

370: x_return_status := FND_API.G_RET_STS_ERROR;
371: x_error_msg_code := 'PA_PARTY_INVALID';
372: WHEN TOO_MANY_ROWS then
373: x_party_id := NULL;
374: x_return_status := FND_API.G_RET_STS_ERROR;
375: x_error_msg_code := 'PA_MULTIPLE_PARTY';
376: WHEN OTHERS THEN
377: -- Set the exception Message and the stack
378: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id'

Line 380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

376: WHEN OTHERS THEN
377: -- Set the exception Message and the stack
378: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SET_UTILS.Check_PartyName_Or_Id'
379: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
381: RAISE;
382: END Check_PartyName_Or_Id;
383:
384:

Line 404: if (p_project_set_id = FND_API.G_MISS_NUM) OR (p_project_set_id is NULL) then

400: FROM pa_project_sets_vl
401: WHERE upper(name) = upper(p_project_set_name);
402: BEGIN
403:
404: if (p_project_set_id = FND_API.G_MISS_NUM) OR (p_project_set_id is NULL) then
405: if (p_project_set_name is not NULL) then
406: SELECT project_set_id
407: INTO x_project_set_id
408: FROM pa_project_sets_vl

Line 462: x_return_status := FND_API.G_RET_STS_SUCCESS;

458: END IF;
459:
460: end if;
461:
462: x_return_status := FND_API.G_RET_STS_SUCCESS;
463:
464: EXCEPTION
465: when NO_DATA_FOUND then
466: x_project_set_id := NULL;

Line 467: x_return_status := FND_API.G_RET_STS_ERROR;

463:
464: EXCEPTION
465: when NO_DATA_FOUND then
466: x_project_set_id := NULL;
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: x_error_msg_code := 'PA_PROJECT_SET_INVALID';
469: when TOO_MANY_ROWS then
470: x_project_set_id := NULL;
471: x_return_status := FND_API.G_RET_STS_ERROR;

Line 471: x_return_status := FND_API.G_RET_STS_ERROR;

467: x_return_status := FND_API.G_RET_STS_ERROR;
468: x_error_msg_code := 'PA_PROJECT_SET_INVALID';
469: when TOO_MANY_ROWS then
470: x_project_set_id := NULL;
471: x_return_status := FND_API.G_RET_STS_ERROR;
472: x_error_msg_code := 'PA_PROJECT_SET_INVALID';
473: when OTHERS then
474: x_project_set_id := NULL;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

471: x_return_status := FND_API.G_RET_STS_ERROR;
472: x_error_msg_code := 'PA_PROJECT_SET_INVALID';
473: when OTHERS then
474: x_project_set_id := NULL;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.add_exc_msg(p_pkg_name => 'PA_PROJECT_SETS_UTILS', p_procedure_name => 'CHECK_PROJECTSETNAME_OR_ID');
477: raise;
478:
479: END Check_ProjectSetName_Or_Id;