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 2006/01/24 10:16:20 yjhabak noship $*/
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 2006/01/24 10:16:20 yjhabak noship $*/
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 91: SAVEPOINT eam_org_maint_defaults_pvt;

87: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
88:
89: BEGIN
90: -- Standard Start of API savepoint
91: SAVEPOINT eam_org_maint_defaults_pvt;
92:
93: -- Standard call to check for call compatibility.
94: IF NOT fnd_api.compatible_api_call(
95: l_api_version

Line 175: ROLLBACK TO eam_org_maint_defaults_pvt;

171: fnd_msg_pub.count_and_get(p_count => x_msg_count
172: ,p_data => x_msg_data);
173: EXCEPTION
174: WHEN fnd_api.g_exc_error THEN
175: ROLLBACK TO eam_org_maint_defaults_pvt;
176: x_return_status := fnd_api.g_ret_sts_error;
177: fnd_msg_pub.count_and_get(p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN

Line 180: ROLLBACK TO eam_org_maint_defaults_pvt;

176: x_return_status := fnd_api.g_ret_sts_error;
177: fnd_msg_pub.count_and_get(p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN fnd_api.g_exc_unexpected_error THEN
180: ROLLBACK TO eam_org_maint_defaults_pvt;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count
183: ,p_data => x_msg_data);
184: WHEN OTHERS THEN

Line 185: ROLLBACK TO eam_org_maint_defaults_pvt;

181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: fnd_msg_pub.count_and_get(p_count => x_msg_count
183: ,p_data => x_msg_data);
184: WHEN OTHERS THEN
185: ROLLBACK TO eam_org_maint_defaults_pvt;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
189: END IF;

Line 223: SAVEPOINT eam_org_maint_defaults_pvt;

219: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
220:
221: BEGIN
222: -- Standard Start of API savepoint
223: SAVEPOINT eam_org_maint_defaults_pvt;
224:
225: -- Standard call to check for call compatibility.
226: IF NOT fnd_api.compatible_api_call(
227: l_api_version

Line 285: ROLLBACK TO eam_org_maint_defaults_pvt;

281: fnd_msg_pub.count_and_get(p_count => x_msg_count
282: ,p_data => x_msg_data);
283: EXCEPTION
284: WHEN fnd_api.g_exc_error THEN
285: ROLLBACK TO eam_org_maint_defaults_pvt;
286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count
288: ,p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN

Line 290: ROLLBACK TO eam_org_maint_defaults_pvt;

286: x_return_status := fnd_api.g_ret_sts_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count
288: ,p_data => x_msg_data);
289: WHEN fnd_api.g_exc_unexpected_error THEN
290: ROLLBACK TO eam_org_maint_defaults_pvt;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN OTHERS THEN

Line 295: ROLLBACK TO eam_org_maint_defaults_pvt;

291: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: fnd_msg_pub.count_and_get(p_count => x_msg_count
293: ,p_data => x_msg_data);
294: WHEN OTHERS THEN
295: ROLLBACK TO eam_org_maint_defaults_pvt;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
297: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
299: END IF;

Line 335: SAVEPOINT eam_org_maint_defaults_pvt;

331: l_count NUMBER;
332:
333: BEGIN
334: -- Standard Start of API savepoint
335: SAVEPOINT eam_org_maint_defaults_pvt;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT fnd_api.compatible_api_call(
339: l_api_version

Line 419: ROLLBACK TO eam_org_maint_defaults_pvt;

415: fnd_msg_pub.count_and_get(p_count => x_msg_count
416: ,p_data => x_msg_data);
417: EXCEPTION
418: WHEN fnd_api.g_exc_error THEN
419: ROLLBACK TO eam_org_maint_defaults_pvt;
420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get(p_count => x_msg_count
422: ,p_data => x_msg_data);
423: WHEN fnd_api.g_exc_unexpected_error THEN

Line 424: ROLLBACK TO eam_org_maint_defaults_pvt;

420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get(p_count => x_msg_count
422: ,p_data => x_msg_data);
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: ROLLBACK TO eam_org_maint_defaults_pvt;
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: fnd_msg_pub.count_and_get(p_count => x_msg_count
427: ,p_data => x_msg_data);
428: WHEN OTHERS THEN

Line 429: ROLLBACK TO eam_org_maint_defaults_pvt;

425: x_return_status := fnd_api.g_ret_sts_unexp_error;
426: fnd_msg_pub.count_and_get(p_count => x_msg_count
427: ,p_data => x_msg_data);
428: WHEN OTHERS THEN
429: ROLLBACK TO eam_org_maint_defaults_pvt;
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
432: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
433: END IF;

Line 439: END eam_org_maint_defaults_pvt;

435: ,p_data => x_msg_data);
436: END update_insert_row;
437:
438:
439: END eam_org_maint_defaults_pvt;
440: