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
108: x_return_status := fnd_api.g_ret_sts_success;
155:
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.
167: COMMIT WORK;
168: END IF;
169:
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;
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;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;
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
191: ,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
191: ,p_data => x_msg_data);
192: END insert_row;
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
191: ,p_data => x_msg_data);
192: END insert_row;
193:
194:
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
240: x_return_status := fnd_api.g_ret_sts_success;
265:
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.
277: COMMIT WORK;
278: END IF;
279:
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;
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;
291: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;
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
301: ,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
301: ,p_data => x_msg_data);
302: END update_row;
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
301: ,p_data => x_msg_data);
302: END update_row;
303:
304:
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
352: x_return_status := fnd_api.g_ret_sts_success;
411: COMMIT WORK;
412: END IF;
413:
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;
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;
425: x_return_status := fnd_api.g_ret_sts_unexp_error;
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;
430: x_return_status := fnd_api.g_ret_sts_unexp_error;
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
435: ,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
435: ,p_data => x_msg_data);
436: END update_insert_row;
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
435: ,p_data => x_msg_data);
436: END update_insert_row;
437:
438: