157: x_hz_party_bo := l_pos_hz_party_bo;
158:
159: EXCEPTION
160: WHEN no_data_found THEN
161: x_return_status := fnd_api.g_ret_sts_error;
162: x_msg_data := SQLCODE || SQLERRM;
163: x_msg_count := 1;
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
161: x_return_status := fnd_api.g_ret_sts_error;
162: x_msg_data := SQLCODE || SQLERRM;
163: x_msg_count := 1;
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166: x_msg_data := SQLCODE || SQLERRM;
167: x_msg_count := 1;
168:
169: END get_hz_party_bo;