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 110: --x_ret_code:= fnd_api.g_true;

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

Line 111: x_return_status:=fnd_api.g_ret_sts_success;

107:
108: BEGIN
109: PA_DEBUG.init_err_stack('PA_PAGE_LAYOUT_UTILS.copy_project_page_layouts');
110: --x_ret_code:= fnd_api.g_true;
111: x_return_status:=fnd_api.g_ret_sts_success;
112: savepoint copy_object_page_layouts;
113:
114: VALIDATE_PARAMETERS( p_object_type => p_object_type ,
115: P_object_id_from => P_object_id_from ,

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

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

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

186: x_msg_count => x_msg_count ,
187: x_msg_data => x_msg_data
188: );
189:
190: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
191: l_commit_flag := 'N';
192: END IF;
193: END LOOP;
194:

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

205: P_LAST_UPDATE_DATE => sysdate ,
206: P_LAST_UPDATED_BY => fnd_global.user_id ,
207: P_LAST_UPDATE_LOGIN => fnd_global.user_id
208: );
209: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
210: l_commit_flag := 'N';
211: END IF;
212: END LOOP;
213:

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

223: ROLLBACK TO copy_object_page_layouts;
224: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.copy_object_page_layouts',
225: p_procedure_name => PA_DEBUG.G_Err_Stack );
226:
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228: END COPY_OBJECT_PAGE_LAYOUTS;
229:
230: /* This is the function to check customer and project value columns
231: exists in the project header at the project level. This is for the

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

433: END GET_CONTEXT_NAME;
434:
435:
436: PROCEDURE CHECK_PAGELAYOUT_NAME_OR_ID (
437: p_pagelayout_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
438: p_pagetype_code IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
439: p_check_id_flag IN VARCHAR2 := 'A' ,
440: x_pagelayout_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
441: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895

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

434:
435:
436: PROCEDURE CHECK_PAGELAYOUT_NAME_OR_ID (
437: p_pagelayout_name IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
438: p_pagetype_code IN VARCHAR2 :=FND_API.G_MISS_CHAR ,
439: p_check_id_flag IN VARCHAR2 := 'A' ,
440: x_pagelayout_id IN OUT NOCOPY NUMBER , --File.Sql.39 bug 4440895
441: x_return_status OUT NOCOPY VARCHAR2 , --File.Sql.39 bug 4440895
442: x_error_message_code OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: x_pagelayout_id := null;
478: END IF;
479: END IF;
480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: EXCEPTION
484: WHEN NO_DATA_FOUND THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: EXCEPTION
484: WHEN NO_DATA_FOUND THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: x_error_message_code := 'PA_INV_PAGE_NAME';
487: WHEN TOO_MANY_ROWS THEN
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_error_message_code := 'PA_INV_PAGE_NAME';

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: WHEN NO_DATA_FOUND THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: x_error_message_code := 'PA_INV_PAGE_NAME';
487: WHEN TOO_MANY_ROWS THEN
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_error_message_code := 'PA_INV_PAGE_NAME';
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492:

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

487: WHEN TOO_MANY_ROWS THEN
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_error_message_code := 'PA_INV_PAGE_NAME';
490: WHEN OTHERS THEN
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
492:
493: END;
494:
495:

Line 632: x_return_status:=fnd_api.g_ret_sts_success;

628: g_module_name VARCHAR2(100) := 'pa.plsql.POPULATE_PERS_FUNCTIONS';
629: l_debug_level5 CONSTANT NUMBER := 5;
630: BEGIN
631: x_msg_count := 0;
632: x_return_status:=fnd_api.g_ret_sts_success;
633: savepoint populate_pers_functions;
634:
635: l_debug_mode := NVL(FND_PROFILE.value('PA_DEBUG_MODE'),'N');
636:

Line 650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: ROLLBACK TO populate_pers_functions;
650: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
651: x_msg_count := 1;
652: x_msg_data := SQLERRM;
653: FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_page_layout_utils.populate_pers_functions',
654: p_procedure_name => PA_DEBUG.G_Err_Stack );