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