DBA Data[Home] [Help]

APPS.EAM_ORG_MAINT_DEFAULTS_PVT dependencies on FND_MSG_PUB

Line 104: fnd_msg_pub.initialize;

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;

Line 159: fnd_msg_pub.add;

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.

Line 171: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 177: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 182: 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;
186: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 187: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 188: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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;

Line 190: fnd_msg_pub.count_and_get(p_count => x_msg_count

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:

Line 236: fnd_msg_pub.initialize;

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;

Line 269: fnd_msg_pub.add;

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.

Line 281: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 287: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 292: 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;
296: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 297: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 298: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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;

Line 300: fnd_msg_pub.count_and_get(p_count => x_msg_count

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:

Line 348: fnd_msg_pub.initialize;

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;

Line 415: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 421: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;

Line 426: 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;
430: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 431: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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);

Line 432: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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;

Line 434: fnd_msg_pub.count_and_get(p_count => x_msg_count

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: