4126: RAISE fnd_api.g_exc_unexpected_error;
4127: END IF;
4128:
4129: --standard call to get message count and the message information
4130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4131: --
4132: EXCEPTION
4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4131: --
4132: EXCEPTION
4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;
4141:
4142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;
4141:
4142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4144: END IF;
4145: END get_planned_task;
4146:
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;
4141:
4142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4144: END IF;
4145: END get_planned_task;
4146:
4147: FUNCTION get_tooltip_for_plan_task(
4634: END IF;
4635:
4636: -- Initialize message list if p_init_msg_list is set to TRUE
4637: IF fnd_api.to_boolean(p_init_msg_list) THEN
4638: fnd_msg_pub.initialize;
4639: END IF;
4640:
4641: -- Initialize API return status to success
4642: x_return_status := fnd_api.g_ret_sts_success;
4894: COMMIT WORK;
4895: END IF;
4896:
4897: -- Standard call to get message count and if count is 1, get message info
4898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4899: EXCEPTION
4900: WHEN fnd_api.g_exc_error THEN
4901: ROLLBACK TO drag_n_drop;
4902: x_return_status := fnd_api.g_ret_sts_error;
4899: EXCEPTION
4900: WHEN fnd_api.g_exc_error THEN
4901: ROLLBACK TO drag_n_drop;
4902: x_return_status := fnd_api.g_ret_sts_error;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN
4905: ROLLBACK TO drag_n_drop;
4906: x_return_status := fnd_api.g_ret_sts_unexp_error;
4907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN
4905: ROLLBACK TO drag_n_drop;
4906: x_return_status := fnd_api.g_ret_sts_unexp_error;
4907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4908: WHEN OTHERS THEN
4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911:
4908: WHEN OTHERS THEN
4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911:
4912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4913: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
4914: END IF;
4915:
4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911:
4912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4913: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
4914: END IF;
4915:
4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4917: END drag_n_drop;
4912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4913: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
4914: END IF;
4915:
4916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4917: END drag_n_drop;
4918:
4919: PROCEDURE g_get_custom_color IS
4920: CURSOR c_custom_color IS