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

Line 19: x_return_status:=fnd_api.g_ret_sts_success;

15: WHERE project_id = p_project_id;
16: l_dummy number;
17:
18: BEGIN
19: x_return_status:=fnd_api.g_ret_sts_success;
20:
21: IF (p_object_type = 'PA_PROJECTS') THEN
22: -- Validate project_id_from
23: OPEN c_project_exists (p_object_id_from);

Line 28: x_return_status := FND_API.G_RET_STS_ERROR;

24: FETCH c_project_exists INTO l_dummy;
25: IF(c_project_exists%NOTFOUND) THEN
26: PA_UTILS.Add_Message( p_app_short_name => 'PA'
27: ,p_msg_name => 'PA_INVALID_PROJECT_ID');
28: x_return_status := FND_API.G_RET_STS_ERROR;
29: --x_ret_code:= fnd_api.g_false;
30: x_msg_count := x_msg_count + 1;
31: END IF;
32: CLOSE c_project_exists;

Line 29: --x_ret_code:= fnd_api.g_false;

25: IF(c_project_exists%NOTFOUND) THEN
26: PA_UTILS.Add_Message( p_app_short_name => 'PA'
27: ,p_msg_name => 'PA_INVALID_PROJECT_ID');
28: x_return_status := FND_API.G_RET_STS_ERROR;
29: --x_ret_code:= fnd_api.g_false;
30: x_msg_count := x_msg_count + 1;
31: END IF;
32: CLOSE c_project_exists;
33:

Line 40: x_return_status := FND_API.G_RET_STS_ERROR;

36: FETCH c_project_exists INTO l_dummy;
37: IF(c_project_exists%NOTFOUND) THEN
38: PA_UTILS.Add_Message( p_app_short_name => 'PA'
39: ,p_msg_name => 'PA_INVALID_PROJECT_ID');
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: --x_ret_code:= fnd_api.g_false;
42: x_msg_count := x_msg_count + 1;
43: END IF;
44: CLOSE c_project_exists;

Line 41: --x_ret_code:= fnd_api.g_false;

37: IF(c_project_exists%NOTFOUND) THEN
38: PA_UTILS.Add_Message( p_app_short_name => 'PA'
39: ,p_msg_name => 'PA_INVALID_PROJECT_ID');
40: x_return_status := FND_API.G_RET_STS_ERROR;
41: --x_ret_code:= fnd_api.g_false;
42: x_msg_count := x_msg_count + 1;
43: END IF;
44: CLOSE c_project_exists;
45: END IF;

Line 53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

49: close c_project_exists;
50: END IF;
51: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_UTILS'
52: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: --x_ret_code:= fnd_api.g_false;
55: END VALIDATE_PARAMETERS;
56:
57:

Line 54: --x_ret_code:= fnd_api.g_false;

50: END IF;
51: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PAGE_LAYOUT_UTILS'
52: ,p_procedure_name => PA_DEBUG.G_Err_Stack );
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
54: --x_ret_code:= fnd_api.g_false;
55: END VALIDATE_PARAMETERS;
56:
57:
58: PROCEDURE COPY_OBJECT_PAGE_LAYOUTS(

Line 112: --x_ret_code:= fnd_api.g_true;

108: l_rep_start_date Date; -- Added for Bug 3026572
109:
110: BEGIN
111: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_UTILS.copy_project_page_layouts');
112: --x_ret_code:= fnd_api.g_true;
113: x_return_status:=fnd_api.g_ret_sts_success;
114: savepoint copy_object_page_layouts;
115:
116:

Line 113: x_return_status:=fnd_api.g_ret_sts_success;

109:
110: BEGIN
111: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_UTILS.copy_project_page_layouts');
112: --x_ret_code:= fnd_api.g_true;
113: x_return_status:=fnd_api.g_ret_sts_success;
114: savepoint copy_object_page_layouts;
115:
116:
117:

Line 126: IF (x_return_status = fnd_api.g_ret_sts_success) THEN

122: x_msg_count => x_msg_count ,
123: x_msg_data => x_msg_data
124: );
125:
126: IF (x_return_status = fnd_api.g_ret_sts_success) THEN
127: -- Insert the object page layouts for the new object ID
128:
129: FOR obj_page_layout_rec in obj_page_layout LOOP
130: /* Bug 3026572 Begin */

Line 199: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

195: x_msg_count => x_msg_count ,
196: x_msg_data => x_msg_data
197: );
198:
199: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
200: l_commit_flag := 'N';
201: END IF;
202: END LOOP;
203:

Line 218: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

214: P_LAST_UPDATE_DATE => sysdate ,
215: P_LAST_UPDATED_BY => fnd_global.user_id ,
216: P_LAST_UPDATE_LOGIN => fnd_global.user_id
217: );
218: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
219: l_commit_flag := 'N';
220: END IF;
221: END LOOP;
222:

Line 236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

232: ROLLBACK TO copy_object_page_layouts;
233: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.copy_object_page_layouts',
234: p_procedure_name => PA_DEBUG.G_Err_Stack );
235:
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
237: END COPY_OBJECT_PAGE_LAYOUTS;
238:
239: /* This is the function to check customer and project value columns
240: exists in the project header at the project level. This is for the

Line 446: p_pagelayout_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

442: END GET_CONTEXT_NAME;
443:
444:
445: PROCEDURE CHECK_PAGELAYOUT_NAME_OR_ID (
446: p_pagelayout_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
447: p_pagetype_code IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
448: p_check_id_flag IN VARCHAR2 := 'A' ,
449: x_pagelayout_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
450: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

Line 447: p_pagetype_code IN VARCHAR2 :=FND_API.G_MISS_CHAR ,

443:
444:
445: PROCEDURE CHECK_PAGELAYOUT_NAME_OR_ID (
446: p_pagelayout_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
447: p_pagetype_code IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
448: p_check_id_flag IN VARCHAR2 := 'A' ,
449: x_pagelayout_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
450: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
451: x_error_message_code OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 490: x_return_status := FND_API.G_RET_STS_SUCCESS;

486: x_pagelayout_id := null;
487: END IF;
488: END IF;
489:
490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: EXCEPTION
493: WHEN NO_DATA_FOUND THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;

Line 494: x_return_status := FND_API.G_RET_STS_ERROR;

490: x_return_status := FND_API.G_RET_STS_SUCCESS;
491:
492: EXCEPTION
493: WHEN NO_DATA_FOUND THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: x_error_message_code := 'PA_INV_PAGE_NAME';
496: WHEN TOO_MANY_ROWS THEN
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_error_message_code := 'PA_INV_PAGE_NAME';

Line 497: x_return_status := FND_API.G_RET_STS_ERROR;

493: WHEN NO_DATA_FOUND THEN
494: x_return_status := FND_API.G_RET_STS_ERROR;
495: x_error_message_code := 'PA_INV_PAGE_NAME';
496: WHEN TOO_MANY_ROWS THEN
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_error_message_code := 'PA_INV_PAGE_NAME';
499: WHEN OTHERS THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:

Line 500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

496: WHEN TOO_MANY_ROWS THEN
497: x_return_status := FND_API.G_RET_STS_ERROR;
498: x_error_message_code := 'PA_INV_PAGE_NAME';
499: WHEN OTHERS THEN
500: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
501:
502: END;
503:
504:

Line 641: x_return_status:=fnd_api.g_ret_sts_success;

637: g_module_name VARCHAR2(100) := 'pa.plsql.POPULATE_PERS_FUNCTIONS';
638: l_debug_level5 CONSTANT NUMBER := 5;
639: BEGIN
640: x_msg_count := 0;
641: x_return_status:=fnd_api.g_ret_sts_success;
642: savepoint populate_pers_functions;
643:
644: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
645:

Line 659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

655:
656: EXCEPTION
657: WHEN OTHERS THEN
658: ROLLBACK TO populate_pers_functions;
659: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
660: x_msg_count := 1;
661: x_msg_data := SQLERRM;
662: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.populate_pers_functions',
663: p_procedure_name => PA_DEBUG.G_Err_Stack );