DBA Data[Home] [Help]

APPS.EAM_ASSET_ACTIVITIES_PVT dependencies on FND_MSG_PUB

Line 164: fnd_msg_pub.initialize;

160: END IF;
161:
162: -- Initialize message list if p_init_msg_list is set to TRUE.
163: IF fnd_api.to_boolean(p_init_msg_list) THEN
164: fnd_msg_pub.initialize;
165: END IF;
166:
167: -- Initialize API return status to success
168: x_return_status := fnd_api.g_ret_sts_success;

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

291: COMMIT WORK;
292: END IF;
293:
294: -- Standard call to get message count and if count is 1, get message info.
295: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
296: EXCEPTION
297: WHEN fnd_api.g_exc_error THEN
298: ROLLBACK TO insert_row;
299: x_return_status := fnd_api.g_ret_sts_error;

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

296: EXCEPTION
297: WHEN fnd_api.g_exc_error THEN
298: ROLLBACK TO insert_row;
299: x_return_status := fnd_api.g_ret_sts_error;
300: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN fnd_api.g_exc_unexpected_error THEN
302: ROLLBACK TO insert_row;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: fnd_msg_pub.count_and_get(

Line 304: fnd_msg_pub.count_and_get(

300: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN fnd_api.g_exc_unexpected_error THEN
302: ROLLBACK TO insert_row;
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: fnd_msg_pub.count_and_get(
305: p_count => x_msg_count
306: ,p_data => x_msg_data);
307: WHEN OTHERS THEN
308: ROLLBACK TO insert_row;

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

307: WHEN OTHERS THEN
308: ROLLBACK TO insert_row;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310:
311: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
312: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
313: END IF;
314:
315: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

308: ROLLBACK TO insert_row;
309: x_return_status := fnd_api.g_ret_sts_unexp_error;
310:
311: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
312: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
313: END IF;
314:
315: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
316:

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

311: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
312: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
313: END IF;
314:
315: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
316:
317: END Insert_Row;
318:
319: PROCEDURE LOCK_ROW(

Line 389: fnd_msg_pub.initialize;

385: END IF;
386:
387: -- Initialize message list if p_init_msg_list is set to TRUE.
388: IF fnd_api.to_boolean(p_init_msg_list) THEN
389: fnd_msg_pub.initialize;
390: END IF;
391:
392: -- Initialize API return status to success
393: x_return_status := fnd_api.g_ret_sts_success;

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

493: COMMIT WORK;
494: END IF;
495:
496: -- Standard call to get message count and if count is 1, get message info.
497: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
498: EXCEPTION
499: WHEN fnd_api.g_exc_error THEN
500: ROLLBACK TO lock_row;
501: x_return_status := fnd_api.g_ret_sts_error;

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

498: EXCEPTION
499: WHEN fnd_api.g_exc_error THEN
500: ROLLBACK TO lock_row;
501: x_return_status := fnd_api.g_ret_sts_error;
502: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
503: WHEN fnd_api.g_exc_unexpected_error THEN
504: ROLLBACK TO lock_row;
505: x_return_status := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.count_and_get(

Line 506: fnd_msg_pub.count_and_get(

502: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
503: WHEN fnd_api.g_exc_unexpected_error THEN
504: ROLLBACK TO lock_row;
505: x_return_status := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.count_and_get(
507: p_count => x_msg_count
508: ,p_data => x_msg_data);
509: WHEN OTHERS THEN
510: ROLLBACK TO lock_row;

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

509: WHEN OTHERS THEN
510: ROLLBACK TO lock_row;
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512:
513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
514: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

510: ROLLBACK TO lock_row;
511: x_return_status := fnd_api.g_ret_sts_unexp_error;
512:
513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
514: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
518:

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

513: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
514: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
515: END IF;
516:
517: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
518:
519: END Lock_Row;
520:
521: PROCEDURE UPDATE_ROW(

Line 597: fnd_msg_pub.initialize;

593: END IF;
594:
595: -- Initialize message list if p_init_msg_list is set to TRUE.
596: IF fnd_api.to_boolean(p_init_msg_list) THEN
597: fnd_msg_pub.initialize;
598: END IF;
599:
600: -- Initialize API return status to success
601: x_return_status := fnd_api.g_ret_sts_success;

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

700: COMMIT WORK;
701: END IF;
702:
703: -- Standard call to get message count and if count is 1, get message info.
704: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO update_row;
708: x_return_status := fnd_api.g_ret_sts_error;

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

705: EXCEPTION
706: WHEN fnd_api.g_exc_error THEN
707: ROLLBACK TO update_row;
708: x_return_status := fnd_api.g_ret_sts_error;
709: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
710: WHEN fnd_api.g_exc_unexpected_error THEN
711: ROLLBACK TO update_row;
712: x_return_status := fnd_api.g_ret_sts_unexp_error;
713: fnd_msg_pub.count_and_get(

Line 713: fnd_msg_pub.count_and_get(

709: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
710: WHEN fnd_api.g_exc_unexpected_error THEN
711: ROLLBACK TO update_row;
712: x_return_status := fnd_api.g_ret_sts_unexp_error;
713: fnd_msg_pub.count_and_get(
714: p_count => x_msg_count
715: ,p_data => x_msg_data);
716: WHEN OTHERS THEN
717: ROLLBACK TO update_row;

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

716: WHEN OTHERS THEN
717: ROLLBACK TO update_row;
718: x_return_status := fnd_api.g_ret_sts_unexp_error;
719:
720: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
721: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
722: END IF;
723:
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

717: ROLLBACK TO update_row;
718: x_return_status := fnd_api.g_ret_sts_unexp_error;
719:
720: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
721: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
722: END IF;
723:
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725:

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

720: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
721: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
722: END IF;
723:
724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
725:
726: END Update_Row;
727:
728: END EAM_ASSET_ACTIVITIES_PVT;