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.

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

113:
114: BEGIN
115:
116: -- Insert row into EOMD
117: INSERT INTO eam_org_maint_defaults
118: (
119: object_type
120: ,object_id
121: ,organization_id

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

245:
246: BEGIN
247:
248: -- Insert row into EOMD
249: UPDATE eam_org_maint_defaults SET
250: owning_department_id = decode(p_owning_department_id, fnd_api.g_miss_num, null, null, owning_department_id, p_owning_department_id)
251: ,accounting_class_code = decode(p_accounting_class_code, fnd_api.g_miss_char, null, null, accounting_class_code, p_accounting_class_code)
252: ,area_id = decode(p_area_id, fnd_api.g_miss_num, null, null, area_id, p_area_id)
253: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)

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

355:
356: -- All validation will done by the calling API
357:
358: SELECT count(*) INTO l_count
359: FROM eam_org_maint_defaults
360: WHERE object_type = p_object_type AND object_id = p_object_id
361: AND organization_id = p_organization_id;
362:
363: IF l_count = 0 THEN

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: