eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.EAM_ORG_MAINT_DEFAULTS_PVT dependencies on EAM_ORG_MAINT_DEFAULTS

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 122: INSERT INTO eam_org_maint_defaults

118:
119: BEGIN
120:
121: -- Insert row into EOMD
122: INSERT INTO eam_org_maint_defaults
123: (
124: object_type
125: ,object_id
126: ,organization_id

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 269: UPDATE eam_org_maint_defaults SET

265:
266: BEGIN
267:
268: -- Insert row into EOMD
269: UPDATE eam_org_maint_defaults SET
270: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
271: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
272: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
273: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)

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 389: FROM eam_org_maint_defaults

385:
386: -- All validation will done by the calling API
387:
388: SELECT count(*) INTO l_count
389: FROM eam_org_maint_defaults
390: WHERE object_type = p_object_type AND object_id = p_object_id
391: AND organization_id = p_organization_id;
392:
393: IF l_count = 0 THEN

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: