DBA Data[Home] [Help]

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 1798: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE

1794: from the object.
1795: */
1796: PROCEDURE ams_access_denorm ( errbuf OUT NOCOPY VARCHAR2
1797: , retcode OUT NOCOPY VARCHAR2
1798: , p_full_mode IN VARCHAR2 := Fnd_Api.G_FALSE
1799: )
1800: IS
1801: l_user_id NUMBER := fnd_global.user_id;
1802: l_login_id NUMBER := fnd_global.conc_login_id;

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

1861: OPEN cur_get_latest_start_date ;
1862: FETCH cur_get_latest_start_date INTO l_last_run_date;
1863: CLOSE cur_get_latest_start_date ;
1864:
1865: IF (l_last_run_date IS NULL) OR p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN
1866:
1867: Ams_Utility_Pvt.Write_Conc_Log('** Start the bulk operations ');
1868:
1869: bulk_all_delete_group ;

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

1882:
1883: bulk_update_group (l_last_run_date) ;
1884: Ams_Utility_Pvt.Write_Conc_Log('** End the bulk operations : prev date');
1885:
1886: END IF; -- IF p_full_mode IN (Fnd_Api.G_TRUE, 'Y') THEN
1887:
1888: -- delete all the deleted group associations.
1889: DELETE ams_act_access
1890: WHERE arc_user_or_role_type = 'GROUP'