DBA Data[Home] [Help]

APPS.EAM_MAINT_ATTRIBUTES_PUB dependencies on EAM_MAINT_ATTRIBUTES_PUB

Line 1: PACKAGE BODY eam_maint_attributes_pub AS

1: PACKAGE BODY eam_maint_attributes_pub AS
2: /* $Header: EAMPMATB.pls 120.4 2006/04/17 04:31:03 yjhabak noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_maint_attributes_pub';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_maint_attributes_pub';

1: PACKAGE BODY eam_maint_attributes_pub AS
2: /* $Header: EAMPMATB.pls 120.4 2006/04/17 04:31:03 yjhabak noship $*/
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_maint_attributes_pub';
5:
6:
7: -- Start of comments
8: -- API name : eam_maint_attributes_pub

Line 8: -- API name : eam_maint_attributes_pub

4: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_maint_attributes_pub';
5:
6:
7: -- Start of comments
8: -- API name : eam_maint_attributes_pub
9: -- Type : Public.
10: -- Function :
11: -- Pre-reqs : None.
12: -- Parameters :

Line 73: SAVEPOINT eam_maint_attributes_pub;

69: l_org_id_2 NUMBER;
70:
71: BEGIN
72: -- Standard Start of API savepoint
73: SAVEPOINT eam_maint_attributes_pub;
74:
75: -- Standard call to check for call compatibility.
76: IF NOT fnd_api.compatible_api_call(
77: l_api_version

Line 195: ROLLBACK TO eam_maint_attributes_pub;

191: fnd_msg_pub.count_and_get(p_count => x_msg_count
192: ,p_data => x_msg_data);
193: EXCEPTION
194: WHEN fnd_api.g_exc_error THEN
195: ROLLBACK TO eam_maint_attributes_pub;
196: x_return_status := fnd_api.g_ret_sts_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN fnd_api.g_exc_unexpected_error THEN

Line 200: ROLLBACK TO eam_maint_attributes_pub;

196: x_return_status := fnd_api.g_ret_sts_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN fnd_api.g_exc_unexpected_error THEN
200: ROLLBACK TO eam_maint_attributes_pub;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: fnd_msg_pub.count_and_get(p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN OTHERS THEN

Line 205: ROLLBACK TO eam_maint_attributes_pub;

201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: fnd_msg_pub.count_and_get(p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN OTHERS THEN
205: ROLLBACK TO eam_maint_attributes_pub;
206: x_return_status := fnd_api.g_ret_sts_unexp_error;
207: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
208: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
209: END IF;

Line 245: SAVEPOINT eam_maint_attributes_pub;

241: l_org_id_2 NUMBER;
242:
243: BEGIN
244: -- Standard Start of API savepoint
245: SAVEPOINT eam_maint_attributes_pub;
246:
247: -- Standard call to check for call compatibility.
248: IF NOT fnd_api.compatible_api_call(
249: l_api_version

Line 316: ROLLBACK TO eam_maint_attributes_pub;

312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: EXCEPTION
315: WHEN fnd_api.g_exc_error THEN
316: ROLLBACK TO eam_maint_attributes_pub;
317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get(p_count => x_msg_count
319: ,p_data => x_msg_data);
320: WHEN fnd_api.g_exc_unexpected_error THEN

Line 321: ROLLBACK TO eam_maint_attributes_pub;

317: x_return_status := fnd_api.g_ret_sts_error;
318: fnd_msg_pub.count_and_get(p_count => x_msg_count
319: ,p_data => x_msg_data);
320: WHEN fnd_api.g_exc_unexpected_error THEN
321: ROLLBACK TO eam_maint_attributes_pub;
322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count
324: ,p_data => x_msg_data);
325: WHEN OTHERS THEN

Line 326: ROLLBACK TO eam_maint_attributes_pub;

322: x_return_status := fnd_api.g_ret_sts_unexp_error;
323: fnd_msg_pub.count_and_get(p_count => x_msg_count
324: ,p_data => x_msg_data);
325: WHEN OTHERS THEN
326: ROLLBACK TO eam_maint_attributes_pub;
327: x_return_status := fnd_api.g_ret_sts_unexp_error;
328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
330: END IF;

Line 361: SAVEPOINT eam_maint_attributes_pub;

357: l_count NUMBER;
358:
359: BEGIN
360: -- Standard Start of API savepoint
361: SAVEPOINT eam_maint_attributes_pub;
362:
363: -- Standard call to check for call compatibility.
364: IF NOT fnd_api.compatible_api_call(
365: l_api_version

Line 460: ROLLBACK TO eam_maint_attributes_pub;

456: fnd_msg_pub.count_and_get(p_count => x_msg_count
457: ,p_data => x_msg_data);
458: EXCEPTION
459: WHEN fnd_api.g_exc_error THEN
460: ROLLBACK TO eam_maint_attributes_pub;
461: x_return_status := fnd_api.g_ret_sts_error;
462: fnd_msg_pub.count_and_get(p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN

Line 465: ROLLBACK TO eam_maint_attributes_pub;

461: x_return_status := fnd_api.g_ret_sts_error;
462: fnd_msg_pub.count_and_get(p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN fnd_api.g_exc_unexpected_error THEN
465: ROLLBACK TO eam_maint_attributes_pub;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count
468: ,p_data => x_msg_data);
469: WHEN OTHERS THEN

Line 470: ROLLBACK TO eam_maint_attributes_pub;

466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get(p_count => x_msg_count
468: ,p_data => x_msg_data);
469: WHEN OTHERS THEN
470: ROLLBACK TO eam_maint_attributes_pub;
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
473: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
474: END IF;

Line 479: END eam_maint_attributes_pub ;

475: fnd_msg_pub.count_and_get(p_count => x_msg_count
476: ,p_data => x_msg_data);
477: END validate_maint_defaults;
478:
479: END eam_maint_attributes_pub ;