[Home] [Help]
6: -- Function :
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
15: -- .
8: -- Parameters :
9: -- IN p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
11: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
12: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
13: -- parameter1
14: -- parameter2
15: -- .
16: -- .
40:
41: FUNCTION from_fnd_std_num(p_value NUMBER)
42: RETURN NUMBER IS
43: BEGIN
44: IF (p_value = fnd_api.g_miss_num) THEN
45: RETURN null;
46: ELSE
47: RETURN p_value;
48: END IF;
51:
52: FUNCTION from_fnd_std_char(p_value VARCHAR2)
53: RETURN VARCHAR2 IS
54: BEGIN
55: IF (p_value = fnd_api.g_miss_char) THEN
56: RETURN null;
57: ELSE
58: RETURN p_value;
59: END IF;
62:
63: PROCEDURE insert_row
64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER
63: PROCEDURE insert_row
64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER
71: ,p_organization_id IN NUMBER
64: (
65: p_api_version IN NUMBER
66: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
67: ,p_commit IN VARCHAR2 := fnd_api.g_false
68: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
69: ,p_object_type IN NUMBER
70: ,p_object_id IN NUMBER
71: ,p_organization_id IN NUMBER
72: ,p_owning_department_id IN NUMBER := NULL
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
96: ,p_api_version
97: ,l_api_name
98: ,g_pkg_name) THEN
95: l_api_version
96: ,p_api_version
97: ,l_api_name
98: ,g_pkg_name) THEN
99: RAISE fnd_api.g_exc_unexpected_error;
100: END IF;
101:
102: -- Initialize message list if p_init_msg_list is set to TRUE.
103: IF fnd_api.to_boolean(p_init_msg_list) THEN
99: RAISE fnd_api.g_exc_unexpected_error;
100: END IF;
101:
102: -- Initialize message list if p_init_msg_list is set to TRUE.
103: IF fnd_api.to_boolean(p_init_msg_list) THEN
104: fnd_msg_pub.initialize;
105: END IF;
106:
107: -- Initialize API return status to success
104: fnd_msg_pub.initialize;
105: END IF;
106:
107: -- Initialize API return status to success
108: x_return_status := fnd_api.g_ret_sts_success;
109:
110: -- API body
111:
112: -- All validation will done by the calling API
156: EXCEPTION
157: WHEN DUP_VAL_ON_INDEX THEN
158: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_EXISTS');
159: fnd_msg_pub.add;
160: RAISE fnd_api.g_exc_error;
161: END;
162:
163: -- End of API body.
164:
162:
163: -- End of API body.
164:
165: -- Standard check of p_commit.
166: IF fnd_api.to_boolean(p_commit) THEN
167: COMMIT WORK;
168: END IF;
169:
170: -- Standard call to get message count and if count is 1, get message info.
170: -- Standard call to get message count and if count is 1, get message info.
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);
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
180: ROLLBACK TO eam_org_maint_defaults_pvt;
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
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);
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
185: ROLLBACK TO eam_org_maint_defaults_pvt;
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;
190: fnd_msg_pub.count_and_get(p_count => x_msg_count
194:
195: PROCEDURE update_row
196: (
197: p_api_version IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
199: ,p_commit IN VARCHAR2 := fnd_api.g_false
200: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
201: ,p_object_type IN NUMBER
202: ,p_object_id IN NUMBER
195: PROCEDURE update_row
196: (
197: p_api_version IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
199: ,p_commit IN VARCHAR2 := fnd_api.g_false
200: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
201: ,p_object_type IN NUMBER
202: ,p_object_id IN NUMBER
203: ,p_organization_id IN NUMBER
196: (
197: p_api_version IN NUMBER
198: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
199: ,p_commit IN VARCHAR2 := fnd_api.g_false
200: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
201: ,p_object_type IN NUMBER
202: ,p_object_id IN NUMBER
203: ,p_organization_id IN NUMBER
204: ,p_owning_department_id IN NUMBER := NULL
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
228: ,p_api_version
229: ,l_api_name
230: ,g_pkg_name) THEN
227: l_api_version
228: ,p_api_version
229: ,l_api_name
230: ,g_pkg_name) THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: IF fnd_api.to_boolean(p_init_msg_list) THEN
231: RAISE fnd_api.g_exc_unexpected_error;
232: END IF;
233:
234: -- Initialize message list if p_init_msg_list is set to TRUE.
235: IF fnd_api.to_boolean(p_init_msg_list) THEN
236: fnd_msg_pub.initialize;
237: END IF;
238:
239: -- Initialize API return status to success
236: fnd_msg_pub.initialize;
237: END IF;
238:
239: -- Initialize API return status to success
240: x_return_status := fnd_api.g_ret_sts_success;
241:
242: -- API body
243:
244: -- All validation will done by the calling API
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
257: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
257: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
258: ,created_by = fnd_global.user_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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
257: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
258: ,created_by = fnd_global.user_id
259: ,creation_date = sysdate
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)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
257: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
258: ,created_by = fnd_global.user_id
259: ,creation_date = sysdate
260: ,last_updated_by = fnd_global.user_id
253: ,activity_cause_code = decode(p_activity_cause_code, fnd_api.g_miss_char, null, null, activity_cause_code, p_activity_cause_code)
254: ,activity_type_code = decode(p_activity_type_code, fnd_api.g_miss_char, null, null, activity_type_code, p_activity_type_code)
255: ,activity_source_code = decode(p_activity_source_code, fnd_api.g_miss_char, null, null, activity_source_code, p_activity_source_code)
256: ,shutdown_type_code = decode(p_shutdown_type_code, fnd_api.g_miss_char, null, null, shutdown_type_code, p_shutdown_type_code)
257: ,tagging_required_flag = decode(p_tagging_required_flag, fnd_api.g_miss_char, null, null, tagging_required_flag, p_tagging_required_flag)
258: ,created_by = fnd_global.user_id
259: ,creation_date = sysdate
260: ,last_updated_by = fnd_global.user_id
261: ,last_update_date = sysdate
266: EXCEPTION
267: WHEN NO_DATA_FOUND THEN
268: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_NOT_FOUND');
269: fnd_msg_pub.add;
270: RAISE fnd_api.g_exc_error;
271: END;
272:
273: -- End of API body.
274:
272:
273: -- End of API body.
274:
275: -- Standard check of p_commit.
276: IF fnd_api.to_boolean(p_commit) THEN
277: COMMIT WORK;
278: END IF;
279:
280: -- Standard call to get message count and if count is 1, get message info.
280: -- Standard call to get message count and if count is 1, get message info.
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);
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
290: ROLLBACK TO eam_org_maint_defaults_pvt;
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
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);
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
295: ROLLBACK TO eam_org_maint_defaults_pvt;
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;
300: fnd_msg_pub.count_and_get(p_count => x_msg_count
305: -- Update if row exists else insert a new row
306: PROCEDURE update_insert_row
307: (
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_commit IN VARCHAR2 := fnd_api.g_false
311: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
312: ,p_object_type IN NUMBER
313: ,p_object_id IN NUMBER
306: PROCEDURE update_insert_row
307: (
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_commit IN VARCHAR2 := fnd_api.g_false
311: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
312: ,p_object_type IN NUMBER
313: ,p_object_id IN NUMBER
314: ,p_organization_id IN NUMBER
307: (
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_commit IN VARCHAR2 := fnd_api.g_false
311: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
312: ,p_object_type IN NUMBER
313: ,p_object_id IN NUMBER
314: ,p_organization_id IN NUMBER
315: ,p_owning_department_id IN NUMBER := NULL
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
340: ,p_api_version
341: ,l_api_name
342: ,g_pkg_name) THEN
339: l_api_version
340: ,p_api_version
341: ,l_api_name
342: ,g_pkg_name) THEN
343: RAISE fnd_api.g_exc_unexpected_error;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF fnd_api.to_boolean(p_init_msg_list) THEN
343: RAISE fnd_api.g_exc_unexpected_error;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF fnd_api.to_boolean(p_init_msg_list) THEN
348: fnd_msg_pub.initialize;
349: END IF;
350:
351: -- Initialize API return status to success
348: fnd_msg_pub.initialize;
349: END IF;
350:
351: -- Initialize API return status to success
352: x_return_status := fnd_api.g_ret_sts_success;
353:
354: -- API body
355:
356: -- All validation will done by the calling API
399: ,x_msg_data => x_msg_data
400: );
401: END IF;
402:
403: IF x_return_status <> fnd_api.g_ret_sts_success THEN
404: RAISE fnd_api.g_exc_error;
405: END IF;
406:
407: -- End of API body.
400: );
401: END IF;
402:
403: IF x_return_status <> fnd_api.g_ret_sts_success THEN
404: RAISE fnd_api.g_exc_error;
405: END IF;
406:
407: -- End of API body.
408:
406:
407: -- End of API body.
408:
409: -- Standard check of p_commit.
410: IF fnd_api.to_boolean(p_commit) THEN
411: COMMIT WORK;
412: END IF;
413:
414: -- Standard call to get message count and if count is 1, get message info.
414: -- Standard call to get message count and if count is 1, get message info.
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);
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
424: ROLLBACK TO eam_org_maint_defaults_pvt;
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
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);
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
429: ROLLBACK TO eam_org_maint_defaults_pvt;
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;
434: fnd_msg_pub.count_and_get(p_count => x_msg_count