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.AMS_ACCESS_DENORM_PVT dependencies on FND_API

Line 30: x_return_status := FND_API.G_RET_STS_SUCCESS;

26: , p_object_id => p_object_id
27: , p_edit_metrics => p_edit_metrics
28: );
29:
30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: EXCEPTION
33: WHEN OTHERS THEN
34: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 34: x_return_status := FND_API.g_ret_sts_unexp_error ;

30: x_return_status := FND_API.G_RET_STS_SUCCESS;
31:
32: EXCEPTION
33: WHEN OTHERS THEN
34: x_return_status := FND_API.g_ret_sts_unexp_error ;
35: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
36: THEN
37: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
38: END IF;

Line 40: p_encoded => FND_API.g_false,

36: THEN
37: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
38: END IF;
39: FND_MSG_PUB.count_and_get (
40: p_encoded => FND_API.g_false,
41: p_count => x_msg_count,
42: p_data => x_msg_data
43: );
44:

Line 64: x_return_status := FND_API.G_RET_STS_SUCCESS;

60: , p_object_id => p_object_id
61: , p_edit_metrics => p_edit_metrics
62: );
63:
64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: EXCEPTION
67: WHEN OTHERS THEN
68: x_return_status := FND_API.G_RET_STS_ERROR;

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

64: x_return_status := FND_API.G_RET_STS_SUCCESS;
65:
66: EXCEPTION
67: WHEN OTHERS THEN
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: END;
70:
71:
72:

Line 94: x_return_status := FND_API.G_RET_STS_SUCCESS;

90: , p_object_id => p_object_id
91: , p_edit_metrics => p_edit_metrics
92: );
93:
94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: EXCEPTION
97: WHEN OTHERS THEN
98: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 98: x_return_status := FND_API.g_ret_sts_unexp_error ;

94: x_return_status := FND_API.G_RET_STS_SUCCESS;
95:
96: EXCEPTION
97: WHEN OTHERS THEN
98: x_return_status := FND_API.g_ret_sts_unexp_error ;
99: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
100: THEN
101: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
102: END IF;

Line 104: p_encoded => FND_API.g_false,

100: THEN
101: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
102: END IF;
103: FND_MSG_PUB.count_and_get (
104: p_encoded => FND_API.g_false,
105: p_count => x_msg_count,
106: p_data => x_msg_data
107: );
108:

Line 127: x_return_status := FND_API.G_RET_STS_SUCCESS;

123: , p_object_id => p_object_id
124: , p_edit_metrics => p_edit_metrics
125: );
126:
127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: EXCEPTION
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_ERROR;

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: x_return_status := FND_API.G_RET_STS_SUCCESS;
128:
129: EXCEPTION
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: END;
133:
134:
135: /* sunkumar: 02-10-03 overloaded delete resource to add error_message also */

Line 156: x_return_status := FND_API.G_RET_STS_SUCCESS;

152: , p_object_id => p_object_id
153: , p_edit_metrics => p_edit_metrics
154: );
155:
156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.g_ret_sts_unexp_error ;

Line 160: x_return_status := FND_API.g_ret_sts_unexp_error ;

156: x_return_status := FND_API.G_RET_STS_SUCCESS;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: x_return_status := FND_API.g_ret_sts_unexp_error ;
161: IF FND_MSG_PUB.check_msg_level (FND_MSG_PUB.g_msg_lvl_unexp_error)
162: THEN
163: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
164: END IF;

Line 166: p_encoded => FND_API.g_false,

162: THEN
163: FND_MSG_PUB.add_exc_msg (g_pkg_name, l_api_name);
164: END IF;
165: FND_MSG_PUB.count_and_get (
166: p_encoded => FND_API.g_false,
167: p_count => x_msg_count,
168: p_data => x_msg_data
169: );
170:

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

185: , p_object_id => p_object_id
186: , p_edit_metrics => p_edit_metrics
187: );
188:
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END;

Line 192: x_return_status := FND_API.G_RET_STS_ERROR;

188:
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: WHEN OTHERS THEN
192: x_return_status := FND_API.G_RET_STS_ERROR;
193: END;
194:
195: PROCEDURE insert_resource( p_resource_id IN NUMBER
196: , p_object_type IN VARCHAR2

Line 831: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE

827: from the object.
828: */
829: PROCEDURE ams_access_denorm ( errbuf OUT NOCOPY VARCHAR2
830: , retcode OUT NOCOPY VARCHAR2
831: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
832: )
833: IS
834: l_user_id NUMBER := fnd_global.user_id;
835: l_login_id NUMBER := fnd_global.conc_login_id;

Line 898: IF (l_last_run_date IS NULL) OR p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN

894: OPEN cur_get_latest_start_date ;
895: FETCH cur_get_latest_start_date INTO l_last_run_date;
896: CLOSE cur_get_latest_start_date ;
897:
898: IF (l_last_run_date IS NULL) OR p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN
899: FOR l_all_access_rec IN cur_get_all_access LOOP
900: IF (l_all_access_rec.delete_flag = 'Y') THEN
901: delete_group( p_group_id => l_all_access_rec.user_or_role_id
902: , p_object_type => l_all_access_rec.arc_act_access_to_object

Line 939: END IF; -- IF p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN

935: , p_edit_metrics => access_rec.admin_flag
936: );
937: END IF;
938: END LOOP; -- for FOR access_rec IN cur_get_access_changes(l_last_run_date) LOOP
939: END IF; -- IF p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN
940:
941: -- delete all the deleted group associations.
942: DELETE ams_act_access
943: WHERE arc_user_or_role_type = 'GROUP'