DBA Data[Home] [Help]

APPS.EAM_ORG_MAINT_DEFAULTS_PVT dependencies on EAM_ORG_MAINT_DEFAULTS_PVT

Line 1: PACKAGE BODY eam_org_maint_defaults_pvt AS

1: PACKAGE BODY eam_org_maint_defaults_pvt AS
2: /* $Header: EAMVOMDB.pls 120.1.12020000.3 2013/02/14 13:41:38 rsandepo ship $*/
3: -- Start of comments
4: -- API name : eam_org_maint_defaults_pvt
5: -- Type : Private.

Line 4: -- API name : eam_org_maint_defaults_pvt

1: PACKAGE BODY eam_org_maint_defaults_pvt AS
2: /* $Header: EAMVOMDB.pls 120.1.12020000.3 2013/02/14 13:41:38 rsandepo ship $*/
3: -- Start of comments
4: -- API name : eam_org_maint_defaults_pvt
5: -- Type : Private.
6: -- Function :
7: -- Pre-reqs : None.
8: -- Parameters :

Line 38: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_org_maint_defaults_pvt';

34: -- Notes : Note text
35: --
36: -- End of comments
37:
38: g_pkg_name CONSTANT VARCHAR2(30):= 'eam_org_maint_defaults_pvt';
39:
40:
41: FUNCTION from_fnd_std_num(p_value NUMBER)
42: RETURN NUMBER IS

Line 96: SAVEPOINT eam_org_maint_defaults_pvt;

92: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
93:
94: BEGIN
95: -- Standard Start of API savepoint
96: SAVEPOINT eam_org_maint_defaults_pvt;
97:
98: -- Standard call to check for call compatibility.
99: IF NOT fnd_api.compatible_api_call(
100: l_api_version

Line 190: ROLLBACK TO eam_org_maint_defaults_pvt;

186: fnd_msg_pub.count_and_get(p_count => x_msg_count
187: ,p_data => x_msg_data);
188: EXCEPTION
189: WHEN fnd_api.g_exc_error THEN
190: ROLLBACK TO eam_org_maint_defaults_pvt;
191: x_return_status := fnd_api.g_ret_sts_error;
192: fnd_msg_pub.count_and_get(p_count => x_msg_count
193: ,p_data => x_msg_data);
194: WHEN fnd_api.g_exc_unexpected_error THEN

Line 195: ROLLBACK TO eam_org_maint_defaults_pvt;

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

Line 200: ROLLBACK TO eam_org_maint_defaults_pvt;

196: x_return_status := fnd_api.g_ret_sts_unexp_error;
197: fnd_msg_pub.count_and_get(p_count => x_msg_count
198: ,p_data => x_msg_data);
199: WHEN OTHERS THEN
200: ROLLBACK TO eam_org_maint_defaults_pvt;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;
202: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
203: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
204: END IF;

Line 243: SAVEPOINT eam_org_maint_defaults_pvt;

239: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
240:
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT eam_org_maint_defaults_pvt;
244:
245: -- Standard call to check for call compatibility.
246: IF NOT fnd_api.compatible_api_call(
247: l_api_version

Line 310: ROLLBACK TO eam_org_maint_defaults_pvt;

306: fnd_msg_pub.count_and_get(p_count => x_msg_count
307: ,p_data => x_msg_data);
308: EXCEPTION
309: WHEN fnd_api.g_exc_error THEN
310: ROLLBACK TO eam_org_maint_defaults_pvt;
311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: WHEN fnd_api.g_exc_unexpected_error THEN

Line 315: ROLLBACK TO eam_org_maint_defaults_pvt;

311: x_return_status := fnd_api.g_ret_sts_error;
312: fnd_msg_pub.count_and_get(p_count => x_msg_count
313: ,p_data => x_msg_data);
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: ROLLBACK TO eam_org_maint_defaults_pvt;
316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_msg_pub.count_and_get(p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN OTHERS THEN

Line 320: ROLLBACK TO eam_org_maint_defaults_pvt;

316: x_return_status := fnd_api.g_ret_sts_unexp_error;
317: fnd_msg_pub.count_and_get(p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN OTHERS THEN
320: ROLLBACK TO eam_org_maint_defaults_pvt;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
323: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
324: END IF;

Line 365: SAVEPOINT eam_org_maint_defaults_pvt;

361: l_count NUMBER;
362:
363: BEGIN
364: -- Standard Start of API savepoint
365: SAVEPOINT eam_org_maint_defaults_pvt;
366:
367: -- Standard call to check for call compatibility.
368: IF NOT fnd_api.compatible_api_call(
369: l_api_version

Line 459: ROLLBACK TO eam_org_maint_defaults_pvt;

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

Line 464: ROLLBACK TO eam_org_maint_defaults_pvt;

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

Line 469: ROLLBACK TO eam_org_maint_defaults_pvt;

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

Line 479: END eam_org_maint_defaults_pvt;

475: ,p_data => x_msg_data);
476: END update_insert_row;
477:
478:
479: END eam_org_maint_defaults_pvt;
480: