DBA Data[Home] [Help]

APPS.EAM_ASSET_ACTIVITIES_PVT dependencies on FND_MSG_PUB

Line 159: fnd_msg_pub.initialize;

155: END IF;
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF fnd_api.to_boolean(p_init_msg_list) THEN
159: fnd_msg_pub.initialize;
160: END IF;
161:
162: -- Initialize API return status to success
163: x_return_status := fnd_api.g_ret_sts_success;

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

281: COMMIT WORK;
282: END IF;
283:
284: -- Standard call to get message count and if count is 1, get message info.
285: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
289: x_return_status := fnd_api.g_ret_sts_error;

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

286: EXCEPTION
287: WHEN fnd_api.g_exc_error THEN
288: ROLLBACK TO insert_row;
289: x_return_status := fnd_api.g_ret_sts_error;
290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN
292: ROLLBACK TO insert_row;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: fnd_msg_pub.count_and_get(

Line 294: fnd_msg_pub.count_and_get(

290: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
291: WHEN fnd_api.g_exc_unexpected_error THEN
292: ROLLBACK TO insert_row;
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: fnd_msg_pub.count_and_get(
295: p_count => x_msg_count
296: ,p_data => x_msg_data);
297: WHEN OTHERS THEN
298: ROLLBACK TO insert_row;

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

297: WHEN OTHERS THEN
298: ROLLBACK TO insert_row;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300:
301: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

298: ROLLBACK TO insert_row;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300:
301: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
306:

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

301: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
302: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
303: END IF;
304:
305: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
306:
307: END Insert_Row;
308:
309: PROCEDURE LOCK_ROW(

Line 379: fnd_msg_pub.initialize;

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

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

483: COMMIT WORK;
484: END IF;
485:
486: -- Standard call to get message count and if count is 1, get message info.
487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
488: EXCEPTION
489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
491: x_return_status := fnd_api.g_ret_sts_error;

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

488: EXCEPTION
489: WHEN fnd_api.g_exc_error THEN
490: ROLLBACK TO lock_row;
491: x_return_status := fnd_api.g_ret_sts_error;
492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN
494: ROLLBACK TO lock_row;
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496: fnd_msg_pub.count_and_get(

Line 496: fnd_msg_pub.count_and_get(

492: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
493: WHEN fnd_api.g_exc_unexpected_error THEN
494: ROLLBACK TO lock_row;
495: x_return_status := fnd_api.g_ret_sts_unexp_error;
496: fnd_msg_pub.count_and_get(
497: p_count => x_msg_count
498: ,p_data => x_msg_data);
499: WHEN OTHERS THEN
500: ROLLBACK TO lock_row;

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

499: WHEN OTHERS THEN
500: ROLLBACK TO lock_row;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
504: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
505: END IF;
506:
507: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

500: ROLLBACK TO lock_row;
501: x_return_status := fnd_api.g_ret_sts_unexp_error;
502:
503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
504: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
505: END IF;
506:
507: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
508:

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

503: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
504: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
505: END IF;
506:
507: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
508:
509: END Lock_Row;
510:
511: PROCEDURE UPDATE_ROW(

Line 576: fnd_msg_pub.initialize;

572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE.
575: IF fnd_api.to_boolean(p_init_msg_list) THEN
576: fnd_msg_pub.initialize;
577: END IF;
578:
579: -- Initialize API return status to success
580: x_return_status := fnd_api.g_ret_sts_success;

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

653: COMMIT WORK;
654: END IF;
655:
656: -- Standard call to get message count and if count is 1, get message info.
657: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
658: EXCEPTION
659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;
661: x_return_status := fnd_api.g_ret_sts_error;

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

658: EXCEPTION
659: WHEN fnd_api.g_exc_error THEN
660: ROLLBACK TO update_row;
661: x_return_status := fnd_api.g_ret_sts_error;
662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: ROLLBACK TO update_row;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: fnd_msg_pub.count_and_get(

Line 666: fnd_msg_pub.count_and_get(

662: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
663: WHEN fnd_api.g_exc_unexpected_error THEN
664: ROLLBACK TO update_row;
665: x_return_status := fnd_api.g_ret_sts_unexp_error;
666: fnd_msg_pub.count_and_get(
667: p_count => x_msg_count
668: ,p_data => x_msg_data);
669: WHEN OTHERS THEN
670: ROLLBACK TO update_row;

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

669: WHEN OTHERS THEN
670: ROLLBACK TO update_row;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672:
673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
674: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;
676:
677: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

670: ROLLBACK TO update_row;
671: x_return_status := fnd_api.g_ret_sts_unexp_error;
672:
673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
674: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;
676:
677: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
678:

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

673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
674: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
675: END IF;
676:
677: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
678:
679: END Update_Row;
680:
681: END EAM_ASSET_ACTIVITIES_PVT;