DBA Data[Home] [Help]

APPS.EAM_NETWORK_ASSETS_PVT dependencies on FND_MSG_PUB

Line 131: fnd_msg_pub.initialize;

127: END IF;
128:
129: -- Initialize message list if p_init_msg_list is set to TRUE.
130: IF fnd_api.to_boolean(p_init_msg_list) THEN
131: fnd_msg_pub.initialize;
132: END IF;
133:
134: -- Initialize API return status to success
135: x_return_status := fnd_api.g_ret_sts_success;

Line 232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

228: COMMIT WORK;
229: END IF;
230:
231: -- Standard call to get message count and if count is 1, get message info.
232: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
233: EXCEPTION
234: WHEN fnd_api.g_exc_error THEN
235: ROLLBACK TO insert_row;
236: x_return_status := fnd_api.g_ret_sts_error;

Line 237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

233: EXCEPTION
234: WHEN fnd_api.g_exc_error THEN
235: ROLLBACK TO insert_row;
236: x_return_status := fnd_api.g_ret_sts_error;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: ROLLBACK TO insert_row;
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241: fnd_msg_pub.count_and_get(

Line 241: fnd_msg_pub.count_and_get(

237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: WHEN fnd_api.g_exc_unexpected_error THEN
239: ROLLBACK TO insert_row;
240: x_return_status := fnd_api.g_ret_sts_unexp_error;
241: fnd_msg_pub.count_and_get(
242: p_count => x_msg_count
243: ,p_data => x_msg_data);
244: WHEN OTHERS THEN
245: ROLLBACK TO insert_row;

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

244: WHEN OTHERS THEN
245: ROLLBACK TO insert_row;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
250: END IF;
251:
252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

245: ROLLBACK TO insert_row;
246: x_return_status := fnd_api.g_ret_sts_unexp_error;
247:
248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
250: END IF;
251:
252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
253:

Line 252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
249: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
250: END IF;
251:
252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
253:
254: END Insert_Row;
255:
256: PROCEDURE LOCK_ROW(

Line 321: fnd_msg_pub.initialize;

317: END IF;
318:
319: -- Initialize message list if p_init_msg_list is set to TRUE.
320: IF fnd_api.to_boolean(p_init_msg_list) THEN
321: fnd_msg_pub.initialize;
322: END IF;
323:
324: -- Initialize API return status to success
325: x_return_status := fnd_api.g_ret_sts_success;

Line 430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

426: COMMIT WORK;
427: END IF;
428:
429: -- Standard call to get message count and if count is 1, get message info.
430: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433: ROLLBACK TO lock_row;
434: x_return_status := fnd_api.g_ret_sts_error;

Line 435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

431: EXCEPTION
432: WHEN fnd_api.g_exc_error THEN
433: ROLLBACK TO lock_row;
434: x_return_status := fnd_api.g_ret_sts_error;
435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN
437: ROLLBACK TO lock_row;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: fnd_msg_pub.count_and_get(

Line 439: fnd_msg_pub.count_and_get(

435: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
436: WHEN fnd_api.g_exc_unexpected_error THEN
437: ROLLBACK TO lock_row;
438: x_return_status := fnd_api.g_ret_sts_unexp_error;
439: fnd_msg_pub.count_and_get(
440: p_count => x_msg_count
441: ,p_data => x_msg_data);
442: WHEN OTHERS THEN
443: ROLLBACK TO lock_row;

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

442: WHEN OTHERS THEN
443: ROLLBACK TO lock_row;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

443: ROLLBACK TO lock_row;
444: x_return_status := fnd_api.g_ret_sts_unexp_error;
445:
446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
451:

Line 450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

446: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
447: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
448: END IF;
449:
450: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
451:
452: END Lock_Row;
453:
454: PROCEDURE UPDATE_ROW(

Line 513: fnd_msg_pub.initialize;

509: END IF;
510:
511: -- Initialize message list if p_init_msg_list is set to TRUE.
512: IF fnd_api.to_boolean(p_init_msg_list) THEN
513: fnd_msg_pub.initialize;
514: END IF;
515:
516: -- Initialize API return status to success
517: x_return_status := fnd_api.g_ret_sts_success;

Line 566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

562: COMMIT WORK;
563: END IF;
564:
565: -- Standard call to get message count and if count is 1, get message info.
566: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
567: EXCEPTION
568: WHEN fnd_api.g_exc_error THEN
569: ROLLBACK TO update_row;
570: x_return_status := fnd_api.g_ret_sts_error;

Line 571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

567: EXCEPTION
568: WHEN fnd_api.g_exc_error THEN
569: ROLLBACK TO update_row;
570: x_return_status := fnd_api.g_ret_sts_error;
571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO update_row;
574: x_return_status := fnd_api.g_ret_sts_unexp_error;
575: fnd_msg_pub.count_and_get(

Line 575: fnd_msg_pub.count_and_get(

571: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
572: WHEN fnd_api.g_exc_unexpected_error THEN
573: ROLLBACK TO update_row;
574: x_return_status := fnd_api.g_ret_sts_unexp_error;
575: fnd_msg_pub.count_and_get(
576: p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: ROLLBACK TO update_row;

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

578: WHEN OTHERS THEN
579: ROLLBACK TO update_row;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581:
582: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
583: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
584: END IF;
585:
586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

579: ROLLBACK TO update_row;
580: x_return_status := fnd_api.g_ret_sts_unexp_error;
581:
582: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
583: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
584: END IF;
585:
586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
587:

Line 586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

582: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
583: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
584: END IF;
585:
586: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
587:
588: END Update_Row;
589:
590: END EAM_NETWORK_ASSETS_PVT;