APPS.EAM_DEPT_APPROVERS_PVT dependencies on STANDARD

Line 64: -- Standard Start of API savepoint

60: WHERE DEPT_ID = P_DEPT_ID AND RESPONSIBILITY_ID=P_RESPONSIBILITY_ID;
61:
62: BEGIN
63:
64: -- Standard Start of API savepoint
65: SAVEPOINT apiname_apitype;
66:
67: -- Standard call to check for call compatibility.
68: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 67: -- Standard call to check for call compatibility.

63:
64: -- Standard Start of API savepoint
65: SAVEPOINT apiname_apitype;
66:
67: -- Standard call to check for call compatibility.
68: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
69: RAISE fnd_api.g_exc_unexpected_error;
70: END IF;
71:

Line 122: -- Standard check of p_commit.

118: end if;
119: CLOSE C;
120:
121: -- End of API body.
122: -- Standard check of p_commit.
123: IF fnd_api.to_boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126:

Line 127: -- Standard call to get message count and if count is 1, get message info.

123: IF fnd_api.to_boolean(p_commit) THEN
124: COMMIT WORK;
125: END IF;
126:
127: -- Standard call to get message count and if count is 1, get message info.
128: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
129: EXCEPTION
130: WHEN fnd_api.g_exc_error THEN
131: ROLLBACK TO apiname_apitype;

Line 183: -- Standard Start of API savepoint

179: Recinfo C%ROWTYPE;
180:
181: BEGIN
182:
183: -- Standard Start of API savepoint
184: SAVEPOINT apiname_apitype;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 186: -- Standard call to check for call compatibility.

182:
183: -- Standard Start of API savepoint
184: SAVEPOINT apiname_apitype;
185:
186: -- Standard call to check for call compatibility.
187: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
188: RAISE fnd_api.g_exc_unexpected_error;
189: END IF;
190:

Line 222: -- Standard check of p_commit.

218: APP_EXCEPTION.Raise_Exception;
219: end if;
220:
221: -- End of API body.
222: -- Standard check of p_commit.
223: IF fnd_api.to_boolean(p_commit) THEN
224: COMMIT WORK;
225: END IF;
226:

Line 227: -- Standard call to get message count and if count is 1, get message info.

223: IF fnd_api.to_boolean(p_commit) THEN
224: COMMIT WORK;
225: END IF;
226:
227: -- Standard call to get message count and if count is 1, get message info.
228: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231: ROLLBACK TO apiname_apitype;

Line 279: -- Standard Start of API savepoint

275: l_api_version CONSTANT NUMBER := 1.0;
276: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
277:
278: BEGIN
279: -- Standard Start of API savepoint
280: SAVEPOINT apiname_apitype;
281:
282: -- Standard call to check for call compatibility.
283: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 282: -- Standard call to check for call compatibility.

278: BEGIN
279: -- Standard Start of API savepoint
280: SAVEPOINT apiname_apitype;
281:
282: -- Standard call to check for call compatibility.
283: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
284: RAISE fnd_api.g_exc_unexpected_error;
285: END IF;
286:

Line 316: -- Standard check of p_commit.

312: Raise NO_DATA_FOUND;
313: end if;
314:
315: -- End of API body.
316: -- Standard check of p_commit.
317: IF fnd_api.to_boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320:

Line 321: -- Standard call to get message count and if count is 1, get message info.

317: IF fnd_api.to_boolean(p_commit) THEN
318: COMMIT WORK;
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.
322: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
323: EXCEPTION
324: WHEN fnd_api.g_exc_error THEN
325: ROLLBACK TO apiname_apitype;