432: EXCEPTION
433: WHEN fnd_api.g_exc_error THEN
434: ROLLBACK TO pn_eam_genealogy;
435: x_return_status := fnd_api.g_ret_sts_error;
436: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
437: WHEN fnd_api.g_exc_unexpected_error THEN
438: ROLLBACK TO pn_eam_genealogy;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: fnd_msg_pub.count_and_get(
436: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
437: WHEN fnd_api.g_exc_unexpected_error THEN
438: ROLLBACK TO pn_eam_genealogy;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: fnd_msg_pub.count_and_get(
441: p_count => x_msg_count
442: ,p_data => x_msg_data);
443: WHEN OTHERS THEN
444: ROLLBACK TO pn_eam_genealogy;
443: WHEN OTHERS THEN
444: ROLLBACK TO pn_eam_genealogy;
445: x_return_status := fnd_api.g_ret_sts_unexp_error;
446:
447: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
448:
449: end pn_genealogy_change;
450:
451:
560:
561: l_stmt_num := 20;
562:
563: -- Initialize message list
564: fnd_msg_pub.initialize;
565:
566: l_stmt_num := 40;
567:
568: -- Initialize API return status to success