DBA Data[Home] [Help]

APPS.EAM_ORG_MAINT_DEFAULTS_PVT dependencies on FND_MSG_PUB

Line 109: fnd_msg_pub.initialize;

105: END IF;
106:
107: -- Initialize message list if p_init_msg_list is set to TRUE.
108: IF fnd_api.to_boolean(p_init_msg_list) THEN
109: fnd_msg_pub.initialize;
110: END IF;
111:
112: -- Initialize API return status to success
113: x_return_status := fnd_api.g_ret_sts_success;

Line 174: fnd_msg_pub.add;

170:
171: EXCEPTION
172: WHEN DUP_VAL_ON_INDEX THEN
173: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_EXISTS');
174: fnd_msg_pub.add;
175: RAISE fnd_api.g_exc_error;
176: END;
177:
178: -- End of API body.

Line 186: fnd_msg_pub.count_and_get(p_count => x_msg_count

182: COMMIT WORK;
183: END IF;
184:
185: -- Standard call to get message count and if count is 1, get message info.
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;

Line 192: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
195: ROLLBACK TO eam_org_maint_defaults_pvt;
196: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 197: 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
200: ROLLBACK TO eam_org_maint_defaults_pvt;
201: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count
206: ,p_data => x_msg_data);

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

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;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count
206: ,p_data => x_msg_data);
207: END insert_row;

Line 205: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;
205: fnd_msg_pub.count_and_get(p_count => x_msg_count
206: ,p_data => x_msg_data);
207: END insert_row;
208:
209:

Line 256: fnd_msg_pub.initialize;

252: END IF;
253:
254: -- Initialize message list if p_init_msg_list is set to TRUE.
255: IF fnd_api.to_boolean(p_init_msg_list) THEN
256: fnd_msg_pub.initialize;
257: END IF;
258:
259: -- Initialize API return status to success
260: x_return_status := fnd_api.g_ret_sts_success;

Line 294: fnd_msg_pub.add;

290:
291: EXCEPTION
292: WHEN NO_DATA_FOUND THEN
293: fnd_message.set_name('EAM', 'EAM_EOMD_RECORD_NOT_FOUND');
294: fnd_msg_pub.add;
295: RAISE fnd_api.g_exc_error;
296: END;
297:
298: -- End of API body.

Line 306: fnd_msg_pub.count_and_get(p_count => x_msg_count

302: COMMIT WORK;
303: END IF;
304:
305: -- Standard call to get message count and if count is 1, get message info.
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;

Line 312: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
315: ROLLBACK TO eam_org_maint_defaults_pvt;
316: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 317: 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
320: ROLLBACK TO eam_org_maint_defaults_pvt;
321: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
325: fnd_msg_pub.count_and_get(p_count => x_msg_count
326: ,p_data => x_msg_data);

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

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;
325: fnd_msg_pub.count_and_get(p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END update_row;

Line 325: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;
325: fnd_msg_pub.count_and_get(p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END update_row;
328:
329:

Line 378: fnd_msg_pub.initialize;

374: END IF;
375:
376: -- Initialize message list if p_init_msg_list is set to TRUE.
377: IF fnd_api.to_boolean(p_init_msg_list) THEN
378: fnd_msg_pub.initialize;
379: END IF;
380:
381: -- Initialize API return status to success
382: x_return_status := fnd_api.g_ret_sts_success;

Line 455: fnd_msg_pub.count_and_get(p_count => x_msg_count

451: COMMIT WORK;
452: END IF;
453:
454: -- Standard call to get message count and if count is 1, get message info.
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;

Line 461: fnd_msg_pub.count_and_get(p_count => x_msg_count

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
464: ROLLBACK TO eam_org_maint_defaults_pvt;
465: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 466: 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
469: ROLLBACK TO eam_org_maint_defaults_pvt;
470: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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;
474: fnd_msg_pub.count_and_get(p_count => x_msg_count
475: ,p_data => x_msg_data);

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

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;
474: fnd_msg_pub.count_and_get(p_count => x_msg_count
475: ,p_data => x_msg_data);
476: END update_insert_row;

Line 474: fnd_msg_pub.count_and_get(p_count => x_msg_count

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;
474: fnd_msg_pub.count_and_get(p_count => x_msg_count
475: ,p_data => x_msg_data);
476: END update_insert_row;
477:
478: